In order to play this video, you will need to install Adobe Flash player for your browser.
At Course Completion
At the end of the course, students will be able to:
Describe the uses of the Transact-SQL language.
Write SELECT queries to retrieve data.
Modify data by using Transact-SQL.
Write complex queries by using functions and control-of-flow language in batches and scripts.
Write queries that summarize data.
Join data from multiple tables.
Write queries that retrieve and modify data by using subqueries.
Query text fields with full-text search.
Write queries to solve business problems.
Prerequisites
An understanding of basic relational database concepts, including:
Logical and physical database design.
Data integrity concepts.
Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
How data is stored in tables (rows and columns).
Course Outline
Module 1: Introduction to Transact-SQL
The Transact-SQL Programming Language
Types of Transact-SQL Statements
Data Manipulation Language Statements
Transact-SQL Syntax Elements
Module 2: Using Transact-SQL Programming Tools
SQL Server Programming Tools
Ways to Execute Transact-SQL Scripts
Module 3: Retrieving Data
Retrieving Data
Filtering Data
Formatting Result Sets
How Queries Are Processed
Performance Considerations
Module 4: Grouping Data
Listing the TOP n Values
Using Aggregate Functions
GROUP BY Fundamentals
Generating Aggregate Values Within Result Sets
Using the COMPUTE and COMPUTE BY Clauses
Module 5: Joining Multiple Tables
Using Aliases for Table Names
Combining Data from Multiple Tables
Combining Multiple Result Sets
Module 6: Working with Subqueries
Introduction to Subqueries
Using a Subquery as a Derived Table
Using a Subquery as an Expression
Using a Subquery to Correlate Data
Using the EXISTS and NOT EXISTS Clauses
Module 7: Modifying Data
Using Transactions
Inserting Data
Deleting Data
Updating Data
Performance Considerations
Module 8: Querying Full-Text Indexes
Microsoft Search Service
Microsoft Search Service Components
Getting Information About Full-Text Indexes
Writing Full-Text Queries
Module 9: Introduction to Programming Objects
What Is a View
Advantages of Views
Defining Views
Introduction to Stored Procedures
Introduction to Triggers
Introduction to User-Defined Functions
Module 10: Writing Queries to Solve Business Problems
Leveraging Transact-SQL Script
Surveying Data
Working with Data Sets
Processing Conditional Data