SQL 3-Day Course, MS SQL Server

MS SQL Server Course Outline
Session 1: Database Concepts 
To assist with the SQL aspects of the SQL Course, we also cover database basics. What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types. The Information_Schema 
Session 2: Using the SQL client 
SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts 
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Precedence of operators 
Session 4: LIMIT / TOP, UNION Queries and SQL AGGREGATE Functions 
The LIMIT and TOP clauses, Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Rollup with Group By, Having. 
Session 5: SQL Subqueries, Basic Subqueries, Nested Subqueries, “WITH AS” 
Joins: SQL Cartesian products, SQL Joins (Inner join, Left join, Right join, Full join) Table aliases, Natural joins, Join using, Join on, Multi-table joins, Union, Union All, Except, Intersect 
Session 6: SQL Numeric Functions (ABS, SIGN, MOD, etc.) and String Functions (Locate, Left, Right, Concat, etc), DATE and TIME functions 
Session 7: SQL Views (Create, alter and drop), Stored Procedures with Input and Output parameters 
Session 8: Creating Databases and Tables 
Session 9: SQL Indexes 
Session 10: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits 
Session 11: SQL Server Access Control 
Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges 
Session 12: Import data into SQL and Export from SQL 
Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line