Overview:

About the course

The Introduction to SQL 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.

The delegate will learn and acquire skills as follows:
• Creating SQL statements to query a database table
• Using standard aggregate functions and related SELECT statement clauses
• Joining Tables
• Using basic subqueries and the set operators

Who will the course benefit?

Anyone who needs to understand and use SQL to manipulate a database.
There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.

Entry:

Requirements

Some previous programming or database experience would be useful.

Course Notes

There is an overlap between the content of this 1 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 3 day Oracle SQL course, the 3 day Introduction to MySQL course or the 3 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

Notes

• Course technical content is subject to change without notice.
• Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

 

Objectives:

Course Objectives

To provide the knowledge and skills needed to retrieve data held in a relational database.

Syllabus:

Syllabus

Course Contents - DAY 1

Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: RELATIONAL DATABASE CONCEPTS
• What is a Relational Database?
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Data Types
• The Data Dictionary

Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT
• The Select Statement
• The Select and From Clauses
• Conditions and the Where Clause
• Other Conditional Operators
• Logical Operators
• The Order By Clause
• Column Aliases
• Arithmetic Operations
• Precedence of Operators

Session 3: AGGREGATE FUNCTIONS
• Overview of Built in Aggregate Functions
• The Group By Clause
• The Having Clause

Session 4: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
• Self Joins
• ANSI Join Syntax

Session 5: BASIC SUBQUERIES AND SET OPERATORS
• Overview of Subqueries
• Basic Subqueries
• Set Operators

1 Day

Course Dates

There are no dates scheduled for this location at the moment. Please call to enquire 08000 199337
 

 

Select a Classroom Course

Course Title Start Date Finish Date Location Price Qty
Introduction to SQL Dec 14, 2018 Dec 14, 2018 Birmingham £350
Introduction to SQL Dec 14, 2018 Dec 14, 2018 London £350
Introduction to SQL Jan 21, 2019 Jan 21, 2019 London £350
Introduction to SQL Feb 11, 2019 Feb 11, 2019 Manchester £350
Introduction to SQL Feb 15, 2019 Feb 15, 2019 London £350
Introduction to SQL Feb 18, 2019 Feb 18, 2019 Birmingham £350
Introduction to SQL Feb 18, 2019 Feb 18, 2019 Leeds £350
Introduction to SQL Mar 25, 2019 Mar 25, 2019 London £350
Introduction to SQL Apr 18, 2019 Apr 18, 2019 Manchester £350
Introduction to SQL Apr 18, 2019 Apr 18, 2019 Leeds £350
Introduction to SQL Apr 26, 2019 Apr 26, 2019 London £350
Introduction to SQL May 13, 2019 May 13, 2019 Leeds £350
Introduction to SQL May 28, 2019 May 28, 2019 London £350
Introduction to SQL Jun 28, 2019 Jun 28, 2019 Leeds £350
Introduction to SQL Jun 28, 2019 Jun 28, 2019 London £350
Introduction to SQL Jul 8, 2019 Jul 8, 2019 Manchester £350
Introduction to SQL Jul 12, 2019 Jul 12, 2019 Birmingham £350
Introduction to SQL Jul 26, 2019 Jul 26, 2019 London £350
Introduction to SQL Aug 27, 2019 Aug 27, 2019 London £350
Course Type:


Location:

Session Dates: