Complete Mastery of Practical SQL in 49 Sessions I - Basic Course (Including Practice Materials and Problem Solving)

Name: Complete Mastery of Practical SQL in 49 Sessions I - Basic Course (Including Practice Materials and Problem Solving)
Price: 88000 KRW
Rating: 4.8 (13 reviews)

'Complete Mastery of Practical SQL in 49 Sessions I - Basic Course' contains essential content that you must know for SQL. By learning using a practical database, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems. For intuitive understanding, practice is conducted using a database written in Korean.

(4.8) 13 reviews

145 learners

Level Beginner

Course period 12 months

topdatastudio

SQL

MSSQL

SQL

MSSQL

Reviews from Early Learners

4.8

5.0

이유환

100% enrolled

I enjoyed the great lecture.

5.0

blue_42

100% enrolled

I think it's a useful lecture!

5.0

shpark1124

97% enrolled

It seems to be well explained and easy to understand.

What you will gain after the course

Installing SQL Server
Create DB with external dataset
SQL Basic Grammar
SQL single row functions (string functions, numeric functions, date functions, etc.)
Aggregate function
signature
Data manipulation language, data definition language

SQL, from beginner to expert!
Fundamentals + Application + Problem Solving all at once.

📣 Please check before taking the class!

The new SQL Mastery Series, available in just 49 lessons, consists of two lectures (Basic and Advanced). This course is a basic course. It covers approximately 49 SQL topics across two lectures.

Attention, these people !

Starting from the basics
I want to learn SQL thoroughly.

It is difficult to understand with just general textbooks
I want to learn intermediate to advanced skills easily.

SQLD, SQLP, data analysis expert, etc.
I would like help in obtaining a certificate .

SQL in the field of data handling
I want to develop capabilities that I can utilize .

For learning SQL
Transfer of optimal know-how.

✅ If you are working on data-related tasks or want to use SQL in your work,
✅ If you want to start from the beginner level of data and advance to the advanced level,
✅ If you want to use SQL freely as a developer ,
✅ If you are preparing for a data-related certification (SQLD, SQLP, Data Analysis Specialist, etc.)
✅ If you are interested in data science

The "From Beginner to Expert in 49 Sessions! Master Practical SQL" course covers the essential fundamentals of SQL and provides hands-on practice with databases based on real-world applications . Solving practical practice problems not found in any textbook will help you rapidly improve your skills, and the goal is to immediately apply SQL in real-world situations.

We've compiled the best know-how we've accumulated over many years of practical experience and training at universities, companies, and educational institutions. Starting with the basics, anyone can learn, we'll help you build a solid foundation in SQL!

SQL Basics You Must Know
We handle it carefully.

_{The structure of the entire learning process is as follows:}

_{The class uses a practice-based database and consists of theory and practice problem solving.}

Fully packed with 3-step structure

The course progresses through three stages: theoretical explanation, practical training, and application problem solving. After completing the entire course, you'll be able to write SQL fluently, and you can also choose to study selectively based on your efficiency.

I think about how to utilize it

This course not only prepares you for data qualifications using SQL, but also helps you develop your ability to utilize public data. Furthermore, it focuses on writing intermediate to advanced SQL statements necessary for program development.

Vivid hands-on experience with a practical DB

We use external data used in the field to enable practical training in an environment similar to actual work. Specifically, we've structured the program with Korean table and column names for intuitive understanding.

Solutions to over 200 application problems

By solving over 200 application problems of various difficulty levels and types, ranging from beginner to intermediate to advanced, you will develop the ability to solve problems using SQL according to the situation.

Complete Mastery of Practical SQL in 49 Sessions

In each section
You will learn these things :

Section 0:
SQL basic grammar

SQL Overview, Installing SQL-Server Express 2019
Install SSMS (SQL-Server Management System)
Importing data from outside Excel
Introduction to the Korean Language Database Dataset
SQL basic query syntax, conditional clauses, and operators
Sort data and remove duplicates

Section 1:
single row functions

Single-row functions used in SQL Server: string functions, numeric functions, date functions, and system functions.
String replacement functions: TRANSLATE, REPLACE, STUFF comparison
String concatenation/dividing functions: STRING_SPLIT, STRING_AGG
Conditional processing functions: IIF, CHOOSE, Conditional processing statements: CASE...END
NULL replacement functions: ISNULL, COALESCE comparison

Section 2:
Aggregate functions

Grammar using aggregate functions and types of aggregate functions
How to count the number of records with duplicates removed
How to summarize by grouping and aggregating by specifying conditions
Comparison of WHERE and HAVING clauses
How to calculate subtotals and grand totals at once using ROLLUP, CUBE, and GROUPING SETS
How to distinguish NULL using GROUPING and replace NULL resulting from GROUPING with a string
PIVOT and UNPIVOT clauses #2 that change rows to columns and columns to rows.

Section 3:
signature

Definition and principles of joins, comparison of ANSI-SQL joins and T-SQL joins
Understanding the structure of the North Wind database used in practice
Cross join, equi join, non-equi join, self join, outer join
Common Table Expressions (CTEs) - Non-recursive and Recursive CTEs
How to write hierarchical queries using recursive CTEs

Section 4:
data manipulation language,
Data Definition Language

DML (INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER, DROP) syntax
How to create, alter, and delete a database
Basic table creation syntax
How to create auto-value and auto-calculated columns, IDENTITY property, uniqueidentifier data type
How to create a table using an existing table
Constraints - PRIMARY KEY, NOT NULL, UNIQUE, CHECK, FOREIGN KEY, DEFAULT
FOREIGN KEY Attributes - ON DELETE, UPDATE CASCADE, SET NULL, SET DEFAULT, NO ACTION Comparison
Comparing Column-Level and Table-Level Constraint Settings
How to add/change/delete columns, add/delete constraints, and delete tables
Setting Constraints on the North Wind Database and Creating an ERD in SSMS

Q&A 💬

Q. Why should I learn SQL?

They say data is the oil of the 21st century. It's virtually impossible to find an industry that doesn't utilize data. Therefore, data-handling skills are essential these days, and SQL is considered one of the most common means of accessing data. Furthermore, cloud-based machine learning services are increasingly utilizing SQL. Furthermore, SQL skills are increasingly required for IT recruitment.

Q. Can non-IT majors learn it too?

Of course. Data itself isn't limited to IT majors. Data handling skills are essential for a wide range of talents across all industries, regardless of their major.

Q. What are the main features of the class?

This course aims to teach skills that can be immediately applied in the workplace. Therefore, we use a database similar to those used in the field as our practice database. Furthermore, to enhance students' intuitive understanding, we use Korean for table and column names. Solving approximately 200 application problems on your own and working together to solve them will also be of great help.

Q. Who uses SQL and where?

It will primarily be used by IT developers. It's also essential for those who specialize in data analysis, visualization, and other data-intensive tasks. Anyone who handles any type of data in the workplace will find a solid understanding of SQL very helpful.

Q. What is the level of the class?

The entire course consists of eight sections, including both basic and advanced sections. Section 0 is the introductory course . As the course progresses, it gradually covers intermediate and advanced skills .

Q. Is it very different from ORACLE or MySQL?

Standard SQL is the same. Depending on the DBMS, some features, such as functions, may differ. Therefore, even if you learn with MS-SQL, Microsoft's DBMS with its excellent accessibility and online help, you'll have no trouble using SQL in ORACLE, MySQL, or other relational databases.

Recommended for
these people

Who is this course right for?

People who want to apply and apply SQL directly to their field of work
People who want to analyze or utilize data in the field
IT Developer
People preparing for data-related certifications such as SQLD, SQLP, and data analysis specialist
People interested in data science

Need to know before starting?

Section 0 is an introductory course and requires no prior knowledge.

Hello
This is topdatastudio

218

Learners

Reviews

Answers

4.8

Rating

Courses

Lecture Fields)

- Database and Data Analysis: Databases, Database Design and Construction, Database Practice (SQL-Server, ORACLE, MySQL), Data Analysis using Python and R, Data Analysis and Visualization using Excel

-Data Visualization Field: POWER BI

- Programming Languages: Python, Visual Basic .NET, JavaScript, VueJS, C#, Web Programming Practice, Mobile Programming, Java, etc.

Books)

-MySQL for the Very First Time (Hanbit Academy, 2024-01-17)

- First Time MySQL (Hanbit Academy, 2024-01-17) - Author of Python, Visual Basic .NET, JavaScript, VueJS, C#, Web Programming Practice, Mobile Programming, Java, etc.

Curriculum

All

35 lectures ∙ (13hr 1min)

Course Materials:

Lecture resources

Section 1. SQL-Server Installation and Practice Environment Setup, External Data Loading, SELECT Statement Basic Syntax

7 lectures ∙ (1hr 43min)

Section 2. Single Row Function

7 lectures ∙ (2hr 46min)

8. String Functions I-1
15:52
9. String Function I-2
30:11
10. Number Functions
23:49
11. Date functions
33:33
12. String Functions II
24:11
13. Condition Handling Function
26:14
14. NULL handling function
12:39

Section 3. Aggregate function

6 lectures ∙ (2hr 44min)

15. Types and Basic Usage of Aggregate Functions
16:00
16. How to group into subgroups and aggregate using the GROUP BY clause
26:05
17. WHERE clause and HAVING clause
24:29
18. Method to show subtotals and grand totals at once - ROLLUP(), CUBE(), GROUPING()
32:57
19. How to change subtotal titles to strings, how to apply to only some columns, how to apply combined columns, and GROUPING SETS()
33:11
20. How to use the PIVOT and UNPIVOT clauses to view rows as columns and columns as rows
31:30

Section 4. Join

7 lectures ∙ (2hr 33min)

Section 5. Data Manipulation Language and Data Definition Language

8 lectures ∙ (3hr 12min)

Published: 07/07/2022

Last updated: 08/27/2023

Reviews

All

13 reviews

4.8

13 reviews

shpark11249052
Reviews 1
∙
Average Rating 5.0
01/19/2024
5
97% enrolled
It seems to be well explained and easy to understand.
blue421144
Reviews 5
∙
Average Rating 5.0
04/30/2024
5
100% enrolled
I think it's a useful lecture!
yongbumchung5235
Reviews 4
∙
Average Rating 5.0
06/21/2023
5
100% enrolled
It helps to learn step by step!!!
iamyhlee6710
Reviews 1
∙
Average Rating 5.0
09/04/2024
5
100% enrolled
I enjoyed the great lecture.
stone01151129
Reviews 8
∙
Average Rating 4.0
10/12/2022
5
91% enrolled
The lecture was friendly and good.

topdatastudio's other courses

Check out other courses by the instructor!

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

'Complete Mastery of Practical SQL in 49 Sessions II - Advanced Course' follows the basic course. By using a practical database for learning, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems.

Basic

SQL, MSSQL

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

Similar courses

Explore other courses in the same field!

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

Basic

SQL, MSSQL

Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

topdatastudio

Oracle PL/SQL Just This Much.. [Concept + Practice]

itpaul

This course provides developers/operators using Oracle with PL/SQL concepts and practical skills that can be immediately applied in the field.

Basic

PL/SQL, SQL, Oracle

Oracle PL/SQL Just This Much.. [Concept + Practice]

itpaul

Solid Foundation, SQL Overview (Introductory Course)

skmns

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

Beginner

SQL, DBMS/RDBMS, Data Engineering

Solid Foundation, SQL Overview (Introductory Course)

skmns

[SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

WHIZ

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

Basic

SQL, sql-query, bigquery

[SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

WHIZ

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

Beginner

Java, SQL, MySQL

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

C# WinForms Application Development (.NET Framework)

vmproductor0202

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.

Beginner

C#, MSSQL, ADO.NET

C# WinForms Application Development (.NET Framework)

vmproductor0202

Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

Masocampus

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

Beginner

SQL, SQLD

Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

Masocampus

WPF (.NET Core, C#, with subtitles)

vmproductor0202

This is a WPF lecture that will be helpful to developers who are considering introducing WPF in WinForms, application developers who are hoping to get a job in the US, and those who are hoping to get a job as a developer. It is not a lecture focused on theory and design, but covers content that can be used in practice.

Basic

C#, .NET, MSSQL

WPF (.NET Core, C#, with subtitles)

vmproductor0202

For those who haven't even started with SQL, come here

coddatg

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.

Beginner

SQL, bigquery

For those who haven't even started with SQL, come here

coddatg

FastAPI Complete Guide

dooleyz3525

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

Intermediate

Python, FastAPI, SQL

FastAPI Complete Guide

dooleyz3525

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Make the most of relational database systems!

Intermediate

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

[MMORPG Game Development Series with C# and Unity] Part 5: Database

Rookiss

This is a course for learning MS-SQL through baseball and corporate databases.

Basic

SQL, DBMS/RDBMS

[MMORPG Game Development Series with C# and Unity] Part 5: Database

Rookiss

SQL data analysis learned through various cases

dooleyz3525

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

Intermediate

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

DBT with a Silicon Valley Engineer

altoformula

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

Basic

SQL, Data Engineering, data-analysis

DBT with a Silicon Valley Engineer

altoformula

Complete Mastery of Practical SQL in 49 Sessions I - Basic Course (Including Practice Materials and Problem Solving)

4.8

What you will gain after the course

Attention, these people !

For learning SQL Transfer of optimal know-how.

SQL Basics You Must Know We handle it carefully.

Complete Mastery of Practical SQL in 49 Sessions

In each section You will learn these things :

Section 0: SQL basic grammar

Section 1: single row functions

Section 2: Aggregate functions

Section 3: signature

Section 4: data manipulation language, Data Definition Language

Q&A 💬

Recommended for these people

HelloThis is topdatastudio

Curriculum

Reviews

topdatastudio's other courses

Similar courses

For learning SQL
Transfer of optimal know-how.

SQL Basics You Must Know
We handle it carefully.

In each section
You will learn these things :

Section 0:
SQL basic grammar

Section 1:
single row functions

Section 2:
Aggregate functions

Section 3:
signature

Section 4:
data manipulation language,
Data Definition Language

Recommended for
these people

Hello
This is topdatastudio