SQL Tuning You Can Run Yourself: Preparing for the SQLP Practical Exam

Ahead of a major event, what should you prepare in your database, and what should you check first when it goes live? Practice your pre-, during, and post-event response sequence using training Aurora logs of Reader CPU spikes, lock waits, deadlocks, and failovers, along with diagnostic SQL.

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

Learn the basic data structures of REDIS and examples of practical use of REDIS through redis-cli (command) practice.

Redis is a fast and scalable open-source database. This technology is used to maximize performance in real-time applications, games, social media platforms, and more. However, to truly understand the power of Redis and use it effectively, you need a deep understanding. Now is your chance to learn Redis in a professional way. "Redis with Silicon Valley Engineers" covers a wide range of topics, from the core concepts of Redis to advanced features. This course is designed for everyone, from beginners who are new to Redis to advanced users.

This course was created based on my personal experience passing the very first revised Information Processing Engineer practical exam, which had a pass rate of only 5.34%. The Information Processing Engineer practical exam can no longer be prepared for through simple memorization alone. In particular, the ability to read the execution flow of C, Java, Python, and SQL code to track results, as well as the ability to accurately distinguish short-answer concepts and write them as answers, has become crucial. This course is structured to help even beginners who are new to programming follow along step-by-step, covering everything from creating variable tables to tracking C, Java, Python, and SQL code, core practical terminology, and written exam subjects 1 through 5. Rather than being a video-centered course, this is a text-based course designed for fast reading and repeated review. It makes it easy to look up necessary parts again and focuses on practicing how to derive answers at the testing center by following the code and explanations directly. The 1st update covers the practical programming sections: C, Java, Python, and SQL. The 2nd update will organize core terms and concepts required for the short-answer practical questions and provide a "Stepper Simulator" to practice code tracking directly. The 3rd update will sequentially expand to cover written exam subjects 1 through 5. The Stepper Simulator is designed so that you don't just stop at reading explanations; you can understand how variable values change as the code executes line by line by following along yourself. If you have any questions while taking the course, please leave them in the Q&A. I will respond as quickly as possible to ensure your learning doesn't get stuck.

A must-have subject for aspiring developers and those looking to get a job in big data!!

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.

Systematically learn the distributed NoSQL database Cassandra, from basic concepts to practical application. Develop high-volume data processing capabilities through practice-oriented theory and hands-on exercises, including data modeling, query optimization, and cluster configuration. Even without prior database experience, you can grow into a Cassandra expert based on the know-how of a current Silicon Valley developer.

Introduction to SQL Data Analysis! Quick and easy to understand with practical problem solving!

★PYTHON★ This is a basic lecture on server development using Fast API. Learn how to develop servers easily, quickly, and conveniently using various packages such as Fast API, SQLAlchemy, Pydantic, and Starlette! Don't worry, we have prepared a DB backup file as well as integration with PostgreSQL! We will teach you the "basics" of UI design using Dash and Plotly and provide the source code used in the lecture :)

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

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

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

This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

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

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 🚀

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

This course prepares you for the Information Processing Engineer practical exam by focusing exclusively on solving past exam questions. Instead of covering unnecessary theory or vast amounts of material, it centers on questions that repeatedly appear on the actual exam, helping you work directly toward passing. Reflecting the latest exam trends, it helps you quickly identify key points and question patterns, while the solutions teach you how to write effective answers. It’s designed for candidates aiming to pass efficiently in a short time.

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!