Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam
What you will learn
This course will teach you the core concepts of distributed SQL.
What makes distributed SQL different from monolithic databases like Oracle, SQL Server and MySQL.
A deep dive into YugabyteDB architecture.
Exercises that show you how to install, develop, fail over and benchmark YugabyteDB.
Everything you need to know to prepare for the YugabyteDB Fundamentals Certification exam.
Why take this course?
Embark on a journey to understand the transformative power of distributed SQL databases and gain hands-on experience with one of the leading solutions, **YugabyteDB**. This course, led by the experienced **Jimmy Guerrero**, is designed to take you from beginner to proficient in just 90 minutes!
**Key Takeaways:**
– **Understanding Distributed SQL**: We’ll start by demystifying distributed SQL and how it differs from traditional monolithic databases like Oracle, SQL Server, PostgreSQL, and MySQL.
– **YugabyteDB Architecture**: Gain a deep understanding of YugabyteDB’s architecture and the design principles that make it highly scalable, resilient, and distributed by design.
– **YSQL API Development**: Learn the intricacies of developing with the YSQL API, enabling you to craft robust applications leveraging YugabyteDB.
**Course Outline:**
– **Distributed SQL Terms & Definitions**: We’ll cover the fundamental terminologies and concepts that are crucial for understanding distributed databases.
– **YugabyteDB Architecture & Design Principles**: Dive into the specifics of YugabyteDB’s architecture, including its approach to data distribution, consistency, and fault tolerance.
– **Hands-On Exercises**: Roll up your sleeves for a series of practical exercises that will reinforce your learning and give you real-world experience:
– Setting up single and multi-node clusters on various platforms (Mac, Linux, Kubernetes).
– Establishing JDBC connectivity.
– Managing users and securing your database.
– Working with databases, schemas, and creating objects from external data sources.
– Exploring sample databases and designing complex queries.
– Crafting functions and triggers to add custom logic to your database operations.
– Utilizing admin tools like pgAdmin, TablePlus, DBeaver to manage your YugabyteDB instance.
– Benchmarking with a Java load generator for real-world performance testing.
– Testing fault tolerance by simulating node removal and addition, and observing the rebalancing process.
– Running TPC-C benchmarks to evaluate your database’s capacity against industry standards.
**Course Review & Exam Preparation**: Before you wrap up, we’ll conduct a comprehensive review of the course material to ensure you’re fully prepared for the YugabyteDB certification exam.
By the end of this course, you’ll be armed with the knowledge and skills necessary to confidently work with distributed SQL databases. Whether you’re looking to advance your career or simply explore new technologies, **Distributed SQL and YugabyteDB Fundamentals** is the perfect stepping stone towards becoming a distributed database expert.
🎯 Enroll now and unlock the full potential of your data management skills with YugabyteDB! 🌟