SQLD Certification Prep Course

A DBA instructor with 30 years of experience teaches 45 essential SQL tuning techniques that can be immediately applied in practice through real-world examples. Master the practical know-how to make slow queries 10 times faster, from execution plan analysis to index optimization and join tuning!

1. What kind of course is this? - It includes theory and practical exercises to prepare for the SQLP certification. - It incorporates 30 years of experience from the database field. - It faithfully captures 10 years of offline lectures from Data & People in an online format. - We are confident that it will be the best course for preparing for the SQLP certification.

With the advent of the AI era, building data pipelines has become a core competency that determines a company's competitiveness. Learn how to build efficient data pipelines using Airflow, the most widely used tool, directly from a Silicon Valley expert (formerly Head of the Data Team at Udemy, currently a professor in the Data Masters program at San Jose State University) with practical experience and extensive lecturing experience.

If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

We introduce ways to utilize GA4 data in BigQuery. Using the GA4 BigQuery demo data from the Google Merchandise Store (https://www.googlemerchandisestore.com/) available publicly in BigQuery, we provide hands-on practice with basic SQL queries and introduce methods for marketers and planners to easily utilize GA4 BigQuery data.

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

This is a [Data Analysis, Programming Language] lecture prepared for SQL data analysis beginners. This is a SQL SELECT basic grammar lecture that starts without installing SQL.

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!