View Related Video
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.
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, and Microsoft SQL Server
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 for data manipulation.
- Translate and code business problems in Structured Query Language.
- State the internal approaches utilized for accessing data.