Databases

General

• Referential Integrity Constraints
• Read Phenomena
• Isolation Levels
• Database Administrator (DBA)
• Security of Database Systems
• Backup and Recovery Strategies
  • Backup and Recovery Strategy for an Online Game Database System
• Choosing the Right NoSQL Database
• How I applied Redis to The Project

SQL

• Aggregate functions in SQL
• Types of Joins in SQL
• Detecting Duplicates
• Improving SQL Query Performance
• Normalization
• SQL Execution Plans

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

MongoDB

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

GraphQL

• Working with GraphQL
• Writing a GraphQL query

Redis

• What is Redis?
• Installing Redis
• Basic Redis Commands