Introduction to SQL

Level
Total time
Logo StayAhead Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Introduction to SQL Course Overview

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.

Skills Gained

The delegates will practise:

  • Creating SQL statements to query a database table
  • Writing SQL statements to retrieve data from multiple tables
  • Using standard aggregate functions
  • Implementing Subqueries

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 expos…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Introduction to SQL Course Overview

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.

Skills Gained

The delegates will practise:

  • Creating SQL statements to query a database table
  • Writing SQL statements to retrieve data from multiple tables
  • Using standard aggregate functions
  • Implementing Subqueries

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.

Course Objectives

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

Requirements

Some previous programming or database experience would be useful.

Follow-On Courses

  • Oracle SQL

NOTE: Course technical content is subject to change without notice.

Introduction to SQL Training Course

Course Contents - DAY 1Course 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: BASIC SUBQUERIES AND SET OPERATORS

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries
  • Practical Exercises
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.