SQL Basics
Duration:
3 Days
Objectives:
At the completion of this course, the student will have developed
a large number of SQL SELECT statements, including joins and subqueries
and written INSERT, UPDATE and DELETE statements.
Topics
SQL overview
SQL SELECT statements
SQL functions and expressions
SQL updating
SQL joins
SQL with multiple tasks
SQL summarization
SQL: preparing for the real world
Audience
Application Developers who work in any relational database environment,
including Oracle, Sybase, SQL Server, Access, DB2, Ingres, Informix
and many others.
Pre-requisites
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; experience with any programming
or query language
|
