Welcome to the SQL DEEP DIVE course

Course Overview

Installation Guide
Useful environment settings, Adding comments to queries, The basic query structure, Using field aliases and Common mistakes

Introduction
Useful environment settings, Adding comments to queries, The basic query structure, Using field aliases and Common mistakes

Writing Queries
Useful environment settings, Adding comments to queries, The basic query structure, Using field aliases and Common mistakes

Sorting Query Results
The ORDER BY clause, Sorting multiple fields, Finding the Top 10 records

The WHERE Clause
Using number criteria, Text Criteria, Wildcards, Date Criteria, Using AND and OR operators

Creating Calculated Columns
Where to write calculations, Sorting results in calculations, Using calculations in criteria, Data Types and cautionary tips

The CASE statement
Why are they used, Using CASE statements with numbers, text and dates

Joins in Queries
Why are they needed, Understanding the database structure, Inner joins, Outer joins, Find unmatched records, Full joins

Using Functions in Queries
Finding available functions, Understand parameters, Getting help on functions, Nesting functions

Working with Text in Queries
Concatenating strings of text, Concatenating text and numbers, Text functions, Separating strings of text

Working with Dates in Queries
Formatting dates, Creating custom date formats, Calculating the difference between dates, Calculating age in years accurately

Aggregate Functions
What are aggregate functions, Five most commonly used functions, Cautions with data types and functions

Grouping Data
The GROUP BY clause, Adding grand totals, Using criteria in grouping queries, Grouping by multiple columns

Using Subqueries
What is a subquery, Using subqueries in the WHERE clause, Using subqueries in the SELECT list, Adding criteria to subquery, Using subqueries to return multiple values

Creating Correlated Subqueries
Revisit normal subqueries, Create correlated subqueries, Using table aliases, how do correlated subqueries, Using comparison operators, Using calculated fields

Using SQL Server Management Tools
SQL Server Configuration Manager, Creating a start menu shortcut, Starting and stopping services, Setting services to run automatically, Using SQL Server Management Studio, Connecting and disconnecting servers, Rearranging windows

SQL Server System Databases
Viewing system databases, The Master database, Backing up and restoring the Master database, The model database, MSDB database, Temp database

SQL Server Databases and Security
Creating new databases, The database owner and properties, The database objects, Logins and connections, Users and databases, Server and database roles, Creating and using schemas

Basic SQL Server Tables
Creating a table, Defining column names, Choosing data types, Allowing NULLs, Adding Constraints to columns, Entering data, Creating table and data scripts

Designing Relational Databases
Creating a single table and sample data, Normalizing data, Identifying repeat information, Creating multiple tables, Primary keys and identity columns, Foreign keys and relationships, database diagrams, one to many relationships, many to many relationships

Creating Computed Columns
Why create computed columns, Adding a computed column, Basic Expressions, Persisting computed values, Using SQL Server functions

Installing SQL Training Wheels Sample Database
Downloading and Executing the Script, Viewing tables in design view, Viewing and editing table data, Primary keys and foreign keys, Creating a database diagram, Types of relationships, Alternative database diagrams

Installing SQL Server Data Tools
What is SQL Server Data Tools, Optionally installing Visual Studio 2015, Installing SQL Server Data Tools, Running Visual Studio 2015, Creating a Business Intelligence Project, Working in Visual Studio

Resources