Follow Us :

Introduction to SQL

Course_Reference: 
SA-ISQL
Manufacturer: 
0
Training_Provider: 
18
Summary: 

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.

PreRequisites: 

There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.

Audience: 

  • Anyone who needs to understand and use SQL to manipulate a database.

Objectives: 

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

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?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

Session 2: 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

Session 3: SUMMARISING AND GROUPING DATA

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause
  • Practical Exercises

Session 4: QUERYING MULTIPLE TABLES

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins
  • Self Joins
  • Alternative Join Syntax
  • Practical Exercises

Session 5:ADDITIONAL SQL FEATURES

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

Description: 

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.

Keywords: 
Beginner, Oracle, database

Software Vendor

IT Technical

Business Skills