SQL Intermediate For Data Management

Course Prerequisite(s)

Please note that this course has the following prerequisites which must be completed before it can be accessed
Introduction to SQL and Database
SQL Sever Environment Set Up

About Course

SQL is a standard tool for handling structured data in a relational database also essential for carrying out data wrangling to prepare your data. SQL Intermediate course is designed to teach you several key functions necessary to wrangle, filter, and categorize information in a relational database, expand your SQL toolkit, and answer complex questions. You will learn the usage of subqueries, window functions Use Table Expression, GROUP BY column-expression, Pivot and Unpivot. This course will give skills and practical steps to work with data after having basic SQL knowledge.

The emphasis in this course is on hands-on, practical learning. By the end of the course you will work with real databases, real data science tools, and real-world datasets. Through assignments and quizzes, you will practice and write SQL queries.

Course Content

Introduction to Subquery
n this topic, you will learn how to use SQL subquery in general, subquery with IN and NOT IN, Subquery with Alias Table, Subquery with UPDATE, DELETE, INSERT statement, Subquery with comparison operators, Subquery with comparison operators, Subquery with EXISTSand NOT EXISTS and Subqueries used in place of an expression. You will understand the subquery to your dataset and where should you include them into your queries.

What is Subquery?
Subquery with SELECT Statement
Subquery with WHERE Statement
Subquery with FROM Statement
Subquery with UPDATE, DELETE, INSERT statement

Window Function
In this topic, you will learn about window functions that are specific to arguments and how to pass aggregate, rank window and value window functions along with a dataset.

Use Table Expression
In this topic, You will learn about CTE, Temporary tables, Variable and variable tables. Then, You will understand the different usage of them.

GROUP BY column-expression
In Introduction to SQL course, You have learnt about writing query using GROUP BY already. But in this topic, You will learn how to use GROUP BY GROUPING SETS, GROUP BY ROLLUP, GROUP BY CUBE and what is the difference between them along with examples.

PIVOT AND UNPIVOT
In this topic, you will learn how to use PIVOT and UNPIVOT tables in SQL. You will understand when and where should u include you PIVOT and UNPIVOT.

Add this certificate to your CV profile to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

SQL Intermediate For Data Management

Course Prerequisite(s)

About Course

What Will You Learn?

Course Content

What is Subquery?

Subquery with SELECT Statement

Subquery with WHERE Statement

Subquery with FROM Statement

Subquery with UPDATE, DELETE, INSERT statement

Window Function
In this topic, you will learn about window functions that are specific to arguments and how to pass aggregate, rank window and value window functions along with a dataset.

What is Window Function?

Arguments

Aggregate Window functions

Rank Window functions

Value Window Functions

Use Table Expression
In this topic, You will learn about CTE, Temporary tables, Variable and variable tables. Then, You will understand the different usage of them.

Common Table Expression (CTE)

Temporary Table

Variable

Table Variable

GROUP BY column-expression
In Introduction to SQL course, You have learnt about writing query using GROUP BY already. But in this topic, You will learn how to use GROUP BY GROUPING SETS, GROUP BY ROLLUP, GROUP BY CUBE and what is the difference between them along with examples.

GROUP BY GROUPING SETS

GROUP BY ROLLUP

GROUP BY CUBE

GROUP BY COUNT() with HAVING

PIVOT AND UNPIVOT
In this topic, you will learn how to use PIVOT and UNPIVOT tables in SQL. You will understand when and where should u include you PIVOT and UNPIVOT.

PIVOT

UNPIVOT Data

Earn Your Certificates

PROGRAMS

COMPANY

COMMUNITY

Course Prerequisite(s)

About Course

What Will You Learn?

Course Content

What is Subquery?

Subquery with SELECT Statement

Subquery with WHERE Statement

Subquery with FROM Statement

Subquery with UPDATE, DELETE, INSERT statement

Window Function In this topic, you will learn about window functions that are specific to arguments and how to pass aggregate, rank window and value window functions along with a dataset.

What is Window Function?

Arguments

Aggregate Window functions

Rank Window functions

Value Window Functions

Use Table Expression In this topic, You will learn about CTE, Temporary tables, Variable and variable tables. Then, You will understand the different usage of them.

Common Table Expression (CTE)

Temporary Table

Variable

Table Variable

GROUP BY column-expression In Introduction to SQL course, You have learnt about writing query using GROUP BY already. But in this topic, You will learn how to use GROUP BY GROUPING SETS, GROUP BY ROLLUP, GROUP BY CUBE and what is the difference between them along with examples.

GROUP BY GROUPING SETS

GROUP BY ROLLUP

GROUP BY CUBE

GROUP BY COUNT() with HAVING

PIVOT AND UNPIVOT In this topic, you will learn how to use PIVOT and UNPIVOT tables in SQL. You will understand when and where should u include you PIVOT and UNPIVOT.

PIVOT

UNPIVOT Data

Earn Your Certificates

Student Ratings & Reviews

PROGRAMS

COMPANY

COMMUNITY

Window Function
In this topic, you will learn about window functions that are specific to arguments and how to pass aggregate, rank window and value window functions along with a dataset.

Use Table Expression
In this topic, You will learn about CTE, Temporary tables, Variable and variable tables. Then, You will understand the different usage of them.

GROUP BY column-expression
In Introduction to SQL course, You have learnt about writing query using GROUP BY already. But in this topic, You will learn how to use GROUP BY GROUPING SETS, GROUP BY ROLLUP, GROUP BY CUBE and what is the difference between them along with examples.

PIVOT AND UNPIVOT
In this topic, you will learn how to use PIVOT and UNPIVOT tables in SQL. You will understand when and where should u include you PIVOT and UNPIVOT.