7854  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

  • 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