The SELECT statement
  • Welcome to Udemy
  • Introduction to Udemy
  • Opening SQL Server Management Studio and creating a database
  • The SELECT clause
  • The SELECT clause - Quiz
  • The SELECT clause
  • The FROM clause
  • The FROM clause - Quiz
  • The FROM clause - connecting to one table
  • The FROM clause - connecting to two tables
  • The WHERE clause
  • The WHERE clause - Quiz
  • The GROUP BY clause
  • The GROUP BY clause - Quiz
  • The HAVING clause
  • The HAVING clause - Quiz
  • The ORDER BY clause
  • The ORDER BY clause - Quiz
Saving queries, and importing into Excel
  • Creating a View
  • Creating a Procedure
  • Importing into Excel
  • Bonus Lecture