+44 (0)1737 821590
Introduction to SQL  |    A 2 days   hands on   training course

Intro to SQL training course description

A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms.

What will you learn
  • Explain the difference between standard SQL and different flavours.
  • Use SQL statements to query databases.
  • Use SQL statements to define databases.
Intro to SQL training course details
  • Who will benefit:
  • Anyone working with databases.

  • Prerequisites:
  • None.

  • Duration
  • 2 days

  • Dates & prices
  • Click here

Intro to SQL training course contents

  • What is SQL?
  • What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.

  • Database basics
  • RDBMS, Tables.
    Hands on Investigating a database.

  • Basic SQL commands
  • SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN.
    Hands on Querying a database from existing tables.

  • SQL data retrieval
  • Scalar functions.
    Hands on Selecting data from an existing database.

  • More SQL data retrieval
  • Scalar functions, variations. Aggregate functions, GROUP BY. HAVING.
    Hands on Selecting data from an existing database.

  • Table joins
  • Multiple tables, joins, keys, inner joins, left joins, right joins.
    Hands on Selecting data from an existing database.

  • SQL basic data manipulation
  • INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK.
    Hands on Modifying data in tables.

  • SQL Data Definition
  • USE, CREATE, DROP, TRUNCATE, ALTER.
    Hands on Managing new tables and columns.

  • Data control
  • GRANT, REVOKE.
    Hands on Defining permissions.

Learning path

Reviews

5.0

Based on customer reviews

C. W. - BBC NI

"I had no knowledge at the start of the course and the instructions were excellent."


F. D. - BBC NI

"Very good"

Training approach

This structured course uses Instructor Led Training to provide the best possible learning experience. Small class sizes ensure students benefit from our engaging and interactive style of teaching with delegates encouraged to ask questions throughout the course. Quizzes follow each major section allowing checking of learning. Hands on sessions are used throughout to allow delegates to consolidate their new skills.