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

'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.

Beginner

SQL, MSSQL

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

topdatastudio

$68.20

Beginner / SQL, MSSQL

4.8

(12)

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

topdatastudio

$68.20

Basic / SQL, MSSQL

4.8

(5)

Basic

SQL, MSSQL

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

topdatastudio

$68.20

Basic / SQL, MSSQL

4.8

(5)

In each section
You will learn these things :

Section 0:
Subquery

Subquery definition and usage
Types of subqueries
Single-row subquery using comparison operators
Multi-row subqueries using IN/NOT IN
Multi-row subqueries using ANY, SOME, or ALL
Multi-row subqueries using EXISTS/NOT EXISTS
Correlated subqueries
Multiple nested subqueries
Subqueries used in SELECT and HAVING clauses
Inline views used in the FROM clause

Section 1:
Window functions
(analytic function)

Definition and purpose of window functions
Differences from existing aggregate functions
Understanding the OVER clause and types of window functions
Ranking functions - RANK, DENSE_RANK, ROW_NUMBER
Proportion functions - PERFECT_RANK(), CUME_DIST(), NTILE()
Row order functions and distribution functions - FIRST_VALUE(), LAST_VALUE(), LAG(), LEAD(), PERCENTILE_CONT(), PERCENTILE_DISC()
Range specification options when using window functions - ROWS, RANGE, BETWEEN ~ AND, UNBOUNDED PRECEDING, UNBOUNDED FOLLOWING, [ROW number] PRECEDING, [ROW number] FOLLOWING, CURRENT ROW

Section 2:
View, Procedural
programming grammar,
User defined procedures,
User defined functions,
trigger

Overview of views, features, purpose of use, grammar, and options used in views
System stored procedures
Learning the basic syntax of procedural programming - IF conditional statements, WHILE loops, BREAK, and CONTINUE
User-defined procedures - procedures with/without parameters, procedures with output parameters or return values, procedures with initialization values
How to write DML operation procedures and use table variables
User-defined functions - user-defined scalar functions and inline table-valued functions, multi-statement table-valued functions
Triggers - What is a trigger, what it's used for, how to create one, AFTER triggers and INSTEAD OF triggers

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 courses. The advanced course consists of three sections . This course will help you develop your SQL application and utilization 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?

SQL Basic Grammar: Complete Mastery of Practical SQL in 49 Lessons I - Anyone who has taken the basic course or has basic knowledge of SQL can learn this.

Hello
This is topdatastudio

212

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

18 lectures ∙ (8hr 46min)

Course Materials:

Lecture resources

Section 1. Subquery

6 lectures ∙ (2hr 31min)

1. Subquery Overview, Subquery Using Single Comparison Operator and IN - I
10:55
2. Subquery Overview, Single Comparison Operator and Subquery Using IN - II
16:22
3. Subqueries using ANY, SOME, ALL, EXISTS
25:15
4. Correlated subqueries and multiple nested subqueries
27:55
5. Subqueries in SELECT and HAVING clauses
39:17
6. Subqueries in the FROM clause - Inline view
31:16

Section 2. Window function (analysis function)

6 lectures ∙ (2hr 59min)

7. Definition of window functions, differences from existing aggregate functions, understanding the OVER clause, types of window functions
07:07
8. Using Ranking Functions - RANK(), DENSE_RANK(), ROW_NUMBER()
21:23
9. Using ratio functions - PERCENT_RANK(), CUME_DIST(), NTILE()
25:20
10. Using aggregate functions as window functions - COUNT(), AVG(), SUM(), MAX(), MIN()
39:37
11. Row order functions and distribution functions FIRST_VALUE(), LAST_VALUE(), LAG(), LEAD(), PERCENTILE_CONT/DISC()
44:45
12. Using the Scope Option When Using Windows Functions
41:21

Section 3. Views, user-defined procedures and functions, and triggers

6 lectures ∙ (3hr 15min)

13. Overview of views, features, purpose of use, grammar, options used in views - theory
10:07
14. Overview of views, features, purpose of use, grammar, options used in views - Practice
18:11
15. System stored procedures, user-defined procedures (procedures with/without parameters, procedures with output parameters or return values, procedures with initialization values)
50:48
16. How to write IF conditional statements, WHILE loops, BREAK and CONTINUE statements, DML operation procedures, and how to use table variables
43:07
17. User-defined scalar functions, inline table-valued functions, multi-statement table-valued functions
39:42
18. User-defined scalar functions, inline table-valued functions, multi-statement table-valued functions
33:32

Published: 07/07/2022

Last updated: 07/08/2022

Reviews

All

5 reviews

4.8

5 reviews

cdjcys35
Reviews 18
∙
Average Rating 4.7
12/19/2022
5
100% enrolled
Very useful
husky16
Reviews 18
∙
Average Rating 4.8
01/10/2026
4
33% enrolled
torch72788
Reviews 11
∙
Average Rating 5.0
01/08/2026
5
33% enrolled
I think it's great that you can see various query techniques
rtscts6458
Reviews 1
∙
Average Rating 5.0
06/22/2024
5
100% enrolled
hmkang7158
Reviews 1
∙
Average Rating 5.0
09/27/2024
5
33% enrolled

topdatastudio's other courses

Check out other courses by the instructor!

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

topdatastudio

$68.20

Beginner / SQL, MSSQL

4.8

(12)

Beginner

SQL, MSSQL

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

topdatastudio

$68.20

Beginner / SQL, MSSQL

4.8

(12)

Similar courses

Explore other courses in the same field!

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

topdatastudio

$68.20

Beginner / SQL, MSSQL

4.8

(12)

Beginner

SQL, MSSQL

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

topdatastudio

$68.20

Beginner / SQL, MSSQL

4.8

(12)

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

itpaul

$77.00

Basic / PL/SQL, SQL, Oracle

4.9

(25)

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

$77.00

Basic / PL/SQL, SQL, Oracle

4.9

(25)

GCP BigQuery Tutorial for Beginners

Sungmin Kim

$35.20

Beginner / SQL, Google Cloud Platform, bigquery, sql-query, database

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

Beginner

SQL, Google Cloud Platform, bigquery

GCP BigQuery Tutorial for Beginners

Sungmin Kim

$35.20

Beginner / SQL, Google Cloud Platform, bigquery, sql-query, database

[Practice Makes Perfect] Intermediate SQL for Data Analysis

datarian

$29.70

Basic / SQL

4.9

(959)

5,400+

Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

Basic

SQL

[Practice Makes Perfect] Intermediate SQL for Data Analysis

datarian

$29.70

Basic / SQL

4.9

(959)

5,400+

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

WHIZ

$26.40

Basic / SQL, sql-query, bigquery, Data literacy

5.0

(4)

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

$26.40

Basic / SQL, sql-query, bigquery, Data literacy

5.0

(4)

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

Rookiss

$34.10

Basic / SQL, DBMS/RDBMS

5.0

(132)

3,900+

This course teaches MS-SQL through baseball/company databases.

Basic

SQL, DBMS/RDBMS

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

Rookiss

$34.10

Basic / SQL, DBMS/RDBMS

5.0

(132)

3,900+

SQL data analysis learned through various cases

dooleyz3525

$68.20

Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

4.9

(49)

1,500+

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

$68.20

Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

4.9

(49)

1,500+

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

vmproductor0202

$51.70

Basic / C#, .NET, MSSQL, MVVM, wpf

4.3

(42)

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

$51.70

Basic / C#, .NET, MSSQL, MVVM, wpf

4.3

(42)

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

$176.00

Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

4.9

(31)

Make the most of relational database systems!

Intermediate

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

$176.00

Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

4.9

(31)

C# WinForms Application Development (.NET Framework)

vmproductor0202

$51.70

Beginner / C#, MSSQL, ADO.NET, debugging, winform

4.1

(58)

500+

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

$51.70

Beginner / C#, MSSQL, ADO.NET, debugging, winform

4.1

(58)

500+

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

$69.30

Beginner / SQL, SQLD

4.4

(18)

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

Beginner

SQL, SQLD

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

$69.30

Beginner / SQL, SQLD

4.4

(18)

FastAPI Complete Guide

dooleyz3525

$59.40

Intermediate / Python, FastAPI, SQL, SQLAlchemy

4.9

(62)

800+

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

$59.40

Intermediate / Python, FastAPI, SQL, SQLAlchemy

4.9

(62)

800+

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

Hong

$50.60

21%

$39.60

Beginner / Java, SQL, MySQL, MongoDB, database

4.1

(13)

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

$50.60

21%

$39.60

Beginner / Java, SQL, MySQL, MongoDB, database

4.1

(13)

DBT with a Silicon Valley Engineer

altoformula

$34.10

Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

5.0

(9)

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

$34.10

Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

5.0

(9)