Sql For Data Analysis

Sql For Data Analysis
Published 5/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

SQL For Data Analysis

What you’ll learn

SQL Query for Data Analysis

Basic SQL Syntax

SQL Join

Limiting Row

Filtering Data

Set Operation

Subquery

Grouping Data

Common Table Expression

Pivot in SQL

Expression in SQL Server

Function in SQL

Window and Rank Function

Requirements

NO experience needed, Any one can learn this Course

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Connect to SQL Server

Lecture 3 Basic SQL Syntax

Lecture 4 Order of Query Execution

Section 2: Limiting the Rows

Lecture 5 OFFSET and Fetch

Lecture 6 Top with Percentage

Section 3: Filtering Data

Lecture 7 Distinct

Lecture 8 Where Clause with Equal and Not Equal

Lecture 9 Where Clause with <,>,>=,<= Operator

Lecture 10 Where Clause with not like Operator

Lecture 11 Where Clause with like Operator

Lecture 12 Where Clause with and, Or

Lecture 13 Where Clause with Null

Lecture 14 Where Clause with Exist and Not Exist

Section 4: Joining Table

Lecture 15 Left Join

Lecture 16 Right Join

Lecture 17 Inner Join

Lecture 18 Cross Join

Lecture 19 Full Outer Join

Lecture 20 Advance or Intelligent Join

Section 5: Grouping Data

Lecture 21 Group by

Lecture 22 Group By With Aggregate

Lecture 23 Cube

Lecture 24 Roll UP

Lecture 25 Group By with Where and Having Clause

Lecture 26 Group by with Grouping Set

Section 6: Sub Query

Lecture 27 Sub Query

Lecture 28 Nested Sub Query

Lecture 29 Subquery with Exist and Not Exist

Lecture 30 Sub Query with Any and All

Lecture 31 CO-Related Sub Query

Lecture 32 Sub Query in Expression

Lecture 33 Sub Query in From Clause

Section 7: Set Operator

Lecture 34 Union and Union All

Lecture 35 Intersection

Lecture 36 Except

Section 8: Common Table Expression

Lecture 37 Common Table Expression

Lecture 38 Recursive Common Table Expression

Lecture 39 Multiple CTE in SQL Server

Section 9: Pivot Table

Lecture 40 Pivot Table

Section 10: Expression

Lecture 41 Case Statement

Section 11: Function in SQL

Lecture 42 String Function

Lecture 43 Date and Time Function

Lecture 44 User Defined Function

Lecture 45 Inline Table Value Function

Lecture 46 Multi Statement Table Value Function

Section 12: Window or Analytics Function

Lecture 47 Rank Function

Lecture 48 First and Last

Lecture 49 Lead and Lag

Lecture 50 CUM Distributive Function

Lecture 51 NTILE Function

Working Professionals beginning their Data journey,Data Analyst,Anyone curious to master SQL from beginner to Advanced in short span of time,Students or Professional looking for Job as Data Analyst