SQL Basics

PT1736
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.
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.
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

Related Scheduled Courses