Databases

• Databases Learning Road Map

Foundations

• Relational and Non-Relational Databases

SQL Fundamentals

• Common SQL Commands Cheat Sheet
• SQL Operators
• Types of Joins in SQL
• Aggregate functions in SQL
• Filtering a Table by the Result of Another Query in MySQL
• Detecting Duplicates

Relational Database Design

• Normalization
• Referential Integrity Constraints
• Using Enum Types in Databases

Intermediate Topics (Transactions & Optimization)

• Read Phenomena
• Isolation Levels
• SQL Execution Plans
• Improving SQL Query Performance

Working with Relational Databases

MySQL

• Install MySQL
• Install MySQL Workbench
• Import and Export Database in MySQL
• Managing Users for MySQL
• Connect to a Remote MySQL Database

Oracle

• Oracle Database
• Set up Oracle Database on Docker
• Working with Oracle Database in Docker
• Tablespaces
  • Undo Tablespace
• Oracle DB Locks
  • Locking Tables Manually
  • Monitor Blocked Sessions
• Index in Oracle Database
• Procedural Language/Structured Query Language (PL/SQL)
  • Comprehensive PL/SQL Example for an Online Game System
• SQL Execution Plan
• Troubleshooting Performance Issues in Oracle Databases
  • Automatic Workload Repository (AWR)
  • Oracle AWR Report
  • Oracle Performance Diagnostics using AWR and ADDM
  • Oracle Autonomous Health Framework (AHF)
  • Oracle Top SQL Analysis
  • Oracle SQL Tuning Advisor
  • Oracle Enterprise Manager Database Monitoring
• Security of Oracle Database Systems
  • Oracle Database User Management
• Oracle Database Backup and Recovery Strategy
• Upgrading an Oracle Database Running in a Docker Container
• Upgrading an Oracle Database on AWS RDS
• Oracle Listener
• Oracle Real Application Clusters (RAC)
  • Deploy and Manage Oracle Real Application Clusters (RAC) on AWS
  • Oracle Automatic Storage Management (ASM)
  • Oracle ASM and Amazon EBS
  • Installing and Setting up Oracle Grid Infrastructure
• Oracle Data Guard
  • Setting Up Oracle Data Guard on AWS
• Oracle RAC vs Data Guard
• Migrating Database from SQL Server to Oracle

PostgreSQL

• PostgreSQL Database

SQL Server

• Security of SQL Server Database Systems

Object-Relational Mapping (ORM)

Hibernate

• Hibernate
• Hibernate over JDBC
• HQL and SQL

NoSQL Databases

• Choosing the Right NoSQL Database

MongoDB

• MongoDB
• Documents and Collections
• Differences between MongoDB and SQL Databases
• Querying

Redis

• What is Redis?
• Installing Redis
• Basic Redis Commands
• Setup Redis for AdonisJS Applications
• How I applied Redis to The Project

Pinecone

• Overview

Administration and Operations

• Database Administrator (DBA)
• Security of Database Systems
• Backup and Recovery Strategies
  • Backup and Recovery Strategy for an Online Game Database System