Database Administration Essentials And Design

by Last Minute Training Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Last Minute Training Logo

img Duration

5 Days

Course Details

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

  • This course is intended for entry to intermediate level or future Db2 database administrators or application programmers who need to acquire the essential skills required to administer a Db2 database

 

Topics

  • Entity Relationship Modeling
  • Normalization
  • Db2 Overview and Storage Concepts
  • Create and Maintain Db2 Objects
  • Referential Integrity
  • Utilities
  • Program Preparation, Bind and Locking
  • Security
  • Toronto Branch

    750 Sammon Avenue, Toronto

Check out more Database Management courses in Canada

Doussou Formation Logo

SQL Server Training

At the end of this course, participants will be able to create tables, insert, query, modify,, and delete data from tables.

by Doussou Formation [Claim Listing ]
HiTech Institute Logo

Database

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.

by HiTech Institute [Claim Listing ]
VoiSAP Calgary Logo

MY SQL DBA Certification Training

MySQL DBA Certification Training trains you on the core concepts and advanced tools and techniques to manage data and administer the MySQL database.

by VoiSAP Calgary [Claim Listing ]
ExitCertified Logo

MySQL Fundamentals Ed 1

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.

by ExitCertified [Claim Listing ]
NetPLUS College of Information Technology Logo

MS SQL

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

by NetPLUS College of Information Technology [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy