Intermediate/Advanced SQL Training (Custom for TRS of Texas)

PT24979
Training 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.
The format is lecture/questions about a topic followed by a lab activity to reinforce the student’s understanding. To ensure even greater understanding, the instructor will add a demonstration to review with the group. If time allows, the students will be asked to type the code along with the instructor, so they get more hands-on time. Since all students work at a different pace, some of them will complete the activities and some won't. The instructor will then review and move on to the next topic. The SQL Intermediate portion covers a lot of ground in a short amount of time because the basics of SQL are assumed to be known.  
Duration
3 Days/Lecture & Lab
Audience
This course is designed for application developers.
Course Topics
  • Introduction
  • Multiple tables
  • Text handling issues
  • Case logic
  • SQL summarization
  • Stored Procedures
  • User-defined Functions
  • Performance considerations
  • Temp tables

Related Scheduled Courses