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.
Public Schedule: | ||
| Virtual Classroom, EL | 04/23/12 - 04/25/12 | ( register ) |
| Virtual Classroom, EL | 04/23/12 - 04/25/12 | ( register ) |
| Virtual Classroom, EL | 03/12/12 - 03/14/12 | ( register ) |
| Virtual Classroom, EL | 03/05/12 - 03/07/12 | ( register ) |
| Virtual Classroom, EL | 03/05/12 - 03/07/12 | ( register ) |
| Kansas City, MO | 06/04/12 - 06/06/12 | ( register ) |
| Calgary, AB | 04/23/12 - 04/25/12 | ( register ) |
| Vancouver, BC | 04/23/12 - 04/25/12 | ( register ) |
| Toronto, ON | 04/23/12 - 04/25/12 | ( register ) |
| Virtual Classroom, EL | 02/08/12 - 02/10/12 | ( register ) |
| Virtual Classroom, EL | 06/04/12 - 06/06/12 | ( register ) |
| Pittsburgh, PA | 06/04/12 - 06/06/12 | ( register ) |
| Calgary, AB | 04/23/12 - 04/25/12 | ( register ) |
| Vancouver, BC | 04/23/12 - 04/25/12 | ( register ) |
| Toronto, ON | 02/08/12 - 02/10/12 | ( register ) |
| Kansas City, MO | 03/05/12 - 03/07/12 | ( register ) |
| Toronto, ON | 04/23/12 - 04/25/12 | ( register ) |
| Pittsburgh, PA | 03/05/12 - 03/07/12 | ( register ) |
| Danville, PA | 05/21/12 - 05/23/12 | ( register ) |
| Kansas City, MO | 03/05/12 - 03/07/12 | ( register ) |
| Danville, PA | 03/05/12 - 03/07/12 | ( register ) |
| San Diego, CA | 03/05/12 - 03/07/12 | ( register ) |
| Los Angeles, CA | 03/05/12 - 03/07/12 | ( register ) |
| Danville, PA | 04/16/12 - 04/18/12 | ( register ) |
| Danville, PA | 04/16/12 - 04/18/12 | ( register ) |
| Denver, CO | 03/05/12 - 03/07/12 | ( register ) |
| Richmond, VA | 03/05/12 - 03/07/12 | ( register ) |
| Baltimore, MD | 03/05/12 - 03/07/12 | ( register ) |
| Tallahassee, FL | 04/11/12 - 04/13/12 | ( register ) |
