Class Overview

This SQL Server training course is designed for students new to writing SQL queries using SQL Server. The SQL learned in this course is standard to all modern databases, but SQL Server will be used in class and syntax and functionality specific to SQL Server will be pointed out.

Class Goals

MODULE 1

Relational Database Basics

Brief History of SQL

Relational Databases

Tables

Rows

Columns

Relationships

Datatypes

Primary Keys

Foreign Keys

Relational Database Management System

MODULE 2

Popular Databases

Commercial Databases

Popular Open Source Databases

Valid Object References

MODULE 3

SQL Statements

Database Manipulation Language (DML)

Database Manipulation Language (DML)

Database Control Language (DCL)

MODULE 4

Simple SELECT

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

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

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

MODULE 5

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

MODULE 6

Subqueries, Joins and Unions

Subqueries

Joins

Table Aliases

Multi-table Joins

Using Joins

Outer Joins

Unions

UNION ALL

UNION Rules

Working with Unions

MODULE 7

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