Home >> IT Training >> Microsoft Classes

SQL Server T-SQL with Advanced Topics Training Classes

Why is our SQL Server T-SQL with Advanced Topics training class different from other's you might find on the web? We hire only full-time, qualified IT consultants with years of experience and the talent to pass that knowledge on to you. Because the course is taught by real teachers in real time, you can get your workplace questions answered and put those answers to work right away. Our 4-day immersion IT training classes allow for concentrated study of the subject in 14 intense labs and assures that you leave confident in your new abilities.

Our course begins with an overview of SQL Server 2005 including editions, components and tools. You will learn to design and create a database and work with SQL Server Management Studio. You will create stored procedures, triggers and user-defined functions. We will teach you to implement Server partitions and use complex querying and advanced techniques including working with XML. This course is for database administrators and developers who use SQL Server. Qualified students should have working experience with SQL Server 2000 or 2005.

For companies with six or more employees who need this training, our online SQL Server T-SQL with Advanced Topics training class can save both time and money. Because we bring the classroom to your facility, your employees can avoid extra commute time and we can save you 30% off the cost of a course taught in a traditional classroom setting. All you provide is a training room at your location, and we'll bring the rest.

If you are ready to take the next step in your IT career, enroll in our SQL Server T-SQL with Advanced Topics training class today. Just click on the blue button to get started and stay one step ahead of the competition.

Enrollment Fee: $2595.00 USD
Number of Class Days: 4

SQL Server T-SQL with Advanced Topics schedule:
	Mar 30 - Apr 2, 2009	Orlando, FL
	Apr 14 - 17, 2009	Raleigh, NC
	Apr 28 - May 1, 2009	Chicago (Schaumburg), IL
	May 5 - 8, 2009	Washington, DC
	May 19 - 22, 2009	Dallas, TX
	Jun 9 - 12, 2009	San Jose, CA
	Jun 16 - 19, 2009	New York, NY
	Jun 16 - 19, 2009	Atlanta, GA
	Jul 7 - 10, 2009	San Francisco, CA
	Jul 21 - 24, 2009	Morristown, NJ
	Aug 4 - 7, 2009	Washington, DC
	Sep 1 - 4, 2009	Chicago (Schaumburg), IL
	Sep 15 - 18, 2009	Dallas, TX

Training Class Outline:

1. A Tour of SQL Server 2005

*SQL Server 2005 Editions, Components, and Tools
*Using SQL Server Management Studio (SSMS)
*Working with Tables and Queries
*New Transact-SQL Features
*Business Intelligence Services

2. Designing and Creating a Database

*Relational Database Design Principles
*Implementing the Design

3. Data Selection Queries

*Understanding Transact-SQL
*The SELECT Statement
*The WHERE Clause
*Using ORDER BY to Sort Data
*The GROUP BY Clause
*Joining Tables

4. Modifying Data

*Inserting Data
*Updating Data
*Deleting Data
*Understanding Transaction Isolation

5. Working with SQL Server Management Studio

*Getting Started with SSMS
*Exploring the Object Explorer
*Working with the Query Editor
*Using SQL Server Books Online

6. Transact-SQL Programming

*Overview of Transact-SQL
*Using Built-In Functions
*Controlling Flow
*Ranking Results

7. Transactions and Error Handling

*Transaction Concepts
*Applications and Transactions
*Creating Explicit Transactions
*Using TRY/CATCH Error Handling

8. Creating Views

*What Is a View?
*Creating Views
*Updating Data Using a View
*Using Computed Columns
*Indexed Views
*Partitioned Views

9. Creating Stored Procedures and Triggers

*Creating Stored Procedures
*Creating Triggers

10. Creating User-Defined Functions

*User-Defined Function Overview
*Scalar Functions
*Inline Table-Valued Functions
*Multi-Statement Table-Valued Functions
*Using Functions, Views, and Stored Procedures

11. Using .NET Code in SQL Server 2005

*Introduction
*Writing SQLCLR Code
*SQLCLR Code Modules
*Managing Code Modules
*SQLCLR Security
*T-SQL vs. .NET Code

12. Advanced Query Techniques

*Full-Text Search
*Generating XML with FOR XML
*Using APPLY
*Creating Recursive Queries
*Creating Pivot Queries
*Executing Dynamic SQL

13. Implementing SQL Server Partitions

*Overview of Table-Based Partitioning
*Creating Partitioned Tables
*Querying Partitions
*Managing Partitions

14. Complex Querying

*Working with NULL Values
*Ranking Grouped Data
*Writing Correlated Subqueries
*Using Common Table Expressions

15. Advanced Techniques

*Complex Data and Structures
*Writing More Efficient Queries
*Working with Complex Queries
*Maintaining Query Files

16. Working with XML

*The xml Data Type
*XML Schema Collections
*Querying XML
*Best Practices