Skip to content

School Of SRE Introduction

Home
Level 101
Level 101
- Fundamentals Series
  Fundamentals Series
  - Linux Basics
    Linux Basics
    
    Introduction
    
    Command Line Basics
    
    Server Administration
    
    Conclusion
  - Git
    Git
    
    Git Basics
    
    Working With Branches
    
    Github and Hooks
    
    Conclusion
  - Linux Networking
    Linux Networking
    
    Introduction
    
    DNS
    
    UDP
    
    HTTP
    
    TCP
    
    Routing
    
    Conclusion
- Python and Web
  Python and Web
- Data
  Data
  - Relational Databases
    Relational Databases
    
    Introduction Introduction
    Table of contents
    
    Prerequisites
    
    What to expect from this course
    
    What is not covered under this course
    
    Introduction
    
    Pre-reads
    
    Course Contents
    
    Key Concepts
    
    MySQL
    
    InnoDB
    
    Backup and Recovery
    
    MySQL Replication
    
    Operational Concepts
    
    Select Query
    
    Query Performance
    
    Lab
    
    Conclusion
  - NoSQL
    NoSQL
    
    Introduction
    
    Key Concepts
    
    Conclusion
  - Message Queue
    Message Queue
    
    Introduction
    
    Key Concepts
    
    Conclusion
  - Big Data
    Big Data
    
    Introduction
    
    Evolution and Architecture of Hadoop
    
    Conclusion
- Systems Design
  Systems Design
- Metrics and Monitoring
  Metrics and Monitoring
- Security
  Security
Level 102
Level 102
- Linux Intermediate
  Linux Intermediate
- Linux Advanced
  Linux Advanced
  - Containerization And Orchestration
    Containerization And Orchestration
    
    Introduction
    
    Introduction To Containers
    
    Containerization With Docker
    
    Orchestration With Kubernetes
    
    Conclusion
  - System Calls and Signals
    System Calls and Signals
    
    Introduction
    
    Signals
    
    System Calls
    
    Conclusion
- Networking
  Networking
- System Design
  System Design
- System Troubleshooting and Performance Improvements
  System Troubleshooting and Performance Improvements
- Continuous Integration and Continuous Delivery
  Continuous Integration and Continuous Delivery
Contribute
Code of Conduct
SRE Community

Relational Databases

Prerequisites

Complete Linux course
Install Docker (for lab section)

What to expect from this course

You will have an understanding of what relational databases are, their advantages, and some MySQL specific concepts.

What is not covered under this course

In-depth implementation details
Advanced topics like normalization, sharding
Specific tools for administration

Introduction

The main purpose of database systems is to manage data. This includes storage, adding new data, deleting unused data, updating existing data, retrieving data within a reasonable response time, other maintenance tasks to keep the system running, etc.

Pre-reads

Course Contents

Key Concepts
MySQL Architecture
InnoDB
Backup and Recovery
MySQL Replication
Operational Concepts
- SELECT Query
- Query Performance
Lab
Further Reading