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

Oracle SQLTuning Training

Oracle is a relational database management system that optimizes the management and security of data sets by creating structured database schemas that are accessible only to administrators with permissions.

by Doussou Formation [Claim Listing ]
Roicians Logo

Oracle Admin I Training

This course is designed for OCA(Oracle Certified Associate) , Oracle Certification Preparation. We will cover complete industry practical scenarios in this course. Also this course is meant to prepare one for Oracle Jobs. We prepare students for Interviews and DBA Jobs.

by Roicians [Claim Listing ]
Global Erp Solutions Logo

Oracle Course

The Oracle Database 11g Administrator Certification (OCP 11g) from QuickCert ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

by Global Erp Solutions [Claim Listing ]
Knowledge Hut Logo

MySQL

This course is designed to help beginners as well as experienced professionals with a range of topics such as uploading files to servers, handling exceptions, working with functions and form data, manipulating system files, and more.

by Knowledge Hut [Claim Listing ]
  • Price
  • Start Date
  • Duration
Durham College Logo

Database

Students explore the differences between relational and non-relational databases to maintain and manage data in the cloud. Students design database with table relationships, build tables with different data types, and create queries and reports using Structured Query Language (SQL) & NoSQL database...

by Durham College [Claim Listing ]

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