Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Database Foundations: Administration

via LinkedIn Learning

Go to class Write review

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

Reviews

4.8 rating at LinkedIn Learning based on 65 ratings

Start your review of Database Foundations: Administration