SQL Basics

    

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

Duration:
3 Days/Lecture & Lab

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

Topics:

• 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

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.

Last Update: July 29, 2010