Course Details close

Course Details

Price:
(inc GST)
$ 495
Application:SQL
Level:Essentials
Version:All-Versions
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
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.75 out of 5)
284 Sql essentials student evaluations

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. 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

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

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.

Course Dates

Course Date Price Add Course Qty Status
01-Mar-19 (Fri)$495.00 0
23-Apr-19 (Tue)$495.00 0
23-May-19 (Thu)$495.00 0
17-Jun-19 (Mon)$495.00 0
Computer Training Courses

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
    The trainer is excellent
    - Silvio
  • SQL Essentials training course
    good training, good paced and well presented.
    - Glen
  • SQL Essentials training course
    great introduction and/or refresher on sql server management studio
    - Linda
  • SQL Essentials training course
    A fantastic course offering multiple ways of learning such as listening, seeing and doing. Craig was an excellent trainer. I would recommend this course to anyone who has never experienced SQL or to those who would like to update their SQL knowledge.
    - Sarah
  • SQL Essentials training course
    Really good overall grounding in SQL - for myself as a manager it was an excellent overview in the concepts of database structure and queries. Craig identified early on what was going to be less relevant and made sure we only covered what was necessary, which I really appreciated. Good course, very accessible for technical/non-technical staff alike.
    - David
  • SQL Essentials Training Course
    Need to add how to add this SQL queries and insert them into excel using VBA to add a button into excel to run the SQL code..
    - Jean-Philippe
  • SQL Essentials training course
    Great teacher!
    - Asher
  • SQL Essentials Training Course
    Very happy I attended
    - Jonathon
  • SQL Essentials training course
    Good introductory course. The course material provided will be handy going forward
    - Matthew
  • SQL Essentials - Data Management training course
    Tom did a great job. I have learnt a lot from this course. Thank you
    - Joanna
  • SQL Essentials training course
    Instructor was very knowledgeable, approachable and was helpful in stepping through what was being taught in an easy to understand manner.
    - Daniel
  • SQL Essentials Training Course
    Could have gone a bit faster for me in most parts, but at times was happy to have time to process things.
    - Mary
  • SQL Essentials - Data Management training course
    Great course
    - Belinda
  • SQL Essentials training course
    Tom was a very knowledgeable and approachable instructor. Would definitely recommend the course for those looking for basic SQL skills. Great facilities, central location. Thanks!
    - E`van
  • SQL Essentials training course
    Have enjoyed the course and it made me more confident that I did have some SQL knowledge even if it is only beginner.
    - Allison
  • SQL Essentials training course
    I look forward to the second course!
    - Dane
  • SQL Essentials training course
    Thank you!!! The last course at another provider that i went to was pretty hopeless. (advanced excel). This was really great
    - Amy
  • SQL Essentials - Data Management training course
    I found it very useful!
    - Victoria
  • 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
    Super clear presentation of a (possibly misunderstood) complex subject.
    - Jess
  • SQL Essentials training course
    Tom was a really good instructor very knowledgeable. And the course book is very handy
    - Winnie
  • SQL Essentials training course
    Very easy to follow.
    - Melissa
  • SQL Essentials training course
    well run and very informative
    - Salesh
  • SQL Essentials training course
    Very well and logically organised. Great content
    - Lorraine
  • SQL Essentials training course
    Very well and logically organised. Great content
    - Lorraine
  • SQL Essentials training course
    Great! great pace
    - Nathan
  • SQL Essentials training course
    Great Teacher. Good content and book to keep.
    - Lachlan
  • SQL Essentials training course
    Excellent!!!
    - Anthony
  • SQL Essentials training course
    Thanks for everything Craig..it was a great session!
    - Kaj
  • 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

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us