Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Los Angeles, CA
Minneapolis, MN
New York, NY
Oakbrook, IL
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
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: May 18, 2013
