SQL Introduction

2 Day Course
Code SQLINT

This course has been retired. The SQL Language course is a recommended alternative.

Modules

Hide all

Introduction (5 topics)

  • Defining Structured Query Language
  • Introduction to relational databases
  • Tables, Rows and Columns
  • Interactive SQL environments
  • General SQL guidelines

Developing queries (8 topics)

  • The SELECT statement
  • The WHERE clause
  • Specifying conditions Relational and logical operators.
  • Pattern matching with LIKE
  • Other operators
  • The ORDER BY clause
  • The GROUP BY and HAVING clauses
  • Computed values

Data manipulation (3 topics)

  • Inserting new data
  • Modifying existing rows
  • Deleting data that is no longer required.

Database Definition (6 topics)

  • Table creation
  • Specifying data types for columns
  • Examples of data types
  • Changing, removing tables
  • Creating indexes
  • Indexing strategies

Controlling access to the database (3 topics)

  • Privileges and Permissions
  • Privilege management
  • The GRANT and REVOKE statements

Advanced SQL features (4 topics)

  • Aggregate functions
  • Nested queries
  • Outer Joins
  • Views

Prerequisites

- Delegates will benefit from an understanding of programming principles. - We recommend that attendees have some experience with Unix or Windows NT before commencing this event.

Sections