Course Outline
1. YOUR OWN DATA TYPES
- ▪UDDT (User-Defined Data Types)
- ▪UDT (User-Defined Types)
2. HIERARCHICAL DATA TYPE
- Elementy structures Storage methods Indexing strategies Methods
3. RANKING AND ANALYTICAL FEATURES
- OVER clause Window functions Frame clauses Operators: GROUPING SETS, GROUPING_ID, ROLLUP, CUBE, PIVOT, UNPIVOT
4. TEMPORARY DATA
- Other temporary facilities
5. IMPROVING QUERY PERFORMANCE THROUGH DATA INDEXING
- Index selectivity indicator Index selectivity indicator Server suggestions for missing indexes Measurement of execution time for operations with and without indexes
6. CREATING AND MAINTAINING STATISTICS
- Construction of statistics and the principle of their operation. Monitoring and maintenance of statistics. Cardinality estimation errors and updating of statistics
7. ANALYSIS OF PLANS FOR IMPLEMENTING INQUIRIES
- Running and reading query plans PARAMETER SNIFFING Code recompilations
8. QUERY EXECUTION CONTROL SQL
- Hints (tips, hints for the server) Extended Events - (EE) Database Engine Tuning Advisor - (DTA) Data Collector - (DC) Query Store - (QS)
Requirements
- Basic understanding of SQL
- Familiarity with relational databases
- Experience with query writing and execution
Audience
- Database Administrators
- SQL Developers
- Data Analysts
Testimonials (13)
Poruszanie zazębiających się aspektów przy operowaniu na bazach danych
Michał Marzec
Course - SQL Advanced in MySQL
Szkolenie przeprowadzone gruntownie od zagadnień podstawowych po te bardzo zaawansowane. Trener przyjazny, chętnie udzielający odpowiedzi na zadawane pytania.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
Course - SQL in Microsoft Access
Transfer of knowledge using simple and understandable examples.
Katsiaryna
Course - SQL language in MSSQL
Machine Translated
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).