Black Friday 2024: 25+ Ways to Save on Online Learning

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

MTA Database Fundamentals (98-364) Cert Prep: 4 Administration

via LinkedIn Learning

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
Discover the most current techniques and best practices for securing, backing up, and restoring databases.

Syllabus

Introduction
  • Administer a database server
  • What you should know
  • How to work with the exercise files
1. Backup and Restore
  • 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
2. Server Security
  • Principals and securables
  • Server authentication and login accounts
  • Granting and revoking permissions
  • PostgreSQL role permissions
  • SQL Server user permissions
3. Database Security
  • View permissions on PostgreSQL
  • View permissions on SQL Server
  • Column-level permissions
  • Group permissions
4. High Availability
  • Managing server uptime
  • Standby servers
  • Synchronize servers with log shipping
  • Server failover clusters
5. Health and Maintenance of the System
  • Server maintenance tasks
  • Closing user sessions
  • Reviewing system statistics
  • Reading system logs
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 194 ratings

Start your review of MTA Database Fundamentals (98-364) Cert Prep: 4 Administration

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.