T-SQL Essentials

Home > Courses

No Upcoming Course Dates Scheduled

Contact us to schedule a date!

About this Course

Are you itching to get your hands on data locked away in an SQL database?

This course provides a solid practical grounding with lots of hands-on exercises using the SQL SELECT command, the workhorse for getting data out of an SQL database.

T-SQL Essentials Course Outline

  1. About this Course
  2. SQL Server Management Studio
  3. Key Concepts: Database, Table, Column
  4. SELECT
  5. WHERE (Filter Text)
  6. Key Concepts: Data Types
  7. WHERE (Filter Numbers)
  8. WHERE (Filter Dates)
  9. WHERE (Filter NULL)
  10. Column Aliases (AS)
  11. ORDER BY
  12. SELECT DISTINCT
  13. AGGREGATE Functions
  14. GROUP BY (with SQL)
  15. GROUP BY (with Excel Pivot Table using an SQL table)
  16. Key Concepts: Primary Key, Foreign Key, Relationship, Referential Integrity
  17. JOIN
  18. LEFT/RIGHT JOIN
  19. GROUP BY (with Excel Pivot Table using an SQL Query)

Related Courses

T-SQL Intermediate
T-SQL Advanced
SSRS Reporting Services