SQL Essentials

by Corporate Training Solutions Australia Claim Listing

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

$1210

Contact the Institutes

Fill this form

Advertisement

Corporate Training Solutions Australia Logo

img Duration

2 Days

Course Details

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

  • Brisbane CBD Branch

    Level 19, Waterfront Place, 1 Eagle Street, Brisbane CBD, Brisbane

Check out more SQL Server courses in Australia

IFA Australia - Institute for Financial Analysts Australia Logo

T-SQL Create Select Queries

T-SQL Create Select Queries course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.

by IFA Australia - Institute for Financial Analysts Australia [Claim Listing ]
NextTech Learning Logo

Updating Your Skills To SQL Server 2017

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

by NextTech Learning [Claim Listing ]
NDA Tasmania Logo

SQL (Intro)

On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried.

by NDA Tasmania [Claim Listing ]
CM Training Logo

Microsoft Introduction to SQL Databases

This course draws content from both Microsoft 10985 – Introduction to SQL Databases and Microsoft 20761 – Querying Data with Transact-SQL 2016

by CM Training [Claim Listing ]
Logitrain Logo

Oracle Database Administration I

The Oracle Database Administration I certification training course focuses on Oracle Database Architecture, Managing Users, Roles and Privileges, Moving Data, Managing Tablespaces and Datafiles, Restricting and Sorting Data and more.

by Logitrain

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy