SQL Fundamentals Training Course

Primary tabs

Client Testimonials

SQL Programming

Having a 1-1 training course was very effective, it meant I was less intimidated as I could stop the trainer to ask questions where I may otherwise have been reluctant to ask.

 

Robert Craft - Zurich Employment Services Limited

SQL Programming

I really can't praise this course and the trainers highly enough! They were both extreemly well qualified and made the subject interesting. The pace of the course was excellent and I've come away feeling very satisfied with the skills I've learned.

 

Susan Elder - Merrill Lynch

SQL Programming

Great teacher with in depth knowledge and real life, relevant examples. Engaging and always ensures a section is understood before moving on to next.

 

Sade Okiji

SQL Programming

Good

Zan Sue - Net Media Planet

SQL Programming

The course content was adapted well to suit my current knowledge and capabilities. Specific topics I requested were covered well.

 

Steven Sirman - Corus Group

SQL Programming

The trainer is a great trainer and has very professional tone. I would definitely like to attend a SQL Advanced course in the near future which is hosted by the same trainer.

 

Mitul. P. Parmar - Cancer Research UK

SQL Fundamentals

The trainer was enthusiastic & would answer whatever we needed.

Erica May - Big Fish Games, Inc

SQL Fundamentals

The course I loved that it was just Andrew (the trainer) & my team.

It was very personalized.

Thanks for flying cross-country for us!

Bronwyn Bailey - PEGCC

SQL Fundamentals

Trainer was great--nothing to improve.

The way that Andrew (the trainer) customized to first day of training to the level of our group.

Josh Cox - PEGCC

SQL Fundamentals

What did you like the most about the training?:

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning.

Shawn McAndrew - Halifax Regional Municipality

SQL Fundamentals

What did you like the most about the training?:

That it was well organized. Topic was divided into parts and for every part there were exercises, I wasn't lost at all.

Monika Klimczak - LUXOFT POLAND SP z. o. o.

Course Language

This course is delivered in English.

Course Code

sqlfun

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Basic computer skills.

Overview 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 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

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From $4350
(24)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From $4350
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From $2570
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 $4350 $4350 $2570
2 $2500 $2450 $1560
3 $1883 $1817 $1223
4 $1575 $1500 $1055
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
ORACLE PL/SQL Fundamentals CA, San Diego - Stonecrest IV Mon, Sep 26 2016, 9:30 am $4950 / $7190

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
ND, Fargo - Brandt Office ParkWed, Oct 12 2016, 9:30 am$2570 / $4760
MT, Bozeman - Downtown BozemanMon, Oct 17 2016, 9:30 am$2570 / $5020
CheyenneTue, Oct 18 2016, 9:30 am$2570 / $4860
New York (NYC) - Midtown Manhattan - Park Avenue & E48-49th (Grand Central)Mon, Nov 7 2016, 9:30 am$2570 / $5370
VT, BurlingtonWed, Nov 9 2016, 9:30 am$2570 / $4820

Some of our clients