Welcome and Housekeeping
- Welcome and Housekeeping
Terms and Definitions
- What is Distributed SQL and how does it compare to NoSQL
- Scaling Out
- Distributed ACID Transactions and Comparing SQL Systems
- What is YugabyteDB and comparing it to Google Spanner
- CAP Theorem and Raft Consensus Algorithim
- Terms and Definitions Quiz
YugabyteDB Architecture
- YugabyteDB Components
- Architecture Overview
- YugabyteDB Services
- YB-TServer Service
- YB-Master Service
- YugabyteDB Architecture and Services
- DocDB Document Store
- Sharding Data
- Storage Layer
- Replicating Data
- Sharding and Replicating Data
- Query Later Overview
- YSQL Overview
- Reviewing APIs
- YCQL Overview
- Node Count, Replication Factor & Fault Tolerance
- Cluster Deployment Configurations
- Network Partitions in Distributed Databases
- Secondary Indexes, Collocated Tables and Change Data Capture (CDC)
YSQL API
- An Overview of PostgreSQL Architecture and How YugabyteDB Reuses Its Query Layer
- Reviewing the YSQL API
Exercises
- Installing a Single Node of YugabyteDB with yugabyted
- Installing a Local 3-Node YugabyteDB Cluster
- Install a 3 Node YugabyteDB Cluster on Google Kubernetes Engine
- The YugabyteDB Web UI
- Install the Northwind Sample Database
- Getting Started with DBeaver - DBA Tools
- Creating Databases, Schemas and Calling External Files
- Creating a Function
- Creating a Trigger
- User Management
- Fault Tolerance Demo Setup
- Fault Tolerance in Action
- Setting Up a TPCC Benchmark
Course Review
- Course Review and Exam Prep
Next Steps
- Exam Prep Guide, Exam, Certificate and Badge Informations
