Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member 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
Testimonials
new techniques and style
Goniforte Balane - Mae Ann Tabanao, MORESCO-1
Some additional tips given to us that is somewhat outside topic area
John Erzon Tan - Mae Ann Tabanao, MORESCO-1
Tips discussed to improve our database management
Mae Ann Tabanao, MORESCO-1
Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic
ALBERT SANDIG - Mae Ann Tabanao, MORESCO-1
when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha
Carl Sherwin Francis Llenares - Mae Ann Tabanao, MORESCO-1
Trainer is knowledgeable about the topic, and he really knows what he is doing. I appreciate the pacing and helps the trainees if there is a problem. He is also very engaging and very patient. Gives us words of encouragement very often and keeps training interesting.
Bianca Angela Yap - Human Edge Software Philippines, Inc. (part of Tribal Group)
Hands-on activities
Allan Garrote - Human Edge Software Philippines, Inc. (part of Tribal Group)
Related Courses
Business Intelligence with SSAS
14 hours
Administration with Powershell
35 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in SQL Server
14 hours
SQL in Microsoft Access
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Transact SQL Basic
14 hours
SQL in MySQL
14 hours
Oracle SQL Language
14 hours