SQL that you can use yourself - from basics to practical use

SQL, 200% usable in real-world work! 📊

SQL , why do you actually use it?
Will it feel difficult? 🤔

When extracting data using SQL, it's difficult to directly apply basic concepts to practical applications. Because the tables where data is stored and the relationships between them vary from project to project, simply extracting data using SELECT-FROM from a textbook isn't easy. Writing queries without understanding SQL concepts and analyzing the project doesn't guarantee the desired data.

Seeing these difficulties, I started this course to teach SQL properly and quickly with the essential content .

Ultimately, you need to understand the flow of data and the relationships between tables to extract the data you want using STEP BY STEP. Beyond the basic syntax of SELECT-FROM, this course covers the overall concepts needed to extract data based on various conditions. It also provides practical training through practical problems relevant to real-world use.

To these people
I recommend it ✅

Using SQL
Data extraction
Those who want to learn

I learned SQL, but
In practice, writing SQL
Anyone who had difficulties

The database
What is the structure?
Anyone curious

In a short time
Overall SQL capabilities
Someone you want to raise

After taking this course, you can do it too! 🙌

• You can extract the data you want using SQL.
• It creates an eye for reading data flow between tables (+ reading ERD).
• You will want to go to the developer in charge of the table and ask them how the primary key is set up.
• I'm thinking about how data is stacked in tables.
• Feel confident in your SQL extraction.

Key benefits of this course ✨

Clean communication + practical application + practice problems provided!

You will learn fundamental concepts so that you can apply them in practice.

It is structured so that even those who are new to SQL can learn step by step .

We have created practical situations and exercises that can be used in actual work .

The hands-on environment utilizes AWS and DBeaver tools (free of charge). (If you have trouble using AWS, please send me a DM during the lecture.)

Instead of installing a heavy database on your computer, use AWS. (The practical environment guide in the lecture)

It is structured step-by-step from the basics to practical use, so even those new to SQL can learn easily as if they were using real-world examples .

You can extract data by looking at an Enterprise Data Design (ERD) . This will help you adapt to the different database structures of each company and practice reading tables.

Learn how to fish so you can access and extract data directly in your practice, rather than just extracting data suitable for learning.

What you'll learn 📚

1️⃣ From basic essential concepts

• To use SQL, you shouldn't learn it from SELECT-FROM.
• Learn essential concepts such as tables, nulls, constraints, and relationships between tables .

_{null learning}

_{Learning about foreign keys}

2️⃣ Learn to use SQL

• After learning the fundamental concepts, you can start learning SQL.
• We will learn and practice step by step, starting with the basic SELECT-FROM statement, operators, type conversion, aggregate functions, group by, etc.
• Once you learn a concept, practice problems follow.
• The practice problem involves extracting data by looking at an actual ERD.

_{Among the ERD contents}

_{Among the operator practice contents}

3️⃣ Expanding SQL Usage

• Now that you've mastered how to use SQL to extract data, let's learn about joins and subqueries to expand on it.
• Additionally, let's take a look at the contents of the analysis function .

_{Join the learning content}

Who created this course
Introducing the Knowledge Sharer ✒️

Myeongjun

• Current Mozilla open source committer
• Former Fintech startup developer
• Former Global Professional Developer at the Ministry of Science and Technology
• Former) Hyosung Billing Development Team (Settlement DB Development)

Check out the vivid reviews of offline classes !

Q&A 💬