SQL Programming Workshop Training

Course #:WA1911

SQL Programming Workshop Training

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