8117  Reviews star_rate star_rate star_rate star_rate star_half

SQL Programming Workshop

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). Skills Gained Upon...

Read More
$2,390 USD
Course Code TP1911
Duration 3 days
Available Formats Classroom

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

Skills Gained

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

Who Can Benefit

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

Course Details

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

  • Relational Database overview
  • Relational Objects
  • Running SQL
  • Access TOOLS
  • Simple SQL Queries
  • CASE
  • Single Value Functions
  • Group Functions
  • GROUP BY - HAVING
  • SubQuery
  • Join
  • Creating Tables
  • Referential Integrity
  • Views
  • INSERT, UPDATE, DELETE, TRUNCATE
  • Coding and Executing Stored Procedures
  • Creating and Using Variables
  • Coding and Using User Functions
  • Coding and Using Triggers
  • OLD vs. NEW