Hands-on SQLD Practice (Subject 2)

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.

Learn SQL not through listing grammar like SELECT and WHERE, but by solving business questions like "What are recent sales?", "Who buys more?", and "What are the Top 5 products?". Practice hands-on in a free environment (BigQuery Sandbox + Looker Studio) and complete analysis results with dashboards. You can gain practical data analysis thinking along with SQL fundamentals without getting bored.

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!

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

It contains only the essentials required to obtain the SQLD certification. This is a learning process that will help you acquire the SQLD certification by solving various examples directly, starting from setting up the development environment and building your skills.

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.

It contains only the essentials required to obtain the SQLD certification. This is a learning process that will help you acquire the SQLD certification by solving various examples directly, starting from setting up the development environment and building your skills.

Have you ever felt frustrated with table design? This course is for those who have had concerns like, "Is this table right?", "Which column should be the PK?", "Is it okay to connect relationships this way?", or "Will I have to rebuild the table when adding new features?"

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

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!

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

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.

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

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!

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

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