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
Public Courses
Live online - learn by doing.
Our Live Online courses are conducted through a dedicated learning platform that enables us to provide instructor-led, hands-on training to develop real skills, in real time. Each participant logs into their own virtual environment setup specifically for the course. This is a fully interactive experience - just like in a classroom. No passive lectures. No videos to follow - real time hands-on practice with your instructor guiding you every step.
Instructor:
- provides real-time live hands-on instruction and demonstration,
- provides step-by-step practical activities for participants,
- can assist participants on their screen, if necessary,
- can share participant screens to enhance discussion.
Participants:
- receive hands-on instruction, step-by-step exercises and skill-builder activities,
- see the instructor screen while working on their own environment,
- can interact with the instructor and the group of participants,
- can ask questions at any time,
- join the course from any location with internet using a Course Invitation.
- no need for any software, just a computer with internet and a browser.
- no downloads on installs necessary on the participant computer.
Inclusions:
- E-Book Training Manual/activity booklet will be provided
- Certificate of Completion
- Post-course support to the level of the course
- Access to any training exercises used during the session
Session Times:
- Full Day Course: 9:00 am-4:30 pm
- Half Day Course: 9:00 am-12:30 pm or 1:30 pm-5:00 pm
Private Courses
Private sessions can be arranged through our Live Online platform for group training. Group training content and duration can also be tailored to your needs. To discuss your training requirements, contact our Course Scheduling team.
Classroom
Classroom sessions are delivered at a nominated location (Private courses only).
Requirements:
If training is being delivered on your site:
- A computer is required for each participant, configured with appropriate software (if necessary).
- If participants are using laptops, ensure power cords are provided for use during the session.
- The instructor will bring their own laptop - please provide power
- Screen/Projector for trainer to connect their laptop to. Please indicate the connection method - hdmi or wifi.
Inclusions:
- Training Manual/activity booklet
- Certificate of Completion
- Post-course support for queries relating to the course content.
Available SQL Advanced courses
There are no events in the selected category
Brochure