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 will 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
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
Introduction to Database Managers
DBMS Example Using SQL
Accessing, Displaying, and Updating Database Data
DBMS Core Functions
Data Backup and Recovery
Connecting to a DBMS
Introduction to Database Management
Tasks and Issues to be Addressed When Creating a Database
Installing the DBMS
Conceptual, Logical, and Physical Data Models
Creating a Database, and Tables
Defining Field Attributes
Configuring Data Security
Loading Data into the Database
DBMS Logging Requirements
Backup and Restore
Extract, Transform, and Load (ETL)