View Related Video
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, SQL Server or PostgreSQL.
Description
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 Database, Microsoft SQL Server, and PostgreSQL. Differences between the RDBMSs are highlighted throughout the material and especially the SQL workshops. The workshops may be performed on any of the above platforms. Students will leave with the ability to code queries involving simple to intermediate complexity.
Objectives
Upon successful completion of this course, the student will be able to:
- Describe the overall purpose of, and the approaches to manipulating data in a database management system.
- Describe the major objects used by a relational database for data manipulation.
- Translate and code business problems in Structured Query Language.
Prerequisites
None