Learning Transact-SQL
4h 47mBeginner2013-01-25
Authors
Jeff Jones
Working in the IT industry for almost forty years
Course details
Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database. Jeff Jones, an IT professional with over forty years of experience shows you how to use the tools available in Transact-SQL to discover the database definition, access tables, submit queries, and view the results.
Skills covered
SQL ServerDatabase DevelopmentDatabase ManagementLearningMicrosoftSoftware Development
Concepts
0. Introduction
- 01 - Welcome
1. Discovering the Database
- 02 - Using SQL Server Management Studio (SSMS)
- 03 - Identifying table relationships
- 04 - SSMS diagram support
- 05 - Preparing to write SQL
2. Accessing Tables
- 06 - The basic SELECT statement
- 07 - Combining two tables with a join
- 08 - Combining multiple tables with a join
3. Filtering the Data
- 09 - Filtering the data
- 10 - Using functions
4. Displaying Data
- 11 - Defining the result set
- 12 - Manipulating numbers and data types
- 13 - Using conditional column output
- 14 - Controlling output rows
5. Aggregating Data
- 15 - Grouping data