Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
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
7 Hours
Testimonials (5)
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
new techniques and style
Goniforte Balane - MORESCO-1
Course - Transact SQL Advanced
Some additional tips given to us that is somewhat outside topic area
John Erzon Tan - MORESCO-1
Course - Transact SQL Advanced
Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic
ALBERT SANDIG - MORESCO-1
Course - Transact SQL Advanced
when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha