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

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

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

(5.0) 3 reviews

70 learners

topdatastudio

SQL

MSSQL

What you will learn!

Subquery
Window function (analysis function)
View
SQL procedure statement
User defined procedures
User defined functions
trigger

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

📣 Please check before taking the class!

The new 49-part SQL Mastery series consists of two lectures , covering approximately 49 SQL topics. (Basic/Advanced) This course is an advanced course and does not cover SQL fundamentals.

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:
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

206

Learners

Reviews

Answers

4.8

Rating

Courses

학력)

- 컴퓨터공학박사

연구)

-개인화 추천시스템을 위한 모델에 관한 연구

-키워드 기반 추천시스템 데이터 셋 구축 및 분석

-능동적 원본 도메일 선택을 이용한 교체 도메인 추천에 관한 연구

-협업필터링의 희박 행렬 문제를 위한 이행적 유사도 평가

-퍼지 질의 처리를 위한 시스템 구현

-Adaptive Cross-Domain Recommendation Model based on Association Analysis , etc.

실무 경력)

-㈜한국 BMG뮤직/MIS팀

-㈜딜로이트경영컨설팅/시스템사업부

-㈜Ernst & Young Management Consulting/솔루션팀

주요 업무 및 수행 프로젝트)

PM, 데이터베이스 설계, 구축 및 시스템 개발, 패키지 운영, 데이터분석 및 시각화

-SOLOMON PACKAGE 운영 관리(G/L, A/P, A/R, INVENTORY, P/O, ESI)

-SAMIS(Sales and Marketing Information System) 개발 및 관리

-한국 BMG뮤직 고객관리시스템, 저작권심의관리시스템 개발 및 운영

-안건 회계법인 인사급여, 고정자산 시스템 개발

-㈜대덕전자 인사급여, 복지기금, 우리사주시스템 개발

-㈜미원 VOC(Voice Of Customer) 시스템 ISP

-국내C기업 인사관리 시각화 분석 프로젝트 외 다수 프로젝트 진행

강의 분야)

-데이터베이스 및 데이터 분석 분야: 데이터베이스, 데이터베이스 설계 및 구축, 데이터베이스 실습(SQL-Server, ORACLE, MySQL), 파이썬과 R을 활용한 데이터 분석, 엑셀을 활용한 데이터 분석 및 시각화

-데이터 시각화 분야 : POWER BI

-프로그래밍 언어 분야: 파이썬, 비주얼베이직 닷넷, 자바스크립트, VueJS, C#, 웹프로그래밍실습, 모바일프로그래밍, 자바 등

저서)

-난생처음 MySQL (한빛아카데미, 2024-01-17)

난생처음 mysql.jpg

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:

Last updated:

Reviews

All

3 reviews

5.0

3 reviews

cdjcys35
Reviews 18
∙
Average Rating 4.7
5
100% enrolled
Very useful
hmkang7158
Reviews 1
∙
Average Rating 5.0
5
33% enrolled
rtscts6458
Reviews 1
∙
Average Rating 5.0
5
100% enrolled

$68.20

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

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

입문

SQL, MSSQL

Complete Mastery of Practical SQL in 49 Sessions I - Basic 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 I - Basic Course (Including Practice Materials and Problem Solving)

topdatastudio

입문

SQL, MSSQL

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

topdatastudio

From Introduction to Utilization of MSSQL Server 2016-based Database Part 2

usefulit

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

초급

SQL, MSSQL, DBMS/RDBMS

From Introduction to Utilization of MSSQL Server 2016-based Database Part 2

usefulit

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

rookiss

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

초급

SQL, DBMS/RDBMS

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

rookiss

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

중급이상

bigquery, SQL, Firebase

BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

kyleschool

[A hundred words are not as good as seeing once] Intermediate SQL for data analysis

datarian

Datalian's intermediate SQL lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn intermediate SQL theory and solve practice problems together.

초급

SQL

[A hundred words are not as good as seeing once] Intermediate SQL for data analysis

datarian

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

초급

SQL, PostgreSQL, DBMS/RDBMS

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

High-Performance SQL for JPA (ORM) Developers

vladmihalcea

Make the most of relational database systems!

중급이상

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

vladmihalcea

C# WinForms_ Application Development

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

입문

C#, MSSQL, winform

C# WinForms_ Application Development

vmproductor0202

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.

중급이상

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

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

jhong

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.

입문

Java, SQL, MySQL

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

jhong

WPF (C#, subtitles provided)

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.

초급

C#, wpf, MVVM

WPF (C#, subtitles provided)

vmproductor0202

Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

youngcodikimssam

From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

입문

Java, JSP, Spring

Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

youngcodikimssam

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

masocampus

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

입문

SQL, SQLD

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

masocampus

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

What you will learn!

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: Subquery

Section 1: Window functions (analytic function)

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

Q&A 💬

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

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:
Subquery

Section 1:
Window functions
(analytic function)

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

Recommended for
these people

Hello
This is