SQL: Introduction for Beginners (2 day)

Course Overview

This course is for programmers and others who are expected to use SQL with a relational database.

Completion of this course will give delegates a sound understanding of SQL as it is implemented by the commercial databases.

Delegates will be able to interpret SQL statements and develop their own SQL processing functions. They will be able to devise sophisticated queries and manipulate the data in relational databases.

Delegates will also gain useful insights into the mechanics of relational databases.

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.

Course Outline

Introduction:

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

Developing queries:

• 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:

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

Database Definition:

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

Controlling access to the database:

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

Advanced SQL features:

• Aggregate functions, Nested queries
• Outer Joins, Views!