SQL Training - SQL Courses

Show Details

Sorry, we do not have any courses matching your criteria

  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am

  • What are the pre-requisites?

    Some previous programming or database experience would be useful

SQL Training

Course Introduction

Administration and Course Materials

Course Structure and Agenda

Delegate and Trainer Introductions

Relational Database Concepts

What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types

The Data Dictionary

Getting Started

SQL Language Essentials

The Select Statement

The Select and From Clauses

Conditions and the Where Clause

The Order By Clause

Arithmetic Operations

Column Aliases

Practical Exercises

Summarising and Grouping Data

Aggregate Functions

The Group By Clause

The Having Clause

Practical Exercises

Querying Multiple Tables

Joining Tables

Inner Joins

Column Qualification and Table Aliases

Outer Joins

  • The Knowledge Academy Courseware Book
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments

There hasn't been any testimonials submitted to this topic

We do not currently have a video for this topic