Databases – Database Communication

Duration

4 hours

Overview

This course describes how local and remote clients can connect to a DBMS server. It discusses connection options including the use of APIs. You will also see how an administrator can view existing client connections and configure the DBMS to place restrictions on client activity. Finally, you will see how replication provide copies of database systems on alternate DBMS servers. This is useful for redundancy purposes.

Audience

This course is suitable for Systems Programmers or DBAs whose responsibility is to create and manage databases, and their management systems.

Prerequisites

Successful completion of the Interskill Databases – Introduction to Databases and Database Managers course, or equivalent knowledge.

Objectives

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

• Describe how clients connect and communicate with DBMS servers
• Explain how DBMSs replicate data
• Describe other DBMS server-to-server communication

Course Content

DBMS Server Communications and Replication

Database Replication
Advantages and Disadvantages of Replication
Full and Partial Replication
Snapshot and Full Table Replication
Incremental Replication
Synchronous and Asynchronous Replication
Replication to Different DBMSs
Extract, Transform, and Load (ETL)
Data Pipeline Communications
Remote and Linked DBMSs