SQL Training Course 

A. for Financial & Business Analysts: 1 day

B. for Data Scientists: 2 days

Note: this outline is our proposal, but the training can be tailored to your specific requirements upon prior request ahead of the proposed course date.

Why learn SQL?

SQL is a powerful and globally-used database programming language.

 

A. In this course, aimed at Business Analysts and Financial professionals, you will learn the most common usage of SQL, providing you with the knowledge required to start writing SQL code and to learn about MS SQL Server.

The course is interactive and hands-on, with enough exercises to help the participants consolidate the acquired knowledge.

B. This course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

By the end of this course you will:

  • Understand how relational databases work

  • Learn to use SQL to output reports

  • Learn to write queries getting data from multiple tables

​​Course details

The agenda covers both fundamentals and advanced topics.

The final training outline will be designed depending on your particular requirements.

The practical exercises constitute a big part of the course time, besides demonstrations and theoretical presentations. Discussions and questions can be asked throughout the course.

 

Course Outline - Financial and Business Analysts

Introduction

  • SQL Server Management Studio

  • Commenting code

  • Data import/export

  • Table functions

  • Column operations

Data Analysis and Manipulation

  • Selecting data

  • Data filtering

  • Data update

  • Views

  • Functions

Joins

  • Keys

  • Aliases

  • Left join

  • Inner join

  • Full outer join

Advanced Data Analysis and Manipulation

  • Pattern searching

  • Aggregation

  • Mathematical operations

  • Stored procedures

  • Nested queries

Course Outline - Data Scientists

1. Relational Database Basics

Brief History of SQL

Relational Databases

  • Tables

  • Rows

  • Columns

  • Relationships

  • Datatypes

  • Primary Keys

  • Foreign Keys

  • Relational Database Management System

Popular Databases

  • Commercial Databases

  • Popular Open Source Databases

  • Valid Object References

SQL Statements

  • Database Manipulation Language (DML)

  • Database Definition Language (DDL)

  • Database Control Language (DCL)

2. Simple SELECTs

Introduction to the Northwind Database

Some Basics

  • Comments

  • Whitespace and Semi-colons

  • Case Sensitivity

SELECTing All Columns in All Rows

Exploring the Tables

SELECTing Specific Columns

Sorting Records

  • Sorting By a Single Column

  • Sorting By Multiple Columns

  • Sorting By Column Position

  • Ascending and Descending Sorts

The WHERE Clause and Operator Symbols

  • Checking for Equality

  • Checking for Inequality

  • Checking for Greater or Less Than

  • Checking for NULL

  • WHERE and ORDER BY

The WHERE Clause and Operator Words

  • The BETWEEN Operator

  • The IN Operator

  • The LIKE Operator

  • The NOT Operator

More SELECTs with WHERE

Checking Multiple Conditions

  • AND

  • OR

  • Order of Evaluation

Writing SELECTs with Multiple Conditions

3. Advanced SELECTs

Calculated Fields

  • Concatenation

  • Mathematical Calculations

  • Aliases

Calculating Fields

Aggregate Functions and Grouping

  • Aggregate Functions

  • Grouping Data

  • Selecting Distinct Records

Working with Aggregate Functions

Built-in Data Manipulation Functions

  • Common Math Functions

  • Common String Functions

  • Common Date Functions

Data Manipulation Functions

4. Subqueries, Joins and Unions

Subqueries

Joins

  • Table Aliases

  • Multi-table Joins

Using Joins

Outer Joins

Unions

  • UNION ALL

  • UNION Rules

Working with Unions