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

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 $3070
Request
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 $3070
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
SelfStudy SelfStudy
Self-study courses allow you to learn at your own pace on your own time. There is no live instructor involved. The participants use recorded video, quizzes and reading at their own convenience.
Price not set yet
Register Interest

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 $3070 $3070 $2570
2 $1860 $1810 $1560
3 $1457 $1390 $1223
4 $1255 $1180 $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]
Test Automation with Selenium TX, Austin - Littlefield Congress Tue, Aug 23 2016, 9:30 am $3480 / $5705

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
FL, Jacksonville - Bank of America TowerThu, Jun 9 2016, 9:30 am$2570 / N/A
CO, Denver - Denver PlaceThu, Jun 9 2016, 9:30 am$2570 / N/A
DE, Wilmington - DowntownThu, Jun 9 2016, 9:30 am$2570 / N/A
Fort Lauderdale, FL - PlantationThu, Jun 9 2016, 9:30 am$2570 / N/A
SC, Charleston - Faber CenterWed, Jun 15 2016, 9:30 am$2570 / N/A

Some of our clients