Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

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

821A Bloor Street West
Toronto, ON
M6G 1M1

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 11g > SQL Programming Workshop Training

SQL Programming Workshop Training

Course#: WA1911

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

Outline of WA1911 SQL Programming Workshop Training

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.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

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

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.