|
|
|
|
400+ Course Offerings:
| DB2 for z/OS |
| DB2 for Linux, UNIX, Windows |
| CICS/TS |
| MQSeries |
| Web Services, SOA and XML |
| WebSphere |
| WebLogic |
| IMS |
| Mainframe - Assembler, COBOL, MVS/JCL, REXX, SAS |
| Java/J2EE & Frameworks |
| Linux |
| UNIX, C, C++ |
| Oracle |
| Sybase |
| PowerBuilder / InfoMaker |
| Data Warehouse, Data Modeling and Database Design |
| Microsoft - .NET, SharePoint, SQL Server |
| Project Management |
|
|
SQ1000 Cross Platform SQL Essentials
|
|
|
|
View Schedule and Enroll
|
|
Full Course Description
|
| |
|
Duration |
2 Days |
|
Delivery Method |
Instructor Led, Hands-on workshops |
|
Public Price |
$950.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
|
|
|
|
|