United Kingdom [select]
SQL Programming Training Course
Node ID: 102
Duration
14 hours
Requirements
Basic computer skills.
Public Course Dates
Can't find a course date that suits your needs below?
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
| Date | Venue | Price | ||
|---|---|---|---|---|
| 2012-02-09 09:30 | Manchester | From 950 to 1390 GBP Check! | ||
| 2012-02-15 09:30 | London, Westbourne Grove | From only 940 to 1362 GBP Check! | ||
| 2012-03-29 09:30 | Manchester | From 950 to 1390 GBP Check! | ||
| 2012-03-29 09:30 | Bristol, Temple Gate | From 950 to 1390 GBP Check! | ||
| 2012-04-03 09:30 | London, Westbourne Grove | From 950 to 1390 GBP Check! | ||
| 2012-04-17 09:30 | Bristol, Temple Gate | From 855 to 1251 GBP Check! | ||
| 2012-04-24 09:30 | London, Westbourne Grove | From 855 to 1251 GBP Check! | ||
| 2012-05-01 09:30 | Manchester | From 855 to 1251 GBP Check! | ||
| 2012-05-24 09:30 | London, Westbourne Grove | From 855 to 1251 GBP Check! | ||
| 2012-06-12 09:30 | Manchester | From 855 to 1251 GBP Check! |
Overview
This SQL training course is for people 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.
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 Manipulation 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
MySQL
Microsoft Access and SQL Server
Oracle and PostgreSQL
