English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 07m | 403 MB
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.
Table of Contents
1 Administer a database server
2 Incremental and differential backups
3 Point-in-time restores
4 Principals and securables
5 Server authentication and login accounts
6 Granting and revoking permissions
7 PostgreSQL role permissions
8 SQL Server user permissions
9 View permissions on PostgreSQL
10 View permissions on SQL Server
11 Column-level permissions
12 What you should know
13 Group permissions
14 Managing server uptime
15 Standby servers
16 Synchronize servers with log shipping
17 Server failover clusters
18 Server maintenance tasks
19 Closing user sessions
20 Reviewing system statistics
21 Reading system logs
22 Next steps
23 How to work with the exercise files
24 Backup plans
25 Create a PostgreSQL backup
26 Use pg dump in the Postgres container
27 Restore a Postgres database
28 Create a full SQL Server backup
29 Restore a SQL Server database
Resolve the captcha to access the links!