All-in-One SQLD Subjects 1 & 2 Course Taught by a DBA with 30 Years of Experience: A Beginner-Friendly Path to Passing

Doing it carelessly is worse than not doing it at all. You'll just waste time! From now on, let's solve it thoroughly and perfectly together!

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

This course is structured to provide systematic learning, from basic database concepts to practical SQL applications, based on the Oracle Database 11g environment. Through step-by-step hands-on practice, you will master core content essential for database practice, including SELECT statements for data retrieval, DML for data manipulation, DDL for data definition, and user privilege management. Furthermore, this course goes beyond simple video lectures by providing an LLM-based AI Tutor, designed to allow learners to study by asking questions and receiving answers on their own. By utilizing the AI Tutor, the following types of learning are possible: - SQL syntax explanations and example generation - Analysis and correction of SQL error causes - Automatic generation of practice problems - Q&A on database concepts - Customized review based on learning progress - Generation of expected questions for certifications and job interviews Therefore, this course is suitable not only for beginners new to databases but also for professionals and job seekers looking to strengthen their practical SQL skills.

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.

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

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 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.

"SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!

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

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

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!

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.

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.

This course is designed to prepare you for the Information Processing Engineer practical exam solely through solving previous exam questions. Instead of unnecessary theories or vast amounts of content, it focuses on past exam questions that are repeatedly featured, allowing you to connect your learning directly to passing the exam. You can quickly grasp core points and question patterns by reflecting on the latest trends, and even learn tips for writing answers through the problem-solving process. This lecture is optimized for examinees aiming to pass efficiently in a short period of time.

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 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.

★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 :)

Do you want to generate significant profits even in a bear market? Are you interested in automated trading but haven't been able to start because of coding, trading strategy design, exchange APIs, or server deployment? In this course, we guide even those new to Python to turn trading ideas into concrete strategies using ChatGPT and Codex, and implement them into backtesting and live automated trading code. We will practice Binance Futures automated trading using Python and CCXT, technical indicator strategies, DCA (dollar-cost averaging) backtesting, and Upbit API-based Kimchi Premium strategies. Afterward, we will apply Telegram notifications and order safety features, manage the completed bot with GitHub, and deploy it to a cloud server. Rather than leaving all investment decisions to the LLM, humans will determine the strategies and risk management criteria, while using the LLM as an assistant to help with strategy design, coding, and troubleshooting. After completing the course, you won't just be running the provided code—you will be able to create, verify, modify, and deploy your own unique strategies!

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.