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

3 sessions available starting from $1,050.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

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

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

Choose from 3 available sessions:

When

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

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,050.00

Type

  • Class / Group Sessions

When

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

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,050.00

Type

  • Class / Group Sessions

When

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

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,050.00

Type

  • Class / Group Sessions



My Other Listings

Microsoft Project 2010 Course | Advanced
Microsoft Project 2010 Course | Advanced
3 sessions available starting from $385.00
Microsoft PowerPoint 2003 Course | Advanced
Microsoft PowerPoint 2003 Course | Advanced
3 sessions available starting from $350.00
MYOB Course - Managing Payroll
MYOB Course - Managing Payroll
2 sessions available starting from $350.00

see all listings »


Found In