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

NobleProg (Canada) Logo

Data Management Training Courses

Onsite, instructor-led live Data Management training courses demonstrate through interactive hands-on practice the fundamentals and advanced topics of Data Management.

by NobleProg (Canada) [Claim Listing ]
PMVISION Logo

Oracle Primavera P6 Training Course

The Primavera P6 Training Course will prepare you to efficiently track your project teams, schedules, tasks, and finances, manage your entire project, and accurately report your progress to date.

by PMVISION [Claim Listing ]
Formation SETC Logo

Oracle Training

The SETC Montreal-Ottawa Training Oracle courses teach you how to install, configure, and manage an Oracle database server under Windows or Linux. Our training covers the installation and administration of Oracle, Oracle Forms & Reports, and the Oracle GRID infrastructure.

by Formation SETC [Claim Listing ]
HiTech Institute Logo

Integrating Data Encryption into a Microsoft® SQL Server™ 2005

In this course, you apply guidelines and considerations for securing data using encryption and certificates. You describe various data encryption policies. Finally, you determine a key storage method.

by HiTech Institute [Claim Listing ]
MindTech Montreal Logo

Microsoft Suite Training (SSIS-SSAS-SSRS)

The Microsoft Suite training (SSIS-SSAS-SSRS) allows you to design and deploy a Business Intelligence solution with SQL Server.

by MindTech Montreal [Claim Listing ]

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