Detailed Course Outline
Welcome and Administration
- Unit 1. SQL Concepts
- Introducing SQL
- Unit 2. Extracting Data Using SELECT
- The SELECT Statement
- Using System i Navigator
- Using 5250 STRSQL
- Unit 3. Functions
- Column Functions
- Scalar Functions
- CASE and CAST
- Unit 4. JOIN and UNION
- Using JOIN
- UNION
- Unit 5. SubSELECTs
- Using SubSELECTs / Subqueries
- Unit 6. Query Tools
- Using Query Manager
- Unit 7. Database Maintenance
- SQL Data Types
- SQL Data Definition and Manipulation
- Data Integrity
- SQL SYS Objects
- Creating SQL Objects on the System i