Section outline

• Select section Introduction to Database Administration (DBA)

  Collapse Expand

  Introduction to Database Administration (DBA)

  Collapse all Expand all

  • Select activity Overview of databases and data management

    

    Overview of databases and data management Page
  • Select activity Responsibilities of a DBA in Modern IT Environments

    

    Responsibilities of a DBA in Modern IT Environments Page
  • Select activity Trends: Cloud Databases, Database-as-a-Service (DBaaS), and Containerization

    

    Trends: Cloud Databases, Database-as-a-Service (DBaaS), and Containerization Page
  • Select activity Industry Best Practices and Career Paths

    

    Industry Best Practices and Career Paths Page
  • Select activity Announcements

    

    Announcements Forum
• Select section Fundamentals of Relational Database Management Systems (RDBMS)

  Collapse Expand

  Fundamentals of Relational Database Management Systems (RDBMS)

  • Select activity Core Concepts: Tables, Columns, Rows, Primary/Foreign Keys

    

    Core Concepts: Tables, Columns, Rows, Primary/Foreign Keys Page
  • Select activity Data Modeling and Normalization

    

    Data Modeling and Normalization Page
  • Select activity Basic SQL: SELECT, INSERT, UPDATE, DELETE

    

    Basic SQL: SELECT, INSERT, UPDATE, DELETE Page
  • Select activity RDBMS Architecture and Storage Fundamentals

    

    RDBMS Architecture and Storage Fundamentals Page
  • Select activity Installation and Basic Configuration of an RDBMS Environment

    

    Installation and Basic Configuration of an RDBMS Environment Page
  • Select activity Filter Customers by City

    

    Filter Customers by City Quiz
• Select section Introduction to Non‑Relational (NoSQL) Databases

  Collapse Expand

  Introduction to Non‑Relational (NoSQL) Databases

  • Select activity Differences between Relational and NoSQL Databases

    

    Differences between Relational and NoSQL Databases Page
  • Select activity Use Cases for NoSQL: Scalability, Flexibility, and Big Data

    

    Use Cases for NoSQL: Scalability, Flexibility, and Big Data Page
  • Select activity Deep Dive – Document Databases Using MongoDB (with reference to Redis, Cassandra, and Neo4j)

    

    Deep Dive – Document Databases Using MongoDB (with reference to Redis, Cassandra, and Neo4j) Page
  • Select activity Data Modeling in a Schema‑Free Environment

    

    Data Modeling in a Schema‑Free Environment Page
  • Select activity MongoDB Hands-on

    

    MongoDB Hands-on Quiz
• Select section Data Modeling and Schema Design

  Collapse Expand

  Data Modeling and Schema Design

  • Select activity Relational Schema Design – Normalization vs. Denormalization

    

    Relational Schema Design – Normalization vs. Denormalization Page
  • Select activity NoSQL Data Design – Flexibility vs. Consistency Trade-offs

    

    NoSQL Data Design – Flexibility vs. Consistency Trade-offs Page
  • Select activity Case Studies – Choosing the Right Model for Different Application Scenarios

    

    Case Studies – Choosing the Right Model for Different Application Scenarios Page
  • Select activity Tools for Modeling – ER Diagrams and JSON Schema

    

    Tools for Modeling – ER Diagrams and JSON Schema Page
• Select section Database Security, Backup, and Recovery

  Collapse Expand

  Database Security, Backup, and Recovery

  • Select activity Security Fundamentals

    

    Security Fundamentals Page
  • Select activity Auditing and Compliance

    

    Auditing and Compliance Page
  • Select activity Backup Types and Strategies

    

    Backup Types and Strategies Page
  • Select activity Disaster Recovery Planning

    

    Disaster Recovery Planning Page
  • Select activity High Availability and Replication Strategies

    

    High Availability and Replication Strategies Page
• Select section Performance Tuning and Monitoring

  Collapse Expand

  Performance Tuning and Monitoring

  • Select activity Query Optimization and Indexing Strategies for Relational Databases

    

    Query Optimization and Indexing Strategies for Relational Databases Page
  • Select activity Understanding Performance Metrics and Monitoring Tools

    

    Understanding Performance Metrics and Monitoring Tools Page
  • Select activity Techniques for Scaling NoSQL Databases (Sharding, Replication)

    

    Techniques for Scaling NoSQL Databases (Sharding, Replication) Page
  • Select activity Tools and Best Practices for Scheduled Maintenance and Performance Tuning

    

    Tools and Best Practices for Scheduled Maintenance and Performance Tuning Page
• Select section Cloud & DevOps Integration

  Collapse Expand

  Cloud & DevOps Integration

  • Select activity Overview of Cloud Database Services

    

    Overview of Cloud Database Services Page
  • Select activity Introduction to Containerization and Orchestration for Databases

    

    Introduction to Containerization and Orchestration for Databases Page
  • Select activity CI/CD Pipelines for Database Changes and Migrations

    

    CI/CD Pipelines for Database Changes and Migrations Page
  • Select activity Infrastructure as Code (IaC) and Automation Scripts for Database Administration

    

    Infrastructure as Code (IaC) and Automation Scripts for Database Administration Page
• Select section Wrap-Up & Future Directions

  Collapse Expand

  Wrap-Up & Future Directions

  • Select activity Recap of key concepts learned throughout the course

    

    Recap of key concepts learned throughout the course Page
  • Select activity Assessment

    

    Assessment Quiz

    Completion

    Students must

    

    Receive a grade

    

    Receive a passing grade