SQL Server Transact-SQL
Course Description
This course gives students the ability to write queries that include flow control and parameter handling. It also covers Microsoft’s Full Text Indexing, and the implementation of Stored Procedures, Triggers and User Defined Functions in SQL Server 2000 and above.Duration: 1 day
Content
Overview of SQL ServerOverview of Transact-SQL
Programming in Transact-SQL
Using the SELECT statement
Formatting the results set
Inserting data
Deleting data
Updating data
Working with aggregate functions
Grouping data
Joining tables
Querying multiple tables
Implementing advanced table joins
Designing sub-queries
Working with Full-Text indices
Implementing the Microsoft Search Service
Querying Full-Text indices
Programming Transact-SQL
Creating and managing views
Implementing Stored Procedures
Implementing Triggers
Implementing User Defined Functions