Introduction to SQL

Course

In London, Manchester and Birmingham

£ 425 + VAT

Description

  • Type

    Course

This course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course, some of the differences between different vendors' implementations will be noted.

Facilities

Location

Start date

Birmingham (West Midlands)

Start date

On request
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request
Manchester (Greater Manchester)

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • IT

Course programme

Note

There is an overlap between the content of this one day Introduction to SQL course and the content on the suggested follow-on Oracle and MySQL/MariaDB courses. You may wish to review the content of the three day Oracle SQL course, the three day Introduction to MySQL course or the three day Introduction to MariaDB course and if more suitable to your training needs attend one of those courses rather than this 1 day Introduction to SQL course.

Follow-On Courses

  • Oracle SQL
  • Introduction to MySQL
  • Introduction to MariaDB

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
  • Self Joins
  • Alternative Join Syntax
  • Practical Exercises

Additional SQL Features

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries
  • Practical Exercises

Introduction to SQL

£ 425 + VAT