Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database.
Overview
Syllabus
Introduction
- Welcome
- Using SQL Server Management Studio (SSMS)
- Identifying table relationships
- SSMS diagram support
- Preparing to write SQL
- The basic SELECT statement
- Combining two tables with a join
- Combining multiple tables with a join
- Filtering the data
- Using functions
- Defining the result set
- Manipulating numbers and data types
- Using conditional column output
- Controlling output rows
- Grouping data
Taught by
Jeff Jones