SQL Basics

TRAINING LOCATION:  Mississauga, ON + VIRTUAL Training
GUARANTEED TO RUN

Duration:
2.5 Days/Lecture & Lab

Schedule: TBD

Summary:

Start you Data Science journey with SQL training which will prepare you to get into the exiting world of relational databases.  We will start from relational database overview and get into basic and intermediate SQL commands.  Both at end user and DBA levels.  Most of our training will be on Linux platform, but same principal apply on other platforms once you connect with SQLPlus editor. During the training examples will be provided for other platforms such as Oracle, Microsoft SQL Server and DB2.  At the end of training you will leave with the ability to code simple and intermediate levels.

Prerequisites:
Some prior knowledge of relational databases is helpful
Audience:
Database Administrators, Data Analyst, End Users and IT Managers

Topics:
Key elements of Relational Databases
Primary/Foreign Keys
SELECT Statements
SELECT WHERE Clause Operators
SELECT ORDER BY Clause
SQL Built-in/Supplied Functions
SQL Aggregate Functions/Group By, Having Clauses
Data Manipulation Language (DML) basic
Data Definition Language (DDL) basics
Inner/Outer Joins
Basic Subqueries
Difference between Star and Snow Flake Schema
Data Modelling concepts basics

Microsoft AZ-900
Duration:
1 Day/Lecture & Lab

$699.00 CAD

Topics:
Describe core Azure concepts
Describe core Azure services
Describe core solutions and management tools on Azure
Describe general security and network security features
Describe identity, governance, privacy, and compliance features
Describe Azure cost management and service level agreements

Microsoft DP-900
Duration
1 Day/Lecture & Lab

$699.00 CAD

Topics
Explore core data concepts
Explore relational data in Azure
Explore non-relational data in Azure
Explore modern data warehouse analytics in Azure
Exam Questions preparation — over 200 questions/answers
Exam voucher included value — $99 dollars