SQL Programming

by The Data Steps Claim Listing

SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

The Data Steps Logo

img Duration

35 Hours

Course Details

SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know.

 

Module 1

SQL Toolkit

  • Introduction
  • Installation and getting started
  • Case Study: Demo
  • Fundamental SQL statements

 

Module 2

Advanced Stuff

  • Subqueries
  • Views and Indexes
  • String Functions
  • Mathematical Functions

 

Module 3

Basic Operations

  • Restore and backup
  • Selection commands: Filtering
  • Selection commands: Ordering
  • Alias

 

Module 4

Nailing the Interview

  • Date-Time Functions
  • PATTERN (STRING) MATCHING
  • Data Type conversion functions
  • User Access Control Functions
  • Bonus Section: Nail That Interview!

 

Module 5

Aggregations and Joins

  • Aggregate Commands
  • Group by Commands
  • Conditional Statement
  • JOINS
  • Toronto Branch

    922 The East Mall #100, Toronto

Check out more SQL Server courses in Canada

OptionTrain College Of Management & Technology Logo

Microsoft SQL Server 2012 Querying for Analyst

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012.

by OptionTrain College Of Management & Technology [Claim Listing ]
Training Hub Logo

Microsoft SQL Developer Course

During this course of SQL Server Training for Development, you will be able to learn about SQL architecture, server/client relations, stored procedures, functions, SELECT statements, data types, and views.

by Training Hub [Claim Listing ]
Thinkcloudly Learning Institute Logo

Oracle Certification (Oracle Database Administration (1Z0-082))

Thinkcloudly provides the most comprehensive and one of the best Oracle database administration trainings. Learn the intricacies of Oracle certification in our comprehensive course.

by Thinkcloudly Learning Institute [Claim Listing ]
OptionTrain College of Management and Technology Logo

Microsoft SQL Server 2012 Querying for Analyst

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012.

by OptionTrain College of Management and Technology [Claim Listing ]
(BTT) Business And Technical Training College Logo

Database Analysis

The course introduces students to Excel features and commands that are needed to analyze large datasets in order to make informed business decisions. It teaches how to gather and organize data for operational analysis. And, learn various analysis terminologies for effective communications.

by (BTT) Business And Technical Training College

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy