This course is designed to provide the student with the knowledge to effectively and efficiently design, create and maintain Db2 databases using Db2 for z/OS. The student will learn how to use Entity Relationship Modeling techniques to design and normalize a relational database.
This course is designed to provide the student with the knowledge to effectively and efficiently design, create and maintain Db2 databases using Db2 for z/OS. The student will learn how to use Entity Relationship Modeling techniques to design and normalize a relational database.
They will demonstrate how to define Db2 objects, including Databases, Storage Groups, Tablespaces, Tables, including temporal tables, Indexes, Views, Aliases, Materialized Query Tables and Clone Tables. The student will also develop skills to load, modify, backup, and recover Db2 data using Db2 utilities.
Audience
Topics
The fastest and easiest way to find training seminars, workshops and webinars in Canada!
At the end of this course, participants will be able to create tables, insert, query, modify,, and delete data from tables.
Database courses are offered by HiTech Institute. HiTech Institute offers courses in three settings: traditional state-of-the art classrooms, on-site at your office, and virtual learning opportunities.
MySQL DBA Certification Training trains you on the core concepts and advanced tools and techniques to manage data and administer the MySQL database.
The MySQL Fundamentals training is the first step in mastering MySQL, the world's most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.
Write SELECT statements to access data from more than one table using equijoins and none qui joins. Generate a Cartesian product of all rows from two or more tables
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy