Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Discover the most current techniques and best practices for securing, backing up, and restoring databases.
MTA Database Fundamentals (98-364) Cert Prep: 4 Administration
Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off
Master Finance Tools - 35% Off CFI (Code CFI35)
Overview
Syllabus
Introduction
- Administer a database server
- What you should know
- How to work with the exercise files
- Backup plans
- Create a PostgreSQL backup
- Use pg_dump in the Postgres container
- Restore a Postgres database
- Create a full SQL Server backup
- Restore a SQL Server database
- Incremental and differential backups
- Point-in-time restores
- Principals and securables
- Server authentication and login accounts
- Granting and revoking permissions
- PostgreSQL role permissions
- SQL Server user permissions
- View permissions on PostgreSQL
- View permissions on SQL Server
- Column-level permissions
- Group permissions
- Managing server uptime
- Standby servers
- Synchronize servers with log shipping
- Server failover clusters
- Server maintenance tasks
- Closing user sessions
- Reviewing system statistics
- Reading system logs
- Next steps
Taught by
Adam Wilbert
Related Courses
-
Introduction to Programming with Python
-
Database Foundations: Administration
-
MTA Database Fundamentals (98-364) Cert Prep: 4 Administration
-
Full Oracle Database Administration with RAC
-
MTA Database Fundamentals (98-364) Cert Prep: 1 Core Concepts
-
Complete Microsoft SQL Server Database Administration Course
