Introduction to SQL

Course Code : OSQLI

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.

Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books