Course Outline
Table Joins
- Recap of joins using primary key and foreign key connections
- Recap of difference between inner and outer joins
- Recap of usage of link tables to resolve many-to-many relationships
- Self Joins
Sub Queries
- Recap of nested sub-queries in Where & Having clauses
- Recap of correlated sub-queries in Where & Having clauses
- Common Table Expression
- Sub-Queries as columns
Summary Functions
- Recap of main summary functions
- Recap of Group By & Having clauses
- Use of Rollup function
- Use of Cube function
- Use of Grouping & Grouping_Id functions
Hierarchical Queries
- Use of Connect By Prior facility
- Use of Recursive Common Table Expression
Analytic/ Window functions
- Analytic versions of main summary functions
- Ranking functions
- Lead & Lag functions
Summary and Next Steps
Requirements
- An understanding of Basic SQL
Testimonials (8)
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems
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
Podczas szkolenia zostały bardzo szczegółowe - jak na dwa dni szkolenia - omówione wszystkie moduły, a na tym mi najbardziej zależało.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Course - SQL Advanced
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
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).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
the practices and the trainer notes