Back
|
|
|
INTRODUCTION TO SQL
Delegates: |
|
This course is intended for people who need to access and work with relational databases.
|
Objectives: |
|
On completion of the course, the delegate will have a basic understanding of the structure of a relational database and the functions of a DBMS. They will have a working knowledge of the ANSI Standard Structured Query Language (SQL) allowing them to access database tables.
|
Topics Covered: |
- Introduction to Databases
- Functions of a DBMS
- Benefits of a DBMS
- Relational Database Structure
- SQL Syntax
- Basic SQL Statements
- Joining Tables
- Aggregate Functions
- Subqueries
|
Requirements:
|
|
Some previous programming or database experience would be useful. |
|
|
|