Course Details close

Course Details

Price:
(inc GST)		 $ 495
Sale Price:
(inc GST)
* Selected Courses ONLY		 $ 450*
Application:SQL
Level:Essentials
Version:All-Versions
Duration:1 day
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)		 10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

SQL Essentials Course

   (4.78 out of 5)
419 Sql essentials student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060		 Break Times:
(approx)		 10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)		 $ 495
Sale Price:
(inc GST)		 $ 450

Quick links

SQL Essentials Course

Course Overview

Learn how to write SQL (Structured Query Language) from scratch with our 1 day SQL Essentials training course. Our expert instructors will easily step you through writing SQL using Microsoft's SQL Server Management Studio to allow you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL Server database. SQL skills are highly sought after in web development, programming, data analysis and reporting environments.

Who Should Attend This Course

This course is designed for people wanting to learn how to interrogate data from a relational database, however should you wish to learn how to manipulate this data (Insert, update, delete records) then our 1 day SQL Essentials – Data Management training course will be a natural progression for you.

Although we use SQL Server to interrogate data throughout this course, SQL is a common language easily adapted to other RDBMS (relational database management systems) such as MySQL, IBM DB2, PostgreSQL, Oracle, Ingres, Sybase and Microsoft Access.

Course Prerequisites

A solid understanding of database concepts or Access Advanced Course

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

With each course we provide you with a comprehensive course manual for you to practice post course.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

View Course Dates

Face to Face (public course dates)

Online via Webinar (via Microsoft Teams)

Public Course Dates

Course Date Price Add Course Qty Status
16-Jan-25 (Thu)$495.00 0
10-Feb-25 (Mon)$495.00 0
20-Mar-25 (Thu)$495.00 0
23-Apr-25 (Wed)$495.00 0
08-May-25 (Thu)$495.00 0
13-Jun-25 (Fri)$495.00 0
0 items $0.00

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
16-Jan-25 (Thu)$450.00 0
ON SALE
10-Feb-25 (Mon)$495.00 0
20-Mar-25 (Thu)$495.00 0
23-Apr-25 (Wed)$495.00 0
08-May-25 (Thu)$495.00 0
13-Jun-25 (Fri)$495.00 0
0 items $0.00

Courses start
from $450 (inc GST).
Limited seats.
Book today!

Course Outline

Understanding SQL

  • Database Basics
  • What is SQL?

Retrieving Data

  • The SELECT Statement
  • Retrieving Individual Columns
  • Retrieving Multiple Columns
  • Retrieving All Columns

Sorting Retrieved Data

  • Sorting Data
  • Sorting By Multiple Columns
  • Sorting By Column Position
  • Specifying Sort Direction

Filtering Data

  • Using the WHERE Clause
  • The WHERE Clause Operators

Advanced Data Filtering

  • Combining WHERE Clauses
  • Using the IN Operator
  • Using the NOT Operator

Using Wildcard Filtering

  • Using the LIKE Operator
  • Tips For Using Wildcards

Creating Calculated Fields

  • Understanding Calculated Fields
  • Concatenating Fields
  • Performing Mathematical Operations

Using Data Manipulation Functions

  • Understanding Functions
  • Using Functions

Summarizing Data

  • Using Aggregate Functions
  • Aggregates on Distinct Values
  • Combining Aggregate Functions

Grouping Data

  • Understanding Data Grouping
  • Creating Groups
  • Filtering Groups
  • Grouping and Sorting
  • SELECT Clause Ordering

Working with Subqueries

  • Understanding Subqueries
  • Filtering By Subquery
  • Using Subqueries As Calculated Fields

Joining Tables

  • Understanding Joins
  • Creating a Join

Creating Advanced Joins

  • Using Table Aliases
  • Using Different Join Types
  • Using Joins With Aggregate Functions
  • Using Joins And Join Conditions

Combining Queries

  • Understanding Combined Queries
  • Creating Combined Queries

Student Comments

  • SQL Essentials training course
    Thanks Craig for a great course. I found it very informative and well paced. I enjoyed the exercises completed within the course allowing me to practice what we were learning as we went along. Also appreciated all the references to the way we would use the queries within our company. This helped me to be able to understand how I could apply this to my daily tasks.
    - Anthi
  • SQL Essentials training course
    well run and very informative
    - Salesh
  • SQL Essentials training course
    One of the best training courses I have attended in a long time. Very concise, the pacing was very good, course content for SQL Essentials was great. Craig`s knowledge of the subject was excellent, as is his training. His explanations were easy to understand, making it easier for me to pick-up.
    - Erwin
  • SQL Essentials training course
    I have had Tom as a Trainer many times & I always come out with useful information to help me with my job at work.
    - Daniel
  • SQL Essentials - Data Management training course
    Functions such as Cursor and Transactions, that was awesome and all new to me!
    - Christie
  • SQL Essentials training course
    I enjoyed the challenges and that the course was hands on throughout the entire thing. Really enjoyed the course so thank you!
    - Allison
  • SQL Essentials training course
    Really helpful and explained in a way that I was able to understand and knowledge is something that I will use in my day to day job.
    - Sarah
  • SQL Essentials training course
    Loved it, feel like I have great understanding to take back to work and make improvements
    - Farren
  • SQL Essentials training course
    I found the facilities and course material great, I will most definitely enquire about future courses!
    - Scott
  • SQL Essentials training course
    Craig presented well and thoroughly understood content.
    - Miles
  • SQL Essentials training course
    I really enjoyed the course, it moved at a fast pace with a lot of interaction. The content was easily absorbed.
    - Kaylene
  • SQL Essentials - Data Management training course
    Good content and well presented
    - Ondrea
  • SQL Essentials training course
    Great course. Thank you.
    - Justin
  • SQL Essentials training course
    Great grounding course for SQL learners.
    - Brett
  • SQL Essentials training course
    Craig was great he explained the step by step instructions really well.
    - Leanne
  • SQL Essentials training course
    Really great course, I learnt heaps!
    - Brigitte
  • SQL Essentials training course
    every single section of the course was useful to me as I did not have any SQL knowledge prior to attending the course.
    - Jewan
  • SQL Essentials - Data Management training course
    Very Good
    - Michael
  • SQL Essentials training course
    I enjoyed it I've had some experience using SQL but only the basic concepts this course helped me consolidate my understanding and provided the 'why' on syntax arrangements.
    - Hieu
  • SQL Essentials training course
    All of it pretty much exactly what I was looking for. Great course! I'd do another course with you any day!
    - Frances
  • SQL Essentials training course
    It was great and I loved that it was hands on and we had challenges to test ourselves. It was interactive and we all had time to participate and have one on one help.
    - Jade
  • SQL Essentials training course
    The trainer is excellent
    - Silvio
  • SQL Essentials training course
    Great classroom, teaching of the course was very well excecuted.
    - Nikko
  • SQL Essentials training course
    The course was brilliant, I have never done SQL before, and by the end of the lesson I feel confident to extract data for my job at the Credit Union accurately. Instructor was very nice, and was happy to give us good challenges and help when needed.
    - Phoenix
  • SQL Essentials - Data Management training course
    Thanks very much
    - Tim
  • SQL Essentials - Data Management training course
    Creating views and manipulating data were both really interesting.
    - Joanna
  • SQL Essentials training course
    The content was presented in an engaging manner and was appropriate for us as beginners. The presenter was easy to understand and was very helpful if we encountered any issues. Thank you!
    - Cassie
  • SQL Essentials training course
    Craig was knowledgeable and paced out the day well. Jam-packed full of relatable application of the learning made the course much easier to follow.
    - Hayden
  • SQL Essentials - Data Management training course
    Craig was very knowledgeable. His explanations were easy to understand.
    - Petro
  • SQL Essentials training course
    Great Teacher. Good content and book to keep.
    - Lachlan

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us