Distributed SQL and YugabyteDB Fundamentals

Course Feature

Cost

Free
Provider

Udemy
Certificate

No Information
Language

English
Start Date

2021-01-05
Learners

No Information
Duration

No Information
Instructor

Jimmy Guerrero

Add to Favorites

4.7

3,869 Ratings

This course will teach you the fundamentals of distributed SQL and YugabyteDB. In 90 minutes, you'll learn the core concepts of distributed SQL, YugabyteDB architecture and design principles, YSQL API development, and more. Through lectures and hands-on exercises, you'll gain the knowledge and skills to configure and get started with YugabyteDB. You'll also work through a variety of exercises, such as single and multi-node cluster installs, JDBC connectivity, user management and basic security, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools, using a Java load generator, and testing fault tolerance. Don't miss out on this opportunity to learn the fundamentals of distributed SQL and YugabyteDB!

Show All

Distributed SQL and YugabyteDB Fundamentals

Go to class

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
This course will provide students with the knowledge and skills to configure and get started with YugabyteDB. Students will learn the core concepts of distributed SQL and how it differs from monolithic databases such as Oracle SQL Server PostgreSQL and MySQL. Through lectures and hands-on exercises, students will gain an understanding of distributed SQL terms, definitions, and comparisons, as well as YugabyteDB architecture and design principles. Additionally, students will learn how to use the YSQL API for development, and will be able to review and prepare for exams. Hands-on exercises will include single and multi-node cluster installs on Mac, Linux, and Kubernetes, JDBC connectivity, user management and basic security, working with databases and schemas, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools like pgAdmin TablePlus and DBeaver, using a Java load generator, and testing fault tolerance (remove node, add node, rebalancing) and TPC-C benchmarking.
Professional Growth:
This course contributes to professional growth by providing a comprehensive overview of distributed SQL and YugabyteDB fundamentals. Through lectures and hands-on exercises, participants will gain the knowledge and skills to configure and get started with YugabyteDB. The topics covered in-depth include distributed SQL terms, definitions, and comparisons, YugabyteDB architecture and design principles, YSQL API development, and course review and exam prep. Additionally, the hands-on exercises provide practical experience with single and multi-node cluster installs, JDBC connectivity, user management and basic security, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools, using a Java load generator, and testing fault tolerance. Finally, the course also covers TPC-C benchmarking.
Further Education:
This course appears to be suitable for preparing for further education, as it covers the core concepts of distributed SQL and provides hands-on exercises to develop the knowledge and skills to configure and get started with YugabyteDB. The topics covered in-depth include distributed SQL terms, definitions, and comparisons, YugabyteDB architecture and design principles, YSQL API development, and course review and exam prep. Additionally, the hands-on exercises provide practical experience with single and multi-node cluster installs, JDBC connectivity, user management and basic security, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools, using a Java load generator, and testing fault tolerance.

Course Syllabus

Welcome and Housekeeping

Terms and Definitions

YugabyteDB Architecture

YSQL API

Exercises

Course Review

Next Steps

Show All

Recommended Courses

How to Migrate Your Access Database to the Cloud With Caspio

4.7

Udemy 6,808 learners

Learn More

This course is perfect for anyone who wants to learn how to migrate their existing Microsoft Access DB application to the cloud with Caspio. With this course, you will learn how to take an existing Access DB application and convert it to a custom web application without writing a single line of code. You will learn how to import your Access tables, data, and relationships into Caspio, and how to quickly and easily recreate all the forms and reports using Caspio's easy to use platform. Click now to learn how to migrate your Access Database to the cloud with Caspio!

Database Design and Management

4.2

Udemy 89,502 learners

Learn More

This Database Design and Management course is perfect for software development teams who need to develop applications or software systems that require data persistence. With 14 lectures and over 2 hours of quality videos, you will learn key features in Visual Paradigm, ERD, keys, relationships, database view, triggers, stored procedures, database patching, reverse engineering of ERD, ORM, and best practices in database design and management. After completing this online training, you will be able to design databases productively and effectively.

Develop Database Application with Minimal Coding - Kushal

4.0

Udemy 17,133 learners

Learn More

Are you looking for a way to develop a database application without manual coding? Kushal from ERachana Technologies is the perfect solution for you! With this tutorial, you will learn how to create a simple database and develop a database application with minimal coding. In 9 sections of around 4 minutes each, you will go from scratch to develop a fully functional contact management software. Whether you are a student, database administrator, tester, graduate, application developer, excel expert or advanced computer user, this tutorial is perfect for you. Follow them on Facebook for updates regarding Kushal and start your journey to becoming a database application developer today!

Introduction to Database Systems

3.3

Udemy 3,664 learners

Learn More

This course, Introduction to Database Systems, is the perfect way to learn the basics of databases. It covers topics such as database architecture, relational models, Structured Query Language (SQL), security issues, normalization techniques, ER modeling, and data warehouse concepts. Through videos and quizzes, students will gain the knowledge to create and modify tables that meet the needs of their organization. With a total duration of one hour, this course is short enough to fit into any schedule. Sign up now and get started on your journey to understanding databases!