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

Ultimate IT Courses Logo

Database Training

Effective data management: Databases allow for the systematic storage and organization of enormous volumes of data, making it simple to retrieve and change the data as required.

by Ultimate IT Courses [Claim Listing ]
Calgary Learning Institute Logo

Fundamentals of Database Systems

Use the Fundamentals of Database Systems course and lab to learn database concepts and methodologies. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, and training.

by Calgary Learning Institute [Claim Listing ]
Global Erp Solutions Logo

SQL Training

SQL course training is offered by Global Erp Solutions for all skill level. This course delivers the skills on how quality assurance is performed. It focuses on Business process improvement and its maintenance in order to assure the highest quality possible.

by Global Erp Solutions [Claim Listing ]
Ontario College of Technology Logo

Data Analyst and Database Administrator

Data analytics and database management design, develop, and administer data management solutions, as well as develop and implement data administration policies, standards, and models.

by Ontario College of Technology [Claim Listing ]
OptionTrain College Of Management & Technology Logo

Microsoft SQL Server Course

At OptionTrain College, the 'Microsoft SQL Server' course offers a comprehensive journey into SQL Server's world. The program covers everything from installation to data manipulation using SQL's DML and DDL.

by OptionTrain College Of Management & Technology [Claim Listing ]

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