Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

In this course, the student will develop a large number of SQL SELECT statements, including joins and subqueries; and write INSERT, UPDATE and DELETE statements.

Course Outline
In this course, the student will develop a large number of SQL SELECT statements, including joins
and subqueries; and write INSERT, UPDATE and DELETE statements.

At the completion of this course, the student will be able to:
· Write SQL SELECT statements, including all allowable WHERE expressions, sorting, functions joins and subqueries.
· Write INSERT, UPDATE and DELETE statements.

· SQL overview
· SQL SELECT statements
· SQL functions and expressions
· SQL updating
· SQL joins
· SQL with multiple tables
· SQL summarization
· SQL: preparing for the real world

This course is designed for application developers who work in any relational database environment, including Oracle, Sybase, SQL Server, Access, DB2, Ingres, Informix and many others.

Course Outline
I. SQL Overview
A. Relational database concepts, specific products
B. SQL syntax rules
C. Data definition, data manipulation, and data control statements
D. Getting acquainted with the course database and editor

II. SQL SELECT statements
A. Clauses
B. The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave

III. SQL Functions and Expressions

A. Eliminating duplicates with DISTINCT arithmetic expressions
B. Replacing null values
C. Literals, concatenation, other string functions
D. Numeric operations, including rounding
E. Date and time functions
F. Nested table expressions
G. Case logic
H. Other expressions in specific dbms products

IV. SQL Updating
A. The INSERT, UPDATE and DELETE statements
B. Column constraints and defaults
C. Referential integrity constraints

V. SQL Joins
A. Inner joins with original and SQL 92 syntax
B. Table aliases
C. Left, right and full outer joins
D. Self-joins

VI. SQL Subqueries and Unions
A. Intersection with IN and EXISTS
B. Subqueries
C. Difference with NOT IN and NOT EXISTS subqueries
D. The purpose and usage of UNION and UNIONALL

VII. SQL Summarization
A. The column functions MIN, MAX, AVG, SUM and COUNT
B. The GROUP BY and HAVING clauses Grouping in a combination with joining
Prerequisites & Certificates

The student should have experience using the editor in which the class is taught, which can be TSO/ISPF in an IBM mainframe environment, any version of Microsoft Windows or other editor and have experience with any programming or query language. Required: Access to a Relational DBMS such as DB2, Access, Oracle, Sybase, SQL Server, etc.

Certificates offered

Certificate of completion

Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1348 times.