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
Client Communications
Connecting to the DBMS Server
Connection Options and Parameters
DBMS connectors and APIs
ODBC and JDBC Drivers
RESTful APIs
Viewing Client Connections
Terminating a Client Connection
Limiting Client Connections
Managing Connection Performance
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