+44 20 7558 8274
SQL Programming
Overview
This SQL training course is for students who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
Requirements
Basic computer skills.
Book Public Course Now! >>
Distance instructor-led course price 1900 GBP per course
Get distance quote now! >>
Closed, on-site or individual: get quote >>
Too expensive? Tell us your price!
All prices exclude VAT!
Following Courses
No following Courses Found.
Related Training
Training Course Outline
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
SELECT clause
Column aliases
Table aliases
Date types and Date functions
Group function
Table joins
JOIN clause
UNION operator
Nested queries
Correlated subqueries
DML (Data Modification Language) Overview
Inserting rows (INSERT)
Inserting rows using subquery
Updating rows (UPDATE)
Deleting rows (DELETE)
DDL (Data Definition Language) Overview
Creating, altering and dropping objects (CREATE, ALTER, DROP)
Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
NULL i NOT NULL
CONSTRAINT clause
ENUM type
SET type
PRIMARY KEY
UNIQUE
FOREIGN KEY
DEFAULT clause
Transactions Overview
COMMIT
ROLLBACK
SAVEPOINT
Implicit and explicit rollbacks and commits
SQL Dialects Overview
Microsoft Access and SQL Server
Oracle and PostgreSQL
Training Course Dates
| Date | Training Outline | Venue | Price | Details | ||
|---|---|---|---|---|---|---|
| 2010-04-15 09:30 - 2010-04-16 17:30 | SQL Programming | North Acton, London | From 530 GBP per person | Check Price! >> | ||
| 2010-06-10 09:30 - 2010-06-11 17:30 | SQL Programming | North Acton, London | From 540 GBP per person | Check Price! >> | ||
| 2010-08-05 09:30 - 2010-08-06 17:30 | SQL Programming | North Acton, London | From 540 GBP per person | Check Price! >> | ||
| 2010-09-30 09:30 - 2010-10-01 17:30 | SQL Programming | North Acton, London | From 540 GBP per person | Check Price! >> | ||
| 2010-11-25 09:30 - 2010-11-26 17:30 | SQL Programming | North Acton, London | From 540 GBP per person | Check Price! >> |






