Support

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

Access 2003 VBA Course
Access 2003 VBA Course
3 sessions available starting from $1,155.00
Access 2003 Course - Introduction
Access 2003 Course - Introduction
2 sessions available starting from $700.00
Conducting Effective Meetings 1 Day Course
Conducting Effective Meetings 1 Day Course
4 sessions available starting from $435.00

see all listings »


Found In