Introduction to Course
  • Welcome
Installation of Software
  • Installing Microsoft SQL Server 2014 Express Edition
  • Installing Microsoft SQL Server Management Studio
  • Installing AdventureWorks2014
Understanding Key Terms
  • What is SQL
  • Overview of Database/Table/Column
SELECT Statement and FROM Clause Explained
  • Using SELECT * Statement and FROM Clause
  • SELECT Pre-Chosen Columns
  • SELECT TOP 50 *
  • SELECT TOP 50 of Pre-Chosen Columns
  • Using SELECT Statement with AS
  • Using Comments
Understanding WHERE Clause
  • Using WHERE Clause with >
  • Using WHERE Clause with =
  • Using WHERE Clause with = AND >
  • Using WHERE Clause with = OR <
  • Using WHERE Clause with BETWEEN
  • Using WHERE Clause with LIKE
  • Using WHERE Clause with IS NOT NULL
  • Using WHERE Clause with IS NULL
ORDER BY Clause Explained
  • Using ORDER BY Clause (Order by Column Name in Descending Order)
  • Using ORDER BY Clause (Order by Position of Column Name)
  • Using ORDER BY Clause (Order by Alternate Name of Column in Descending Order)
How To Use WHERE and ORDER BY Clauses Together
  • Using WHERE and ORDER BY Clauses Together
Conclusion
  • Summary