[Renewed] First-Time SQL and Database (MySQL) Bootcamp [From Beginner to Practical Applications]
Through this course, you will learn about SQL and databases, SQL syntax, database design for practical use, how to use databases through programming, and real-world applications of data analysis.
I attended without any SQL knowledge at all, but I was able to follow the class without any problems, which is great! Before taking the class, I thought it would be really difficult, but now I feel confident that I can complete the entire course!
5.0
화리둥절
81% enrolled
This is a very sufficient lecture to learn how to use basic SQL! If you want to do coding tests or solve more in-depth problems, I recommend moving on to the intermediate-advanced SQL lecture!
5.0
검냥이
100% enrolled
This is a lecture that I learned a lot from because you explained the definition systematically and fundamentally. After completing the course, I immediately applied for the Intermediate and Advanced SQL and Practical Data Analysis 101 Problem Solving [Data Analysis/Science Part1]. Thank you.
What you will gain after the course
Learn and practice SQL syntax through a variety of problems
Practical SQL Data Analysis Practice with a Real Database
Technology for automatically controlling MySQL with Python
A course where you can learn everything from database basics to practical applications in a short time is here! 📌
The course chosen for in-house training by Naver, Kakao, Line, Coupang, and Baemin! It’s back with its third major renewal 🥳
This special course was created based on eight years of experience teaching approximately 80,000 people both online and offline. We revamped it three times, incorporating well-organized materials, detailed explanations, and extensive feedback from previous versions to make it an even better course.
Databases, Do you really need to learn them? 🧐
Whether you're building web or app services or learning data analysis/data science, understanding databases is essential. This is because all data is stored and managed in databases. In particular, even non-developers have increasingly been analyzing data in databases themselves.
Although there are various types of databases, the basic databases used by most companies all operate with the SQL language. SQL includes a wide range of syntax, and the key is developing the ability to use that syntax to create the SQL statements you need.
Starting with what databases are, this course is designed to help you use SQL in practice by solving SQL problems with real business data and developing the ability to create the SQL statements you need. In addition, it explains how to use databases from both data analysis and development perspectives, helping you build a solid foundation in databases.
Course Objective 📌
Build a solid foundation in SQL and MySQL through various exercises in a short amount of time.
Learn how to control MySQL through programming to work with databases.
Learn data analysis skills using SQL.
You'll learn these things 📚
The best way to learn SQL is to organize SQL syntax, combine various syntaxes, and practice writing SQL statements extensively.
This course teaches database technologies using the MySQL database, one of the most widely used basic databases. Designed for beginners, it starts with database fundamentals, then covers complex SQL through a variety of practical problems, and also teaches practical SQL-based data analysis and Python-based database applications.
MySQL Database and SQL Basics
Practice with various database-based SQL statements that can be used in real-world work.
How to automatically manage a MySQL database using Python programming
📢 Please note before enrolling!
To learn how to automatically work with MySQL databases using Python programming, you need prior knowledge of Python and web scraping. If you don’t have the relevant knowledge, we recommend taking this course together with the one below.
add_shortcode('course','324082','list')
Course Features ✨
#1. Beginners are welcome!
This course is designed so that even beginners can take it, starting from the assumption that they have no knowledge of databases. It covers everything from the types of databases to the key SQL syntax essential for learning databases.
The practical SQL problems covered in this course were well received by beginners in our in-person classes, who were able to follow along and found them highly satisfying. Anyone can learn them with careful thought and repeated practice. However, IT courses are very different from simply using a finished product, so you need to study seriously to get the most out of them!
프로그램 설치부터 함께해요!
#2. Real Database-Based Practical, Job-Focused Course
This course provides lectures based on a variety of code and materials, organized by step and technology so that you can become familiar with database utilization techniques in a short time.
#3. Real-world DB-based Problems and solutions
We’ll help you get a feel for databases by practicing various SQL statements using real-world databases suitable for use in actual companies.
#4. Systematic Roadmap Provided
By taking the following courses after this one, you can build solid SQL skills.
add_shortcode('course','334916','list')
Additionally, for those considering a career in backend development or data analysis/science after this course, we have also made both a full-stack roadmap and a data science roadmap available so you can learn systematically. You can find the complete related roadmaps below on this course details page.
Learn systematically Dave Lee’s Fun Coding Roadmap 🔑
Career roadmap for developers, data analysts, and data scientists!
From web/app development to data analysis and AI, we provide an A-to-Z roadmap to help you build a solid foundation in a short time. IT technologies are closely interconnected, and integrating them is essential for creating web/app services and working in data science. By progressively increasing the difficulty and mastering core technologies, you can learn efficiently, understand systems and data as a whole, and grow into a competitive developer or data professional. To help you do this, we have prepared a roadmap that systematically organizes the core technologies in each field.
1. The Fastest Roadmap for the Entire Data Journey
We created a video that provides a detailed explanation of this roadmap, data-related careers, and the entire data analytics/science journey. By referring to this video, even on your own and in a short time, you can easily learn the data curriculum without trial and error!
Wait! ✋ Click the roadmap below to view more details. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount rate will soon be reduced.)
add_shortcode('roadmap','66','roadmap','1')
2. The Fastest Full-Stack Roadmap
We created a video that explains in detail how to learn and implement web/app development on your own as quickly as possible using this roadmap. If you refer to this video, you can implement web/apps in a short time without trial and error.
Wait! ✋ Click the roadmap below to learn more. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount rate will be reduced soon.)
add_shortcode('roadmap','49','roadmap','2')
3. Essential computer science (CS) knowledge for the fields of development and data
This roadmap is a course that systematically organizes the essential computer science (CS) knowledge, the core IT theory underlying the fields of development and data. Among these, we offer courses that systematically teach the most important core subjects, including computer architecture, operating systems, and networks.
add_shortcode('course','337332','list')
Recommended for these people
Who is this course right for?
Those who want to conquer databases
Those who want to learn the fundamentals of data science/full-stack development
Those who want to learn practical SQL skills.
Those who want to learn SQL from the basics through practical applications
Key Experience: Coupang Senior Development Manager/Principal Product Manager, Samsung Electronics Development Manager (Approx. 15 years of experience)
Education: BA in Japanese Language and Literature, Korea University / MS in Computer Science, Yonsei University (A complete mix)
Key Development Experience: Samsung Pay, E-commerce Search Service, RTOS Compiler, Linux Kernel Patch for NAS
Books: Linux Kernel Programming, Understanding and Developing the Linux Operating System, IT Core Technologies That Anyone Can Easily Read and Understand, Python Programming Primer for Absolute Beginners
Rather than boring theoretical content, it was very helpful that it explained in detail and step-by-step with many examples how to utilize and use it in practice!
- The lecture was boring because it covered the basic concepts.
- The lecture uses various programs, but the programs used in the previous lecture, current lecture, and next lecture are different from each other, so there is an inconvenience of having to open multiple programs at once.
- Python uses an Interpreter, but the lecture misunderstood that it uses a Compiler, which was confusing.
- The lecturer kept advertising Python lectures, which was confusing.
- When crawling the Gmarket best-seller page, the internal structure of best_item has changed, but the lecture video uses the old code, which did not match the initial statement that "continuous updates will be made", so it was unreliable.
- The misunderstanding that NaN and Null are the same was confusing.
Hello, this is Answer Helper. Soyun, this is a real site, so changes may occur frequently. I really wanted to give you a more realistic explanation with the real site. Also, we are updating the changed parts as quickly as possible with the data. Of course, the program must run mysql and the editor, but Python-based lectures only use Jupyter Notebook. We do not use different tools without special reasons. Most people know that Python is an Interpreter, so it seems difficult to understand this part. This lecture is for those who do not know MySQL, so it seems right to structure the lecture so that you can understand it from the beginning. However, if you do not know Python, the latter part may be difficult, so we have provided separate guidance for Python lectures for those who do not know Python. I think we should not make SQL lectures assuming that you know SQL to some extent like Soyun. Many people have already taken this lecture, so if there are any issues, the feedback may not have been good, so if there are any actual issues, please let me know and I will update it right away. This lecture is a continuation of the main lecture and the more complex machine learning deep learning lecture, so if the difficulty is adjusted step by step and the basic techniques are explained incorrectly, it would have been an issue since several years ago. If you have any difficulties, we will do our best to help you, so please do not misunderstand it too much.
It was generally good, but I was disappointed that it only covered easy content. I wish it had been a lecture that systematically covered normalization, denormalization, and design, even if it raised the price. There was nothing worth learning about normalization, denormalization, and design. But other than that, it was helpful.