Databases – Introduction to Databases and Database Managers
Duration
4 hours
Overview
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.
Audience
This course is suitable for IT professionals who will be working with, or retrieving data from, an enterprise database system.
Prerequisites
General knowledge of your organization’s installed databases.
Objectives
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
NoSQL
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