|
Course Title:
|
End to End TSQL Register Now!
|
|
Duration:
|
2 days
|
|
Overview:
|
This two day class is designed to cover all aspects of T-SQL programming from writing simple queries to solving complex problems. The students will gain real world T-SQL skills as they apply concepts covered in the lectures to the hand-on labs.
|
|
Prerequisites:
|
This class is targeted to IT professionals and developers who need a basic foundation in T-SQL. No previous knowledge of T-SQL is required; however, the student should be familiar with at least one programming language.
|
|
Course Materials:
|
All students will receive a printed copy of the course materials.
|
|
Outline:
|
Day 1
- Module 1: Getting Started
- Database Concepts
- SQL Server Security
- SQL Server Management Studio
- Hands-on Lab
- Module 2: Writing Simple Queries
- SELECT statement
- Filtering data
- Ordering data
- Hands-on Lab
- Module 3: Using Expressions
- Functions and operators
- CASE
- Working with NULL
- Hands-on Lab
- Module 4: Joining Tables
- Inner joins
- Outer joins
- Self joins
- Sub-queries
- Virtual tables
- UNION queries
- Common Table Expressions
- Hands-on Lab
- Module 5: Grouping and Summarizing Data
- Aggregate functions
- GROUP BY clause
- HAVING clause
- Hands-on Lab
Day 2
- Module 6: Updating Data
- Inserting new rows
- Updating existing rows
- Deleting rows
- Hands-on Lab
- Module 7: Beyond Tables ? Other Database Objects
- Views
- Stored Procedures
- User Defined Functions
- Triggers
- Hands-on Lab
- Module 8: T-SQL Programming Logic
- IF
- WHILE
- Variables
- Temp tables and table variables
- Explicit transactions
- Error trapping
- Hands-on Lab
- Module 9: CLR Integration
- Stored procedures
- Functions
- User defined aggregates
- Hands-on Lab
- Module 10: Advanced Topics
- Ranking and row number functions
- Top and Tablesample
- Using a numbers table
- Pivot/Unpivot
- SQL Server 2008 Enhancements
|