Linkedin - Database Foundations - Administration
File List
| File | Size |
|---|---|
| 1. Introduction/1. Administer a database server.mp4 | 10.38 MB |
| 1. Introduction/2. What you should know.mp4 | 1.62 MB |
| 1. Introduction/3. How to work with the exercise files.mp4 | 18.32 MB |
| 2. Backup and Restore/1. Backup plans.mp4 | 19.06 MB |
| 2. Backup and Restore/2. Create a PostgreSQL backup.mp4 | 9.4 MB |
| 2. Backup and Restore/3. Use pg_dump in the Postgres container.mp4 | 13.64 MB |
| 2. Backup and Restore/4. Restore a Postgres database.mp4 | 26.18 MB |
| 2. Backup and Restore/5. Create a full SQL Server backup.mp4 | 17.81 MB |
| 2. Backup and Restore/6. Restore a SQL Server database.mp4 | 9.06 MB |
| 2. Backup and Restore/7. Incremental and differential backups.mp4 | 12.12 MB |
| 2. Backup and Restore/8. Point-in-time restores.mp4 | 14.11 MB |
| 3. Server Security/1. Principals and securables.mp4 | 12.88 MB |
| 3. Server Security/2. Server authentication and login accounts.mp4 | 15.23 MB |
| 3. Server Security/3. Granting and revoking permissions.mp4 | 13 MB |
| 3. Server Security/4. PostgreSQL role permissions.mp4 | 22.32 MB |
| 3. Server Security/5. SQL Server user permissions.mp4 | 30.34 MB |
| 4. Database Security/1. View permissions on PostgreSQL.mp4 | 18.26 MB |
| 4. Database Security/2. View permissions on SQL Server.mp4 | 16.98 MB |
| 4. Database Security/3. Column-level permissions.mp4 | 12.87 MB |
| 4. Database Security/4. Group permissions.mp4 | 8.58 MB |
| 5. High Availability/1. Managing server uptime.mp4 | 6.12 MB |
| 5. High Availability/2. Standby servers.mp4 | 17.59 MB |
| 5. High Availability/3. Synchronize servers with log shipping.mp4 | 10.21 MB |
| 5. High Availability/4. Server failover clusters.mp4 | 8.61 MB |
| 6. Health and Maintenance of the System/1. Server maintenance tasks.mp4 | 18.35 MB |
| 6. Health and Maintenance of the System/2. Closing user sessions.mp4 | 14.06 MB |
| 6. Health and Maintenance of the System/3. Reviewing system statistics.mp4 | 11.57 MB |
| 6. Health and Maintenance of the System/4. Reading system logs.mp4 | 8.28 MB |
| 7. Conclusion/1. Next steps.mp4 | 2.08 MB |
| Exercise Files/Chapter 0/Server_Setup.txt | 1.63 KB |
| Exercise Files/Chapter 0/Two_Trees_Database.txt | 10.92 KB |
| Exercise Files/Chapter 1/Backup_PostgreSQL.txt | 734 B |
| Exercise Files/Chapter 1/Restore_PostgreSQL.txt | 1.18 KB |
| Exercise Files/Chapter 1/Restore_SQL_Server.txt | 426 B |
| Exercise Files/Chapter 1/two_trees_backup.sql | 10.6 KB |
| Exercise Files/Chapter 1/two_trees_sql_server.bak | 3.3 MB |
| Exercise Files/Chapter 2/Roles_PostgreSQL.txt | 1.06 KB |
| Exercise Files/Chapter 2/Users_SQL Server.txt | 1.07 KB |
| Exercise Files/Chapter 3/Column_Permissions.txt | 723 B |
| Exercise Files/Chapter 3/Permissions_PostgreSQL.txt | 1.04 KB |
| Exercise Files/Chapter 3/Permissions_SQLServer.txt | 1.07 KB |
| Exercise Files/Chapter 5/Close_Session.txt | 301 B |
| Exercise Files/Chapter 5/Maintenance.txt | 282 B |
| Exercise Files/Chapter 5/Statistics.txt | 219 B |
| Exercise Files/Chapter 5/System_Logs.txt | 247 B |
Trackers
No trackers found.