4.45 (1025 reviews)
$1,210
Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.
This course will be conducted using a Microsoft SQL Server.
Introduction to databases
Selecting data
Grouping data
Multiple table queries
Working with joins
Course Overview
This course offers end-users a sound background on the concepts of a Relational Database Management System. It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database either directly or through third-party Query and Reporting Tools.
Audience:
Users who will be querying the corporate database either directly or through third-party Query and Reporting Tools.
Prerequisites:
There are no particular requirements for this course.
Inclusions
Training Manual with step by step instructions
Practice files with relevant to the training material
Training Completed files you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Learning Outcomes
At the end of the course students will be able to:
- Understand the basics of what a database is
- Formulate simple SELECT statements
- Qualify queries using the WHERE clause
- Summarise data using the GROUP BY and HAVING clauses
- Formulate complex queries which span multiple tables
- Gain an appreciation for performance when developing queries
- Gain confidence in developing accurate and efficient SQL queries
Introduction to Databases
- Defining a Databases Management System
- Defining a Relational Database Management System
- Defining Normalisation
- What Does SQL Do?
Basic SELECT Statement
- The SELECT Statement
- Restricting Columns
- Performing Arithmetic Computing
- SQL Functions
- Eliminating Duplicate Rows
- Sorting Data
Qualifying Data
- The WHERE Clause
- Comparison Operators
- Logical Operators
- Selecting NULL Values
- Subqueries
- ANY and ALL Predicates
- String Components
Combining Tables
- What is a Join?
- Why We Join Tables?
- How to Get a Good Join
- Formulation of a Join
Summarising Information
- Aggregate Functions
- Grouping Data
- Qualifying Groups of Data
- The Having Clause
More Complex SQL
- Exists Predicate
- Outer Joins
- Pattern Matching and String Manipulations
- Handling Date Comparisons and Manipulation
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 Essentials courses
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| SQL Writing queries Essentials | 27-03-2025 | Live Online | $1,295.00 | |
| SQL Writing queries Essentials | 06-05-2025 | Live Online | $1,295.00 |
Brochure