Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

Introduction to SQL Course

Introduction to SQL

Brisbane, QLD

Subject: Microsoft Sql Server

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.

Course Content:

see more

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.

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

see less

When

Please contact us for upcoming dates and/or more information about this class.

Where

8/40 Creek St
Brisbane, QLD 4000

Type

  • Class / Group Sessions

Price: $1,050.00

 

The teachers

CTS Training Pty Ltd is an Australian owned independent training provider. Founded in Brisbane in 1988, CTS Training...

see more

CTS Training Pty Ltd is an Australian owned independent training provider. Founded in Brisbane in 1988, CTS Training is a highly respected corporate training centre providing consistent high quality desktop software and soft skills training.

CTS Training is a Microsoft Learning Solutions partner offering a diverse range of Microsoft Office training courses. Microsoft Learning Solutions Partner must meet stringent scrutiny by Microsoft and deliver the highest-quality education in Microsoft products.

Our Microsoft Office courses are lead by qualified, experienced instructors who will also allow you plenty of time for experiential learning and questions. We are passionate about our training and providing the very best learning experience.

see less


Additional sessions available

Introduction to SQL Course has 2 additional sessions available, including:

View all sessions