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.
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.
3 Days/Lecture & Lab
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.
- 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