CourseForMe

Transact SQL Advanced Training Course

NobleProgUS
NobleProgUS

Detailed information

Type:Courses
Method:Onsite
Duration:7 Hour
Total hours of lesson:7
Students per class:6

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

Analytical Functions
Use of advanced summary functions
Use of hierarchical queries
Use of analytical summary functions, e.g. moving averages, running totals
Use of ranking functions
Useful Database Objects
Principles of using indexes
How to create and maintain an index
Use of clustered tables
Use of partitioned tables
Use of metadata in the master database
Query Performance Tracing
Principles of query execution and optimisation
Use of Execution Plan
Use of table & index statistics
Use of hints
Basic Data Warehouse Techniques
Use of Indexed Views
Use of Dimension & fact tables
Use of Star & Snowflake designs

Course location

Search similar to Other Database

Courses similar to Other Database

Sponsored links