MTA Database Fundamentals (98-364) Cert Prep: 4 Administration

Offered By: LinkedIn Learning

Tags

Database Administration Courses PostgreSQL Courses Database Security Courses Access Control Courses High Availability Courses

Course Description

Overview

Discover the most current techniques and best practices for securing, backing up, and restoring databases.

Syllabus

Introduction

Administer a database server
What you should know
How to work with the exercise files

1. Backup and Restore

Backup plans
Create a PostgreSQL backup
Use pg_dump in the Postgres container
Restore a Postgres database
Create a full SQL Server backup
Restore a SQL Server database
Incremental and differential backups
Point-in-time restores

2. Server Security

Principals and securables
Server authentication and login accounts
Granting and revoking permissions
PostgreSQL role permissions
SQL Server user permissions

3. Database Security

View permissions on PostgreSQL
View permissions on SQL Server
Column-level permissions
Group permissions

4. High Availability

Managing server uptime
Standby servers
Synchronize servers with log shipping
Server failover clusters

5. Health and Maintenance of the System

Server maintenance tasks
Closing user sessions
Reviewing system statistics
Reading system logs

Conclusion

Next steps

Taught by

Adam Wilbert

Related Courses

Web Application Development: The Data Tier
University of New Mexico via Coursera Desarrollo de Aplicaciones Web: Nivel de Datos
University of New Mexico via Coursera Hacking PostgreSQL: Data Access Methods
Ural Federal University via edX Spatial Data Science and Applications
Yonsei University via Coursera RDBMS PostgreSQL
Indian Institute of Technology Bombay via Swayam