Course Outline
Quick Recap on Table Joins, Queries, and Basic Summary Functions:
- Review the concepts of primary keys and foreign keys for maintaining data integrity.
- Differentiate between inner joins and outer joins for combining data from multiple tables.
- Understand the significance of link tables and self-joins in relational databases.
- Utilize WHERE and HAVING clauses for data filtering and conditional aggregation.
- Explore Common Table Expressions (CTEs) for defining temporary result sets.
- Incorporate sub-queries as columns within SELECT statements for advanced data manipulation.
- Master main summary functions such as COUNT, SUM, AVG, MIN, and MAX.
- Learn to group data using the GROUP BY clause and apply filtering conditions with the HAVING clause.
Extended Summary Functions:
- Explore advanced summary functions including ROLLUP, CUBE, GROUPING, and GROUPING_ID for multi-level aggregation and subtotaling.
Hierarchical Queries:
- Learn to query hierarchical data structures using the CONNECT BY PRIOR syntax.
- Understand recursive Common Table Expressions (CTEs) for handling hierarchical data relationships.
Data Densification:
- Utilize techniques such as CONNECT BY ROWNUM and recursive CTEs for data densification.
- Explore the concept of partitioned outer joins for expanding data sets.
Set Operators:
- Master set operations including UNION, UNION ALL, INTERSECT, and MINUS for combining and comparing data sets.
Analytic/Window Functions:
- Explore a variety of analytic functions for performing calculations across rows and columns.
- Learn ranking functions such as ROW_NUMBER, RANK, and DENSE_RANK for data ranking and ordering.
- Understand Lead and Lag functions for accessing data from preceding or following rows.
- Utilize percentile functions for analyzing data distribution.
Execution Plan and Indexes:
- Understand how to analyze and interpret SQL execution plans for query optimization and performance tuning.
- Explore the role of indexes in improving query performance and data retrieval efficiency.
Requirements
Participants are expected to have a basic understanding of SQL fundamentals, including table creation, data insertion, and basic query construction.
Prior experience with Oracle SQL or any other relational database management system is beneficial but not mandatory.
Familiarity with database concepts such as primary keys, foreign keys, and data normalization will be advantageous.
Testimonials (12)
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
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
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
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 the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
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).