Database Foundations: Administration

Focused View

Adam Wilbert

2:07:44

0 View

1. Administer a database server.mp4

01:00

2. What you should know.mp4

00:35

3. How to work with the exercise files.mp4

05:36

4. Backup plans.mp4

04:29

5. Create a PostgreSQL backup.mp4

03:31

6. Use pg dump in the Postgres container.mp4

06:12

7. Restore a Postgres database.mp4

10:13

8. Create a full SQL Server backup.mp4

06:42

9. Restore a SQL Server database.mp4

03:42

10. Incremental and differential backups.mp4

04:30

11. Point-in-time restores.mp4

04:20

12. Principals and securables.mp4

03:01

13. Server authentication and login accounts.mp4

03:23

14. Granting and revoking permissions.mp4

04:04

15. PostgreSQL role permissions.mp4

07:49

16. SQL Server user permissions.mp4

10:56

17. View permissions on PostgreSQL.mp4

05:44

18. View permissions on SQL Server.mp4

05:03

19. Column-level permissions.mp4

04:09

20. Group permissions.mp4

03:06

21. Managing server uptime.mp4

02:11

22. Standby servers.mp4

03:54

23. Synchronize servers with log shipping.mp4

02:37

24, Server failover clusters.mp4

03:14

25. Server maintenance tasks.mp4

05:40

26. Closing user sessions.mp4

04:29

27. Reviewing system statistics.mp4

03:43

28. Reading system logs.mp4

02:58

29. Next steps.mp4

00:53

Ex Files Database Foundations Administration.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.