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
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
Jim Lane
everything :)
Szymon Lasota - Lingaro Sp. z o.o.
Practical knowledge
Tomasz Bartczak - Lingaro Sp. z o.o.
Exercises on real data
- Lingaro Sp. z o.o.
learning about reading query plans (individual elements)
- Lingaro Sp. z o.o.
Very interesting examples, ease of knowledge transfer by the teacher.
- Lingaro Sp. z o.o.
a large number of topics.
- Lingaro Sp. z o.o.
Related Courses
SQL in Microsoft Access
14 hours
SQL in SQL Server
14 hours
Transact SQL Basic
14 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in MySQL
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Oracle SQL Language
14 hours
Business Intelligence with SSAS
14 hours
Administration with Powershell
35 hours