Instructor Led Common Table Training
Common Table Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Software Training Academy, Inc
SQL Server 2005 Transact SQL T-SQL with Additional Topics
...res, triggers, and user-defined functions.
Use the new Common Table Expressions for creating hierarchical queries.
Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
Discover partitioning with SQL Server.
Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries.
Explore advanced techniques for working
more...
...res, triggers, and user-defined functions.
Use the new Common Table Expressions for creating hierarchical queries.
Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
Discover partitioning with SQL Server.
Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries.
Explore advanced techniques for working
more...
SQL Server 2005 - Additional Topics
...tioning with SQL Server
Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries
Explore advanced techniques for working with complex data structures
Learn how to use source control with SQL Server Management Studio
Discover new XML capabilities in SQL Server 2005
Prerequisites:
This course assumes that students have a
more...
...tioning with SQL Server
Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries
Explore advanced techniques for working with complex data structures
Learn how to use source control with SQL Server Management Studio
Discover new XML capabilities in SQL Server 2005
Prerequisites:
This course assumes that students have a
more...
From Corporate Education Group
Designing Microsoft SQL Server 2005 Server-Side Solutions
...ning a SQL Server 2005 solution.
Lessons
Evaluating Common Table Expressions Evaluating Pivot Queries Evaluating Ranking Queries
Lab 8: Evaluating Advanced Query Techniques
Evaluating Common Table Expressions Evaluating Pivot Queries Evaluating Ranking Queries
After completing this module, students will be able to:
Evaluate the use of Common Table
more...
...ning a SQL Server 2005 solution.
Lessons
Evaluating Common Table Expressions Evaluating Pivot Queries Evaluating Ranking Queries
Lab 8: Evaluating Advanced Query Techniques
Evaluating Common Table Expressions Evaluating Pivot Queries Evaluating Ranking Queries
After completing this module, students will be able to:
Evaluate the use of Common Table
more...
Updating Your Database Development Skills to Microsoft SQL Server 2005
...ming with Transact-SQL
? Partitioning a Table ? Using Common Table Expressions ? Using Relational Operators
After completing this module, students will be able to:
? Use new Data Definition Language (DDL) features in SQL Server 2005. ? Use new Data Manipulation Language (DML) features in SQL Server 2005. ? Implement structured exception handling in Transact-SQL.
Module 3:
more...
...ming with Transact-SQL
? Partitioning a Table ? Using Common Table Expressions ? Using Relational Operators
After completing this module, students will be able to:
? Use new Data Definition Language (DDL) features in SQL Server 2005. ? Use new Data Manipulation Language (DML) features in SQL Server 2005. ? Implement structured exception handling in Transact-SQL.
Module 3:
more...
