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.
This course is suitable for Systems Programmers or DBAs whose responsibility is to create and manage databases, and their management systems.
Successful completion of the Interskill Databases – Introduction to Databases and Database Managers course, or equivalent knowledge.
After completing this course, the student will be able to:
- Describe how clients connect and communicate with DBMS servers
- Explain how DBMSs replicate data
- Describe other DBMS server-to-server communication
Connecting to the DBMS Server
Connection Options and Parameters
DBMS connectors and APIs
ODBC and JDBC Drivers
Viewing Client Connections
Terminating a Client Connection
Limiting Client Connections
Managing Connection Performance
DBMS Server Communications and Replication
Advantages and Disadvantages of Replication
Full and Partial Replication
Snapshot and Full Table Replication
Synchronous and Asynchronous Replication
Replication to Different DBMSs
Extract, Transform, and Load (ETL)
Data Pipeline Communications
Remote and Linked DBMSs