Database Foundations: Administration

Course details

Ongoing, regular administration is critical to the security and performance of databases such as SQL Server. In this course—the fourth installment in the Database Foundations series—explore vital techniques and best practices for administering a database. Instructor Adam Wilbert covers a variety of core concepts, including how to secure a server with user authentication and roles, protect your database by setting up permissions for authorized user accounts, and perform a backup and restore. Adam also offers expert tips for ensuring that a database remains available, even through hardware maintenance, upgrades, and failures. Along the way, he provides tips for working effectively with both SQL Server and PostgreSQL.

Concepts

0. Introduction

01 - Administer a database server
02 - What you should know
03 - How to work with the exercise files

1. Backup and Restore

04 - Backup plans
05 - Create a PostgreSQL backup
06 - Use pg dump in the Postgres container
07 - Restore a Postgres database
08 - Create a full SQL Server backup
09 - Restore a SQL Server database
10 - Incremental and differential backups
11 - Point-in-time restores

2. Server Security

12 - Principals and securables
13 - Server authentication and login accounts
14 - Granting and revoking permissions
15 - PostgreSQL role permissions
16 - SQL Server user permissions

3. Database Security

17 - View permissions on PostgreSQL
18 - View permissions on SQL Server
19 - Column-level permissions
20 - Group permissions

4. High Availability

21 - Managing server uptime
22 - Standby servers
23 - Synchronize servers with log shipping
24 - Server failover clusters

5. Health and Maintenance of the System

25 - Server maintenance tasks
26 - Closing user sessions
27 - Reviewing system statistics
28 - Reading system logs

Conclusion

29 - Next steps