Senior Data Analyst's SQL Coding Test Know-how Revealed [Monthly Datalian Seminar Replay | December 2023]

Step-by-step explanations that even beginners can easily understand make coding tests that once seemed daunting clear and approachable. Learn only what you need and apply it to real problems right away!

LeetCode explained by Dalle, a Korean developer working at a Silicon Valley startup! This is a practical LeetCode problem-solving course that doesn't just provide answer codes, but compares multiple approaches for each problem, analyzes time and space complexity together, and explains why certain solutions are more efficient. First, we write the most intuitive approach and analyze its time/space complexity to identify bottlenecks and improvement points. Then, we explore alternative approaches applying various data structures and algorithmic techniques, comparing the performance differences and pros and cons of each method. Through this, it helps you develop problem-solving skills to design efficient solution strategies on your own when facing new problems.

Kakao Cote 6-week pass study method nerd scientifically selected algorithm/data structure extract

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!

This is a hands-on career and college admission project course where high school students use the AI-SPARS system to analyze their academic records, mock exam scores, and student record activities to explore their desired majors and universities. Students will compare various admission types, such as early and regular admissions, and personally design grade-specific roadmaps and execution strategies to reach their target universities. It is a practical course where high school students utilize AI-SPARS to analyze their grades and student record information while exploring desired majors, universities, departments, and college admission tracks. Participants will directly install and use the AI-SPARS program to create their own college admission profile and complete a strategic admission plan and roadmap to reach their target universities.

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

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.

Let's perfectly prepare for the second coding test (implementation test) by solving 10 problems created with reference to front-end coding tests given by actual companies!

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

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.

Solve 25 SQL problems of varying difficulty levels. This is a commentary lecture for Advent of SQL 2025, and upon completing the course, you can finish the advent calendar and earn a badge.

This is a career guide course that covers the entire process of landing a developer job or switching careers, including resumes, portfolios, technical interviews, and behavioral interviews. The theory section outlines the process of finding the right company for you, analyzing job postings, and preparing for interviews and coding tests.

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.

Practical English Guide for Software Engineering | Great IT English

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

This is a partial lecture from the theory section of a comprehensive career guide course that covers everything you need to prepare for developer job hunting and career transitions, including resumes, portfolios, technical interviews, and personality interviews. The theory section covers the process of finding companies that fit you, analyzing job postings, preparing for interviews and coding tests, and everything you need to know to prepare your resume and portfolio.

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!

I have summarized the steps required to get a job as a front-end developer into 7 codes. I didn't have a senior developer, so I was vague when I was looking for a job, but don't worry anymore. 😀

This is a Python basics course for starters who want to grow as data analysts. - Those who want to do data analysis but don't know Python - Those who want to learn machine learning with Python - Those preparing for the Big Data Analytics Engineer practical exam - Those who want to develop machine learning-based applications with Python

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