SQL For Data Analysis

Focused View

Pabba Anu Bharth

39:58

7 View

1. Introduction to SQL

1. Introduction.mp4

10:36

2. Resources.html

2. Joins

1. Inner Join.mp4

02:26

2. Outer Join.mp4

06:38

3. Aggregations

1. Aggregations.mp4

01:16

2. Significance of NULL Value.mp4

01:06

3. Difference between NULL and empty string.mp4

01:46

4. Count.mp4

01:01

5. SUM.mp4

00:30

6. MIN, MAX and AVG.mp4

00:14

7. GROUP BY and ORDER BY.mp4

02:09

8. DISTINCT.mp4

00:38

9. HAVING.mp4

00:40

10. CASE.mp4

01:17

4. Sub queries

1. Sub Queries.mp4

03:04

5. Data Cleaning

1. Clean data in two use cases.mp4

06:37

Description

Use this program to excel your SQL knowledge specific to data analysis.

What You'll Learn?

Basic SQL Commands
Joins in SQL
Aggregations
Writing Subqueries
Data Cleaning in SQL

Who is this for?

Data analysts

Marketers

Software Engineers

Product Managers

Anyone with passion to get started with SQL

What You Need to Know?

Basic understanding of data and data types

Anyone with access to computers and with some basic excel spreadsheet knowledge

More details

Description
Introducing, the SQL For Data Analysis.
In this official course you willÂ be guided on different functionalities in SQL that are specific to Data analysis and videos are developed in easy terms and less technical so that any one without technical capabilities, can easily get through this course.

Introduction to SQL
Learn very basics in SQL
JOINS
Learn INNER and OUTER join in the most easiest way.
Aggregations
Importance of NULL
Most commonly used aggregations in SQL
GROUP BY, HAVING, CASE statements in SQL
With practical demonstration
Sub Queries
Learn sub queries with practical examples
Data cleaning
Learn how to clean data in two useful use cases.
There are currently over more than half a million jobs related to SQL on LinkedIn. Many rolesÂ like product analyst, data analyst, data scientist, business analyst, product manager, software engineer, and more require SQL to perform their day to day tasks. Nowadays employers are eager to get professionals with SQL skillset. SQL is the most in-demand skill, higher than other programming languages.

This course is for anyone who can basically operate computers and have some basic understanding on how to use excel spreadsheets. By the end of this course you will get yourself skilled up with a good basic foundations of SQL.
Ready to embark on your SQL data analysis journey? Let's get started!

Who this course is for:
Data analysts
Marketers
Software Engineers
Product Managers
Anyone with passion to get started with SQL

User Reviews

Rating

average 0

Total votes0

Focused display

I currently develop full stack web, data engineering solutions at Homage. I recently started teaching on web as a hobby. I Earlier I've worked on building robust conversational chatbots using deep learning. I was/am/will be working on innovating ed and health technologies. Happy to excel and help you in your learning journey.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.