Database Foundations: Administration

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

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