On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

SQ1000 Cross Platform SQL Essentials
 
 
Duration 2 Days
Delivery Method Instructor Led, Hands-on workshops
Public Price $1125.00


DESCRIPTION (Return to Top)

Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.

Examples and workshops are provided for the following platforms with discussion of the relevant differences:

  • DB2 for z/OS
  • DB2 for Linux, Unix & Windows
  • Oracle 10g & 11g
  • Microsoft SQL Server


AUDIENCE (Return to Top)

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.



TOPICS (Return to Top)
  • Relational Database Concepts
  • Basic Data Retrieval
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification


PREREQUISITES (Return to Top)

None