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.
How to write SQL queries for multiple table searches
Understanding and utilizing over 50 different function features
How to write advanced SQL queries for efficient data analysis
Theory + Practice + Quiz all in one! Everything about SQL, step by step ✅
SQL, easy and fun even for beginners! 📙
Learn the basics of using SQL to query, aggregate, and change data, and discover useful features and various functions for data analysis.
1️⃣ You will learn SQL statement writing skills through systematic learning and practice on various topics such as the following.
Find the data you need
Writing basic SQL statements to retrieve data (retrieval of rows that meet specified columns and conditions)
Understanding NULL values and querying and handling NULL values
Understanding automatic type conversion and combining data between columns
Sort and query data
Processing data according to conditions using CASE statement and IF function
Aggregate, manipulate, and sort data to fit your conditions
Aggregate by group using GROUP BY statement
Manipulating data with INSERT, UPDATE, and DELETE statements
Deriving analysis results using various ranking functions
Enriching data with relational/virtualization (view) features
Retrieving data from multiple tables using joins and subqueries
Save the SQL statement you wrote as a view and use it in various ways
Deepen data analysis using functions and advanced features
Learn over 50 string-related, date-time-related, and number-related functions.
Learn advanced features that facilitate practical analysis
2️⃣ We will learn while comparing the differences between the following three DBMS.
MySQL, Microsoft SQL Server (MS-SQL), Oracle
Repeat in 3 steps 👍 Learning SQL step by step
Repeat! Repeat! Repeat! For repeat learning, the whole process is carried out in three steps as follows.
1️⃣ Theory class
You will first learn the overall content through a textbook that systematically organizes only the essential content. You will learn the content you will write later through examples of SQL statements.
2️⃣ Practice Example
By executing actual SQL statements, you can review what you learned in theory classes and understand it more deeply. Learn by comparing the differences between MySQL, MS-SQL, and ORACLE syntax.
3️⃣ Quiz solution
Learning SQL statements is all about repetitive learning. You can review and organize what you have learned by solving additional practice problems in a fun way, like taking a quiz.
🧭 Over 20 years of teaching, practical, and consulting experience
We provide easy and fun lectures based on the know-how we have accumulated through many years of training centers and corporate on-site lectures.
It provides the best learning opportunity for those who are new to SQL statements.
We focus on SQL statements that are required in the field and have been confirmed during consulting for various companies.
It is based on MySQL, but it proceeds while comparing the differences with MS SQL and ORACLE.
Who created this course 👨🦰
Book
Writing of 『SQL Server Development Edition: A Special World Enjoyed with DB』, Ruby Paper
Writing of 『SQL Server Operations: A Special World Enjoyed with DB』, Ruby Paper
Written by 『SQL Server 2012 Operation and Development with Lee Jang-rae』, IT Forum
Author of SQL Server Security Guide for Protecting Personal Information, Microsoft
Teaching and teaching experience
Job training for SKT technical new recruits (JT)
KT Aible School 1st to 3rd Data Expert Training Course
GS EPS Data Analysis Advanced Course
SetrackEye Database Administrator Course
CJ Daehan Transportation SQL Server Monitoring and Optimization Process
SK C&C Data Preprocessing, Analysis Practice, Machine Learning Course
Daegu Bank Data Expert Training Course
KT Future Talent Development Project Data Preprocessing, Machine Learning Course
National Tax Service (Seoul, Daegu) SQL Course for Forensic Investigation
SK Networks DA (Data Architect) Training Course
SQL Course for Hyosung TNS Developers
Hanla Group Python Data Analysis Visualization Course
POSCO E&C Data Analysis Visualization Process
POSCO ICT Data Analysis Process
SK Networks Data Expert Training Course
CJ Olive Networks new employee training course, etc.
Q&A🔍
Q. Is this a lecture that non-majors can also take?
Yes, it is possible. We will proceed step by step while systematically learning the theory and practicing so that even those who are new to SQL can easily understand it. Take on the challenge with confidence~
Q. What DBMS is the lecture based on?
Based on ANSI SQL, you will learn SQL statements that can be used in all products such as MySQL, MS SQL, and ORACLE. Since a practical environment is required, we will use MySQL Workbench, which is the easiest to access. We will explain the differences from MS SQL or ORACLE while writing and executing SQL statements in the MySQL environment. In the case of functions, we will explain while comparing the functions used in MySQL, MS-SQL, and ORACLE. Therefore, it does not matter which DBMS you use.
Q. Is there anything I need to prepare before attending the lecture?
First of all, you must prepare your mind to study hard and enjoyably. Since sufficient explanations are given, you can listen without practicing, but if you listen to the lecture while practicing, you must install MySQL including Workbench. Download the practice materials, watch the preparation process video, and restore the learning database to be perfectly prepared for the class.
Recommended for these people
Who is this course right for?
For those who are learning SQL for the first time
For those who already know SQL but want to organize their knowledge systematically.
For those interested in obtaining the SQLD certification
It's been about 2 hours now? I've listened to the lecture, and it's easy to listen to because it progresses step by step from the basics. There's no break in the flow while listening to the lecture, and I don't know if the code entry part is fast or if it's done at the speed, but it's done in an instant, so it's easy to continue the flow. There are simple quizzes in between, so you can write SQL yourself and use what you just learned, or there are quizzes that require you to learn later, and thanks to this, you can learn why you need to learn later, which is good.
The weighting was appropriate for the level of importance, and the clear examples made it easy to understand. I was able to finish the course in two days. Thank you!