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
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 Essentials courses
There are no events in the selected category
Brochure