GCP BigQuery Tutorial for Beginners

Let's learn the core theories of AWS services that are often used in companies and various projects these days, and make AWS completely our own through hands-on practice!

This introductory course for AI engineers is designed to provide a brief hands-on experience of the entire process, from data processing and model development to cloud, MLOps, and ethical considerations. It focuses on building practical skills by helping students understand the process of connecting models to actual services, rather than just creating them. The course includes hands-on exercises and examples so that even those learning AI for the first time can easily follow along.

Do you still feel like something is lacking even after taking all the AWS beginner, intermediate/advanced courses? The AWS practical course is just for you.

Have you completed the AWS beginner course but are you still lacking 2%? You thought you knew a lot about AWS but there are still some areas that need to be refined? Let's fill in that 2% with the AWS intermediate/advanced course! Until the day you become a Data Engineer Expert!

Do you want to master the Python language? This course is designed to help even those with no coding experience learn Python easily through fun examples. In addition, the extensive coding exercises will greatly help improve your coding skills.

Learn how to use the most commonly and importantly used advanced T-SQL queries in practice from a SQL Server expert consultant and Microsoft MVP, so you can write SQL in a more SQL-like way.

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

This is an Oracle DBMS SQL course for beginners.

Make the most of relational database systems!

Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

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

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

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.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

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

This is a course for learning MS-SQL through baseball and corporate databases.