Broadcom - Interskill Learning Mainframe Training

[email protected]

The Online Mainframe Training Specialists
Search   Course Catalog  
Return to Catalog Home     Return to Curriculum Listing

Databases – Introduction to Databases and Database Managers


4 hours


This course provides you with a core understanding of the need for databases, the way they are structured, and the type of information they can hold. It describes the types of database models that you are likely to encounter and describes their pros and cons. The use of a Database Management System (DBMS) is discussed, providing examples of functionality and features that are often employed by users of it. Finally, you will see how a database is defined and configured, along with the types of tasks that need to be performed as part of this process.


This course is suitable for IT professionals who will be working with, or retrieving data from, an enterprise database system.


General knowledge of your organization’s installed databases.


After completing this course, the student should be able to:

  • Describe the purpose of a database
  • Identify various database models and describe how they work
  • List core Database Manager features
  • Describe how a database is created
  • Identify administration tasks needed to support a database

Course Content

Introduction to Databases

Fields, Rows, and Columns
Information that can be Stored in a Database
Database Management System (DBMS)
Who Uses Databases?
Hierarchical Database Model
Relational Databases

Introduction to Database Managers

DBMS Functionality
Common DBMSs
DBMS Example Using SQL
Accessing, Displaying, and Updating Database Data
DBMS Core Functions
Data Backup and Recovery
DBMS Security
Connecting to a DBMS
Administration Tools

Introduction to Database Management

Tasks and Issues to be Addressed When Creating a Database
Installing the DBMS
Database Design
Conceptual, Logical, and Physical Data Models
Creating a Database, and Tables
Defining Field Attributes
Index Use
Configuring Data Security
Loading Data into the Database
DBMS Logging Requirements
Backup and Restore
Performance Monitoring
Data Replication
Extract, Transform, and Load (ETL)
Data Archiving

Databases – Introduction to Databases and Database Managers Mastery Test

Search our catalog