Details for this torrent 

Linkedin - Database Foundations - Administration
Type:
Other > Other
Files:
45
Size:
402.36 MiB (421902449 Bytes)
Uploaded:
2024-01-26 21:41:15 GMT
By:
abdenna VIP
Seeders:
7
Leechers:
0
Comments
0  

Info Hash:
B40AF33ABD50C7C63AD7F144C0B657B6B7D94460




(Problems with magnets links are fixed by upgrading your torrent client!)
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

1. Introduction/1. Administer a database server.mp410.38 MiB
1. Introduction/2. What you should know.mp41.62 MiB
1. Introduction/3. How to work with the exercise files.mp418.32 MiB
2. Backup and Restore/1. Backup plans.mp419.06 MiB
2. Backup and Restore/2. Create a PostgreSQL backup.mp49.4 MiB
2. Backup and Restore/3. Use pg_dump in the Postgres container.mp413.64 MiB
2. Backup and Restore/4. Restore a Postgres database.mp426.18 MiB
2. Backup and Restore/5. Create a full SQL Server backup.mp417.81 MiB
2. Backup and Restore/6. Restore a SQL Server database.mp49.06 MiB
2. Backup and Restore/7. Incremental and differential backups.mp412.12 MiB
2. Backup and Restore/8. Point-in-time restores.mp414.11 MiB
3. Server Security/1. Principals and securables.mp412.88 MiB
3. Server Security/2. Server authentication and login accounts.mp415.23 MiB
3. Server Security/3. Granting and revoking permissions.mp413 MiB
3. Server Security/4. PostgreSQL role permissions.mp422.32 MiB
3. Server Security/5. SQL Server user permissions.mp430.34 MiB
4. Database Security/1. View permissions on PostgreSQL.mp418.26 MiB
4. Database Security/2. View permissions on SQL Server.mp416.98 MiB
4. Database Security/3. Column-level permissions.mp412.87 MiB
4. Database Security/4. Group permissions.mp48.58 MiB
5. High Availability/1. Managing server uptime.mp46.12 MiB
5. High Availability/2. Standby servers.mp417.59 MiB
5. High Availability/3. Synchronize servers with log shipping.mp410.21 MiB
5. High Availability/4. Server failover clusters.mp48.61 MiB
6. Health and Maintenance of the System/1. Server maintenance tasks.mp418.35 MiB
6. Health and Maintenance of the System/2. Closing user sessions.mp414.06 MiB
6. Health and Maintenance of the System/3. Reviewing system statistics.mp411.57 MiB
6. Health and Maintenance of the System/4. Reading system logs.mp48.28 MiB
7. Conclusion/1. Next steps.mp42.08 MiB
Exercise Files/Chapter 0/Server_Setup.txt1.63 KiB
Exercise Files/Chapter 0/Two_Trees_Database.txt10.92 KiB
Exercise Files/Chapter 1/Backup_PostgreSQL.txt734 B
Exercise Files/Chapter 1/Restore_PostgreSQL.txt1.18 KiB
Exercise Files/Chapter 1/Restore_SQL_Server.txt426 B
Exercise Files/Chapter 1/two_trees_backup.sql10.6 KiB
Exercise Files/Chapter 1/two_trees_sql_server.bak3.3 MiB
Exercise Files/Chapter 2/Roles_PostgreSQL.txt1.06 KiB
Exercise Files/Chapter 2/Users_SQL Server.txt1.07 KiB
Exercise Files/Chapter 3/Column_Permissions.txt723 B
Exercise Files/Chapter 3/Permissions_PostgreSQL.txt1.04 KiB
Exercise Files/Chapter 3/Permissions_SQLServer.txt1.07 KiB
Exercise Files/Chapter 5/Close_Session.txt301 B
Exercise Files/Chapter 5/Maintenance.txt282 B
Exercise Files/Chapter 5/Statistics.txt219 B
Exercise Files/Chapter 5/System_Logs.txt247 B