SQL Programming Training Course

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)

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)

Inserting rows (INSERT)

Inserting rows using subquery

Updating rows (UPDATE)

Deleting rows (DELETE)

DDL (Data Definition Language)

Creating, altering and dropping objects (CREATE, ALTER, DROP)

Creating tables using subquery (CREATE TABLE .... AS SELECT...)

CONSTRAINTS

NULL i NOT NULL

CONSTRAINT clause

ENUM type

SET type

PRIMARY KEY

UNIQUE

FOREIGN KEY

DEFAULT clause

Transactions

COMMIT

ROLLBACK

SAVEPOINT

Implicit and explicit rollbacks and commits

SQL Dialects

MySQL

Microsoft Access and SQL Server

Oracle and PostgreSQL

Code: 
sqllan
Prerequisites: 

Basic computer skills.

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.

 

Certification: 

NobleProg Certificate

Duration: 
16 teaching hours
Prices
Public: 
900 GBP per delegate

Public Course Dates

Datesort iconTraining OutlineVenueDetails/Book
2008-06-19 09:00 - 2008-06-20 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-07-24 09:00 - 2008-07-25 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-08-28 09:00 - 2008-08-29 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-10-02 09:00 - 2008-10-03 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-11-06 09:00 - 2008-11-07 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-12-11 09:00 - 2008-12-12 17:00SQL Programming112/114 North Acton Road, NW10 6QH, LondonDetails/Book