Udemy – SQL for Data Analysis: Advanced SQL Querying Techniques 2024-11

Published on: 2024-11-25 14:58:36

Categories: 28

Description

SQL for Data Analysis Course: Advanced SQL Querying Techniques. This hands-on, project-based course is designed to help you move beyond the six basic phrases and master advanced query techniques. We begin by reviewing the basics and performing multi-table analysis, including basic joins, self-joins, cross-joins, and unions. Next, we cover different ways to work with nested queries by writing subqueries and common table expressions, or CTEs. We examine examples of subqueries in various statements, rewrite subqueries as CTEs, introduce recursive CTEs, and compare these techniques to alternatives such as temporary tables and views. From there, we break down each component into a window function and examine common window functions such as ROW_NUMBER, RANK, FIRST_VALUE, LEAD, and LAG. We also cover general functions for working with different data types in SQL, including numeric, datetime, string, and NULL functions. Finally, we will apply the concepts we have learned to a series of common data analysis applications. We deal with duplicate values, apply eigenvalue filters, perform floating calculations, and more.

What you will learn in SQL for Data Analysis: Advanced SQL Querying Techniques course

Perform multi-table analysis using JOINs and learn variations such as self-joins, cross-joins, and more
Learn to work with nested queries by writing subqueries and common table expressions (CTEs) and understanding the best use cases for each.
Use window functions to perform calculations on a set of rows and learn about different function options and uses
Discover the many SQL functions that can be applied to numeric, datetime, string, and NULL data fields
Apply advanced query techniques to common data analysis scenarios, including data rotation, dynamic calculations, and more

This course is suitable for people who

Analysts or BI professionals looking to analyze data stored in relational database systems
SQL users who want to develop their advanced query skills
Anyone looking for a practical, practical, and highly engaging way to master SQL for advanced data analysis

Course specifications SQL for Data Analysis: Advanced SQL Querying Techniques

Publisher: Udemy
Instructor: Maven Analytics , Alice Zhao
Training level: beginner to advanced
Training duration: 8 hours and 21 minutes
Number of courses: 125

Course headings

SQL for Data Analysis: Advanced SQL Querying Techniques course prerequisites

Any SQL Editor (we’ll walk you through the installation process specifically for MySQL Workbench)
If you are new to SQL, we strongly recommend taking Maven Analytics’ Beginner MySQL Business Intelligence course first