Training

Popular Courses

IBM

MICROSOFT

Enterprise Architecture (EA)

SOA

Java/Java EE

Cloud Computing

Agile

Mobile computing

SCHEDULED CLASSES

COURSE
MAP

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

VIRTUAL CLASSROOMS

ROOM RENTALS

Contact Training Sales

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

 

Home > Training > Oracle Database > Oracle 11g >

WA1911 SQL Programming Workshop Training and Courseware

Quick Enroll

This three day workshop uses the 'HANDS ON' approach to teach the participant the essential concepts of a relational database and programming using Structured Query Language(SQL).

What you will learn

Upon completion of this workshop, the participant will be able to: 

  • Understand Relation Database Concepts.
  • Run Queries using SQL.
  • Use Access Tools to query, modify, and manipulate objects.
  • Use the extensions of the SQL language.
  • Code and execute simple and complex queries
  • Code and execute Stored Procedures
  • Code and Use User Functions 
  • Code and Use Database Triggers

Audience

  • Application programmers.
  • Anyone interested in gaining an understanding of Relational Databases.
  • Anyone interested in gaining an understanding of SQL.

Duration

Three days

Course Outline

1. Relational Database overview

2. Relational Objects

3. Running SQL

4. Access TOOLS

5. Simple SQL Queries

  • SELECT
  • FROM
  • WHERE
  • ORDER BY

6. CASE

7. Single Value Functions

  • Math
  • Date and Time
  • Character and Data Conversion
  • Null value functions

8. Group Functions

  • MAX
  • MIN
  • AVG
  • COUNT
  • SUM

9. GROUP BY - HAVING

10. SubQuery

  • Simple
  • Correlated

11. Join

  • Inner
  • Multiple Table
  • Outer

12. Creating Tables

13. Referential Integrity

14. Views

15. INSERT, UPDATE, DELETE, TRUNCATE

16. Coding and Executing Stored Procedures

17. Creating and Using Variables

18. Coding and Using User Functions

19. Coding and Using Triggers

20. OLD vs. NEW
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
More Details
Outline Course Outline
Buy This Course

Buy on-site and customized class

Attend a public class

06/04/2012 - Montreal
$2,275.00 Enroll

06/18/2012 - Toronto
$2,275.00 Enroll

07/09/2012 - Ottawa
$2,275.00 Enroll

07/16/2012 - Calgary
$2,275.00 Enroll

07/16/2012 - Vancouver
$2,275.00 Enroll

08/20/2012 - Toronto
$2,275.00 Enroll

08/20/2012 - Ottawa
$2,275.00 Enroll

09/10/2012 - Calgary
$2,275.00 Enroll

09/10/2012 - Montreal
$2,275.00 Enroll

09/24/2012 - Vancouver
$2,275.00 Enroll

10/15/2012 - Calgary
$2,275.00 Enroll

10/29/2012 - Toronto
$2,275.00 Enroll

11/05/2012 - Montreal
$2,275.00 Enroll

11/05/2012 - Ottawa
$2,275.00 Enroll

11/19/2012 - Vancouver
$2,275.00 Enroll

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.