Loading Course Schedule...
PT24979
Summary
This course covers ANSI/ISO standard SQL, with examples in SQL Server, Oracle, DB2 LUW and z/OS, and MySQL, with emphasis on SQL Server and Oracle.
Prerequisites
Three or Four Days
- Three days of intense, fast pace training based on the course outline.
- Four days of training would allow for a slower pace, more question and answer time allowing for deeper discussions and additional hands-on time to complete all of the activities.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for application developers.
Topics
- Introduction
- Multiple tables
- Text handling issues
- Case logic
- SQL summarization
- Stored Procedures
- User-defined Functions
- Performance considerations
- Temp tables