YoVDO

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

Offered By: LinkedIn Learning

Tags

Database Administration Courses PostgreSQL Courses Database Security Courses Access Control Courses High Availability Courses

Course Description

Overview

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

Related Courses

Cybersecurity and Its Ten Domains
University System of Georgia via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Desarrollo de Aplicaciones Web: Seguridad
University of New Mexico via Coursera
Web Application Development: Security
University of New Mexico via Coursera
Computing, Storage and Security with Google Cloud Platform
Google via Coursera