SQL Intermediate
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 Pre-Course
Description
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.
What Will I Learn?
- Work with data using Subquery along commons expressions and SQL statements
- Know how to aggregate data for your summary of information
- Apply window functions to perform calculations
- Use other analytical functions like PIVOT in SQL for your data analysis
Topics for this course
Introduction to Subquery
What is Subquery?
Subquery with SELECT Statement
Subquery with WHERE Statement
Subquery with FROM Statement
Subquery with UPDATE, DELETE, INSERT statement
Window Function
Use Table Expression
GROUP BY column-expression
PIVOT AND UNPIVOT
About the instructor
6 Courses
17 students