SQL: Introduction to Query Writing

Course Details


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.

Duration:

2 Days

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.

SQL


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

Event Properties

Event Date 16-10-2017
Event End Date 17-10-2017
Individual Price $1,210.00
Course Code SQLINT
Location
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia
We are no longer accepting registration for this event

Group Rate

#Registrants Rate/Person($)
3 1,149.50
4 1,089.00
$1,210.00 9

Location Map

Share this event: