Course Length: 3 Days

Learning Objectives:
By the end of this training, you’ll be able to:

• Write SQL SELECT statements, including all allowable WHERE expressions, sorting, functions joins and subqueries.
• Write INSERT, UPDATE and DELETE statements.

Target Student:
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.

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

Course Outline:
Section 1: SQL Overview

• Relational database concepts, specific products
• SQL syntax rules
• Data definition, data manipulation, and data control statements
• Getting acquainted with the course database and editor

Section 2: SQL SELECT Statements

• Clauses
• The SELECT clause: columns and aliases, WHERE expressions, order by expressions how null values behave

Section 3: SQL Functions and Expressions

• Eliminating duplicates with DISTINCT arithmetic expressions
• Replacing null values
• Literals, concatenation, other string functions
• Numeric operations, including rounding
• Date and time functions
• Nested table expressions
• Case logic
• Other expressions in specific dbms products

Section 4: SQL Updating

• The INSERT, UPDATE and DELETE statements
• Column constraints and defaults
• Referential integrity constraints

Section 5: SQL Joins

• Inner joins with original and SQL 92 syntax
• Table aliases
• Left, right and full outer joins
• Self-joins

Section 6: SQL Subqueries and Unions

• Intersection with IN and EXISTS
• Subqueries
• Difference with NOT IN and NOT EXISTS subqueries
• The purpose and usage of UNION and UNIONALL

Section 7: SQL Summarization

• The column functions MIN, MAX, AVG, SUM and COUNT
• The GROUP BY and HAVING clauses
• Grouping in a combination with joining

This Course Comes With

PDF Manual Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

Customize Your Course

Tailored Training Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you