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