Linkedin - Database Foundations - Administration

Category Other
Type Tutorials
Language English
Total size 402.4 MB
Uploaded By xHOBBiTx

Downloads 611
Last checked 7 hours ago
Date uploaded 1 year ago
Seeders 26
Leechers 0

Infohash : B40AF33ABD50C7C63AD7F144C0B657B6B7D94460

Quote:

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.

                Files: 

                Linkedin - Database Foundations - Administration
1. Introduction
1. Administer a database server.mp4 (10.4 MB)
2. What you should know.mp4 (1.6 MB)
3. How to work with the exercise files.mp4 (18.3 MB)

2. Backup and Restore
1. Backup plans.mp4 (19.1 MB)
2. Create a PostgreSQL backup.mp4 (9.4 MB)
3. Use pg_dump in the Postgres container.mp4 (13.6 MB)
4. Restore a Postgres database.mp4 (26.2 MB)
5. Create a full SQL Server backup.mp4 (17.8 MB)
6. Restore a SQL Server database.mp4 (9.1 MB)
7. Incremental and differential backups.mp4 (12.1 MB)
8. Point-in-time restores.mp4 (14.1 MB)

3. Server Security
1. Principals and securables.mp4 (12.9 MB)
2. Server authentication and login accounts.mp4 (15.2 MB)
3. Granting and revoking permissions.mp4 (13.0 MB)
4. PostgreSQL role permissions.mp4 (22.3 MB)
5. SQL Server user permissions.mp4 (30.3 MB)

4. Database Security
1. View permissions on PostgreSQL.mp4 (18.3 MB)
2. View permissions on SQL Server.mp4 (17.0 MB)
3. Column-level permissions.mp4 (12.9 MB)
4. Group permissions.mp4 (8.6 MB)

5. High Availability
1. Managing server uptime.mp4 (6.1 MB)
2. Standby servers.mp4 (17.6 MB)
3. Synchronize servers with log shipping.mp4 (10.2 MB)
4. Server failover clusters.mp4 (8.6 MB)

6. Health and Maintenance of the System
1. Server maintenance tasks.mp4 (18.3 MB)
2. Closing user sessions.mp4 (14.1 MB)
3. Reviewing system statistics.mp4 (11.6 MB)
4. Reading system logs.mp4 (8.3 MB)

7. Conclusion
1. Next steps.mp4 (2.1 MB)

Exercise Files
Chapter 0
Server_Setup.txt (1.6 KB)
Two_Trees_Database.txt (10.9 KB)

Chapter 1
Backup_PostgreSQL.txt (0.7 KB)
Restore_PostgreSQL.txt (1.2 KB)
Restore_SQL_Server.txt (0.4 KB)
two_trees_backup.sql (10.6 KB)
two_trees_sql_server.bak (3.3 MB)

Chapter 2
Roles_PostgreSQL.txt (1.1 KB)
Users_SQL Server.txt (1.1 KB)

Chapter 3
Column_Permissions.txt (0.7 KB)
Permissions_PostgreSQL.txt (1.0 KB)
Permissions_SQLServer.txt (1.1 KB)

Chapter 5
Close_Session.txt (0.3 KB)
Maintenance.txt (0.3 KB)
Statistics.txt (0.2 KB)
System_Logs.txt (0.2 KB)


              

There are currently no comments. Feel free to leave one :)

Code:

udp://tracker.opentrackr.org:1337/announce
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://tracker.dler.org:6969/announce
udp://tracker.openbittorrent.com:6969/announce
udp://tracker.tiny-vps.com:6969/announce
udp://tracker.cyberia.is:6969/announce
udp://bt1.archive.org:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce