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

Camosun Coastal Centre Logo

Database 12c Administration Workshop

Database 12c Administration course is offered by Camosun Coastal Centre. The Camosun Coastal Centre (CCC) brokers training to enhance workforce development in the shipbuilding industry.

by Camosun Coastal Centre [Claim Listing ]
HiTech Institute Logo

Oracle Database

In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

by HiTech Institute [Claim Listing ]
University Of Calgary Logo

Certificate in Database Administration

Microsoft SQL Server is the backbone for thousands of industry-leading software applications, including Microsoft SharePoint and SAP. You will learn how to design, develop, administer, and troubleshoot Microsoft SQL databases and servers.

by University Of Calgary [Claim Listing ]
  • Price
  • Start Date
  • Duration
OCMT (Ontario College of Management & Technology) Logo

Oracle Database (Suite 1)

To effectively and efficiently manage today’s business-critical information, organizations depend on database systems that are flexible, reliable, and scalable and on experienced professionals to handle them.

by OCMT (Ontario College of Management & Technology) [Claim Listing ]
  • Price
  • Start Date
  • Duration
VoiSAP Calgary Logo

Oracle DBA Certification Training

Moreover, with our lifelong access to the courseware and community features, you can revisit any topic whenever you want. Get the best  Oracle Database Administrator course from top certified mentors.

by VoiSAP Calgary [Claim Listing ]

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