Introduction to SQL

2 Days

12 CPD hours

This SQL training course is designed for students new to writing SQL queries.

Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables.

Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases.

Relational Database Basics

• Brief History of SQL
• Relational Databases
• Popular Databases
• SQL Statements

Simple SELECTs

• Introduction to the Northwind Database
• Some Basics
• SELECTing All Columns in All Rows
• Exploring the Tables
• SELECTing Specific Columns
• Sorting Records
• The WHERE Clause and Operator Symbols
• Using the WHERE clause to check for equality or inequality
• Using the WHERE clause to check for greater or less than
• Checking for NULL
• Using WHERE and ORDER BY Together
• The WHERE Clause and Operator Words
• More SELECTs with WHERE
• Checking Multiple Conditions
• Writing SELECTs with Multiple Conditions

Advanced SELECTs

• Calculated Fields
• Calculating Fields
• Aggregate Functions and Grouping
• Working with Aggregate Functions
• Built-in Data Manipulation Functions
• Data Manipulation Functions

Subqueries, Joins and Unions

• Subqueries
• Joins
• Using Joins
• Outer Joins
• Unions
• Working with Unions

If time allows, one or more of the following may be covered:

• Conditional Processing with CASE
• INSERT, UPDATE, DELETE
• Student Challenges - Design your own reports