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
Introduction
- Welcome
Discovering the Database
- Using SQL Server Management Studio (SSMS)
- Identifying table relationships
- SSMS diagram support
- Preparing to write SQL
Accessing Tables
- The basic SELECT statement
- Combining two tables with a join
- Combining multiple tables with a join
Filtering the Data
- Filtering the data
- Using functions
Displaying Data
- Defining the result set
- Manipulating numbers and data types
- Using conditional column output
- Controlling output rows
Aggregating Data
- Grouping data