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: | ||
| Ottawa, ON | 11/08/10 - 11/10/10 | ( register ) |
| Halifax, NS | 11/22/10 - 11/24/10 | ( register ) |
| Toronto, ON | 09/13/10 - 09/15/10 | ( register ) |
| Toronto, ON | 10/04/10 - 10/06/10 | ( register ) |
| Toronto, ON | 12/13/10 - 12/15/10 | ( register ) |
| Pittsburgh, PA | 09/20/10 - 09/22/10 | ( register ) |
| Vancouver, BC | 11/08/10 - 11/10/10 | ( register ) |
| Kansas City, MO | 11/15/10 - 11/17/10 | ( register ) |
| Tallahassee, FL | 10/04/10 - 10/06/10 | ( register ) |
| Guelph, ON | 09/27/10 - 09/29/10 | ( register ) |
| Virtual Classroom, EL | 09/20/10 - 09/24/10 | ( register ) |
| Pittsburgh, PA | 09/20/10 - 09/22/10 | ( register ) |
| Virtual Classroom, EL | 09/20/10 - 09/22/10 | ( register ) |
