|
NWSQ1000 Cross Platform SQL Essentials
DESCRIPTION
Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. This 2 day 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
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
- Relational Database Concepts
- Basic Data Retrieval
- Intermediate Data Manipulation
- Built-in Functions
- Aggregation
- Joins
- Data Modification
PREREQUISITES
None
|
