Obtaining SQL Developer (SQLD) Certification (2024 Revision) Part.3 Bottom

This course is designed to systematically teach advanced SQL features, specifically GROUPING functions and Window functions, to prepare for the SQLD exam and enhance practical data analysis skills. You will learn the concepts and applications of GROUPING functions and master methods for analyzing data at various aggregation levels. Understand the basic concepts and types of **Window functions (based on the OVER keyword)** and improve your practical skills through hands-on exercises. Learn **Ranking functions (RANK, DENSE_RANK, ROW_NUMBER, etc.)** and window options for aggregate functions through practical business examples. Cover **Row order functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE, etc.)** and practice time-series and sequence-based analysis firsthand. 👉 Through this course, learners can expand their data aggregation and analysis skills to an advanced level, gaining expertise that is immediately applicable not only to the SQLD exam but also to real-world corporate data analysis environments.

3 learners are taking this course

Level Beginner

Course period 12 months

SQL
SQL
MySQL
MySQL
SQLD
SQLD
SQL
SQL
MySQL
MySQL
SQLD
SQLD
날개 달린 동전

Course 추천하고 성장과 수익을 만들어 보세요!

날개 달린 동전

Marketing Partners

Course 추천하고 성장과 수익을 만들어 보세요!

What you will gain after the course

  • Understand the concepts and types of the GROUPING function and window functions, as well as the OVER keyword, and practice them firsthand.

  • Understand the options for using ranking functions, aggregate functions, and window functions, and practice them firsthand.

Write a catchy and concise title.

This course is designed to prepare for the SQLD exam and improve practical data analysis skills,

This course provides a systematic approach to learning advanced SQL features, including GROUPING functions and window functions.

Learn the concepts and usage of GROUPING functions, and master how to analyze data at various aggregation levels.

Understand the basic concepts and types of window functions (based on the OVER keyword) and enhance practical application skills through hands-on exercises.

Learn about ranking functions (RANK, DENSE_RANK, ROW_NUMBER, etc.) and windowing options for aggregate functions through practical real-world examples.

We cover row order functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE, etc.) and provide hands-on practice with time-series data and order-based analysis.

👉 Through this course, learners can expand their data aggregation and analysis skills to an advanced level, gaining practical expertise that can be immediately applied not only to the SQLD exam but also to real-world corporate data analysis environments.

What you will learn

🔹 Part.3-2 SQL Application 1

  • Learn the concepts and applications of GROUPING functions and window functions..

  • RANK(), DENSE_RANK(), and ROW_NUMBER() are used to learn how to handle data ranking through ranking functions..

  • We will conduct a practice session to obtain various aggregation results by using SUM(), MAX(), MIN(), AVG(), COUNT(), and others together with the OVER clause. để nhận được các kết quả tổng hợp đa dạng.

  • Practice row-order functions such as FIRST_VALUE(), LAST_VALUE(), LAG(), and LEAD() to develop time-series data analysis skills. để rèn luyện khả năng phân tích dữ liệu chuỗi thời gian.

  • Learn multi-dimensional aggregation and various grouping strategies through the CUBE and GROUPING SETS functions..

🔹 Part.3-2 SQL Application 2

  • Expanding on the content of Part.3-2-1, we will repeatedly learn and practice window functions and ranking functions.

  • Through various SQL Developer exercises, you will strengthen your ability to utilize data aggregation, ranking, and row-order functions.

  • We cover aggregation options based on the OVER keyword and NULL handling methods that are frequently used in practical data analysis.

🔹 Part.3-2 Advanced SQL Usage 3

  • Learn and practice ratio functions (RATIO_TO_REPORT, PERCENT_RANK, CUME_DIST, NTILE).).

  • Top-N queries and data extraction methods based on ROWNUM and ranking functions are covered.

  • Understand hierarchical queries (LEVEL, CONNECT BY, SYS_CONNECT_BY_PATH) and practice how to process tree-structured data with SQL.) và thực hành cách xử lý dữ liệu cấu trúc cây bằng SQL.

  • Learn techniques for transforming rows and columns using the PIVOT / UNPIVOT clause, and engage in various data processing exercises., đồng thời thực hành các bài tập xử lý dữ liệu đa dạng.

🔹 Part.3-2 SQL Application 4

  • It covers the concepts and applications of Regular Expression (Regex) functions (REGEXP_SUBSTR, REGEXP_REPLACE, REGEXP_INSTR, REGEXP_COUNT, REGEXP_LIKE).

  • Through SQL Developer practice, you will learn regular expression-based data processing techniques such as string searching, replacement, and pattern matching.

  • Review the learned content through SQL application theory problem-solving.

🔹 Part.3-3 Management Syntax

  • DML (INSERT, UPDATE, DELETE, TRUNCATE) syntax and Transaction Control (TCL) concepts will be covered..

  • We will conduct a data merging practice session using MERGE syntax and subqueries. và truy vấn con (subquery).

  • DDL (CREATE, ALTER, DROP, TRUNCATE) syntax, data types, constraints, and referential integrity options will be studied., kiểu dữ liệu, ràng buộc và các tùy chọn toàn vẹn tham chiếu.

  • DCL (USER, Privileges, ROLE management) is used to practice database user privileges and security settings.

  • Finally, we will review the overall SQL management syntax through solving previous exam questions.

Notes before taking the course

This course does not provide Q&A with the instructor

Learning Materials

Weekly lecture notes are provided as PDF files.

Recommended for
these people

Who is this course right for?

  • Any member who wishes to obtain the SQLD certification

  • Any member who wishes to develop basic and practical SQL skills.

Hello
This is usefulit

8,278,857

Learners

6,391

Reviews

4.6

Rating

309

Courses

I will help you grow through useful IT lectures.

Curriculum

All

52 lectures ∙ (33hr 21min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

usefulit's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

$159.50