Introduction
  • Welcome To The Course
  • Is this Course Right For You?
  • A Quick Look at Objects
  • Installing SQL Server Express Edition
  • Installing Adventureworks Training Database
  • Working With SQL Server Management Studio
  • The Query Editor
  • Terminology
  • Summary
  • Quiz
Writing Transact-SQL Overview
  • A Query is Like a Sentence
  • DML VS DDL
  • Use Statement
  • The Table Object
  • Inserting Data Into a Table
  • Lecture 14 Summary. Yes, lecture 14 was that important.
  • How do Tables Relate?
  • Formatting and Commenting
  • Data Definition Language
  • Creating Our First Stored Procedure
  • Input Parameters
  • Create Stored Procedure for Inserts
  • Terminology
  • Summary
  • Quiz
Data Manipulation Language
  • Anatomy of a SELECT Statement
  • Schemas
  • Column Aliasing
  • Derived Column
  • Using the DATEDIFF function
  • Creating a View
  • Basic Comparison Operators
  • The Like Clause
  • Logical Comparisons
  • The NULL
  • Extended Filtering
  • Filtering With Parenthesis
  • Summary
  • Quiz
Functions
  • Anatomy of a Function
  • User Defined Function
  • Inline Table-Valued Function
  • Multi-Statement Table Valued User Defined Functions
  • Aggregate Functions
  • Count(ALL) Versus Count(Distinct)
  • Conversion Functions
  • Summary
  • Quiz
More Advanced Transact-SQL
  • Subqueries in the SELECT Statement
  • Having Clause
  • Common Table Expressions
  • Summary
  • Quiz
Conclusion
  • Final Thoughts and Thank You!!!!