Introduction
  • Course Introduction
  • What if I'm on a Mac?
  • Downloading Microsoft SQL Server
  • Installing Microsoft SQL Server
  • Installing Our Large Dataset (Nile Trading) Database
  • Generating a Large Amount of Data
  • Coding and Style Conventions
Additional JOINs
  • Self JOINs
  • CROSS Joins
Modifying Data
  • INSERT with SELECT
  • UPDATE with JOIN
  • DELETE with JOIN
Importing Data
  • Import data from CSV
  • Using MERGE Statement
Aggregation
  • ROLLUP and CUBE
  • GROUPING SETS
Indexes, Keys and Constraints
  • Indexing and Index Types
  • Primary and Foreign Keys
  • Constraints
Views, Common Table Expressions and Windowed Functions
  • VIEWs
  • Common Table Expressions Part 1
  • Common Table Expressions Part 2
  • RANK and ROWNUMBER
  • Deciles and Quartiles with NTILE
Triggers and Temporary Tables
  • Introducing Triggers
  • Temporary Tables
TransactSQL for Stored Procedures and Functions
  • Writing TransactSQL Part 1
  • Writing TransactSQL Part 2 (transactions and try/catch)
  • Table Functions
  • Scalar Functions
Performance Tuning
  • Basic Optimisation Tips
  • More Optimisation
  • Indexed Views
Wrap-Up
  • What we Covered
  • Next Steps