4.73 (860 reviews)
$1,210
Enhance your SQL skills for a data-driven world!
This course addresses how to write SQL effectively, taking into account performance considerations. The course will focus on Microsoft SQL Server. However, the skills you learn in this Advanced SQL Queries course is not limited to just Microsoft SQL. The principles can be applied to other databases such as PostgreSQL, MySQL & MariaDB and Oracle.
Be able to write complex SQL Queries
Understand Performance implications when writing SQL
Gain a thorough understanding of the syntax and semantics of SQL
Be able to create and manage tables in SQL
Be able to summarize data using aggregate functions
Be able to optimize queries
Course Overview
Audience:
This course will suit Database Administrators, Application Developers and other users who require access to their database in an efficient manner.
Prerequisites:
To successfully understand the content and complete activities students must have proficient knowledge of Windows and a basic understanding of SQL is recommended.
Course Content
Learning Outcomes
At the end of the course students will be able to:
- Be able to write complex SQL Queries
- Understand Performance implications when writing SQL
- Be able to interrupt QEPs and generate better SQL
- Gain a thorough understanding of the syntax and semantics of SQL statements
- Be able to use the OpenIngres interactive terminal monitor
Predicates
- Comparison
- Like Predicates
- Between Predicates
- In Predicates
- Any All or Some Predicates
- Using Subqueries Effectively
- Subquery Rules
- Correlated Subqueries
- EXISTS Predicate
- Scalar Functions
Joins
- Why Join Tables
- Unions
- Types of Joins
- Formulation of Join
- Outer Joins
- Caveats
- Self Joins
- Limitations of Joins
Summarizing Data
- Aggregate Functions
- Aggregate Queries
- Aggregate Quotes
- Set Functions
- Grouping
Managing Data Sequentially
- Cursors
- Cursor Solution
- Select Cursor
Managing Tables
- Creating Tables
- Changing Tables
- Deleting Tables
- Ownership
Query Optimization
- Indexes
- Statistics
- Query Flattening
- Disjunctive Normal Form
- Function Queries
Delivery Options
 |
Classroom sessions are delivered at a nominated location (Private courses only). Inclusions: |
Full Day Sessions: Half Day Sessions: |
 |
Live online sessions are instructor-led in a virtual environment, providing hands-on instruction and practical activities for participants. Participants can see the instructor screen and interact with the instructor and other participants. Instructor can assist participants on their screen if necessary. Participants can join a session from any location using the Course Invitation. There is no need for software just a computer with an internet connection and a browser. Public sessions are conducted through Live Online. Inclusions: |
Full Day Sessions: Half Day Sessions Times: |
Available SQL Advanced courses
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| SQL Queries Advanced | 10-02-2025 | Live Online | $1,390.00 | |
| SQL Queries Advanced | 14-04-2025 | Live Online | $1,390.00 | |
| SQL Queries Advanced | 19-06-2025 | Live Online | $1,390.00 |
Brochure