SQL Basics

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.

3 Days/Lecture & Lab

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.

  • 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

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.


Copyright © 2017 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media