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.
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
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
VI. SQL Subqueries and Unions
A. Intersection with IN and EXISTS
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.
Certificate of completion
- Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
- Map & Reviews
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
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.
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 1379 times.