The Complete SQL Bootcamp for Data Analysis – Level 2

Focused View

Idan Gabrieli

1:43:22

172 View

1. Getting Started

1. Welcome to Level 2!.mp4

03:09

2. Our Learning Objectives.mp4

02:36

3.1 books datasets.zip

3. Loading the Books Datasets.mp4

08:57

4.1 ecommerce datasets.zip

4. Loading the eCommerce Datasets.mp4

07:15

2. SQL - Combining Data from Multiple Tables

1. Overview.mp4

00:52

2. Union, Intersect, Except.mp4

06:36

3. Cross-Join.mp4

03:09

4. Inner-Join.mp4

06:25

5. Outer-Join.mp4

06:32

6. Quiz #1 - Combining Data from Multiple Tables.html

3. SQL Subqueries

1. Overview.mp4

01:02

2. What is Subquery.mp4

02:47

3. Conditional Logic Single Row.mp4

06:00

4. Conditional Logic Multiple Rows.mp4

07:05

5. As Inline Views (FROM).mp4

03:20

6. Quiz #2 - Subqueries.html

4. SQL - Conditional Logic (CASE)

1. Overview.mp4

01:34

2. Simple CASE - Data Transformation.mp4

04:06

3. Searched CASE Classification and Binning.mp4

05:06

4. Quiz #3 - Conditional Logic (CASE).html

5. SQL - Window Functions

1. Overview.mp4

03:05

2. Creating a Window Function.mp4

03:10

3. Sequential Numbers.mp4

03:16

4. Ranking.mp4

01:34

5. Quiz #4 - Window Functions.html

6. SQL Simplify Queries (Views, CTEs)

1. Overview.mp4

00:40

2. Virtual Tables (Views).mp4

06:56

3. Common Table Expressions (CTEs).mp4

02:42

4. Quiz #5 - Simplify Queries (Views, CTEs).html

7. Course Summary

1. Lets Recap.mp4

05:28

Description

Learn SQL A-to-Z for Data Analysis Projects

What You'll Learn?

Use SQL to query data in databases
Perform data analysis and extract useful insights
Combine Data from Multiple Tables
Filter Data using Subqueries
Perform Data Transformation using CASE statements
Utilize Window Functions for data analysis
Simplify Queries using Views and CTEs

Who is this for?

Anyone interested in learning about data analysis with SQL

More details

Description
Data is Everywhere
It is not a secret that data is everywhere; data is collected, processed, and accumulated in massive databases across all industry domains. As the technologies for handling data are evolving rapidly, the industry challenge is more focused on data utilization than data collection and storage. As a result, many organizations are looking for the right mix of people, tools, and products to help them pick up those piles of data, extract valuable insights and constantly gain market advantage.
Becoming an SQL Wizard
SQL is the most popular language to extract, load, and query data from databases. If you master SQL, you gain the amazing and useful flexibility to explore, filter and aggregate almost any raw data in multiple dimensions. SQL Wizards are needed everywhere.
Level 2
The complete training program is divided into multiple sequential levels to let you grow your knowledge and understanding of SQL and data analysis.
Level 2 is a direct continuum of the topics we learned in level 1. It will extend your knowledge into more advanced SQL tools and capabilities. We will learn to combine data from multiple data sources, break complex queries into sub-queries, transform and classify data, analyze data with window functions, create views, CTEs, and more.
We will use quizzes and exercises to practice and sharpen your understanding of the learning objectives. In any case, I am here for any questions.
I wish you AWESOME learning and hope to see you inside!
Who this course is for:
Anyone interested in learning about data analysis with SQL

User Reviews

Rating

average 0

Total votes0

Focused display

For the past decade, Idan Gabrieli has been working in various engineering positions at the heart of Israel's high-tech industry, also called the start-up nation. Through his career, Idan has gained extensive experience working with hundreds of business companies, helping them transform challenges and opportunities into practical use cases while leveraging cutting-edge technologies.Idan has comprehensive knowledge that spans multiple domains, including cloud computing, machine learning, data science, electronics, and more. In 2014, Idan started to create and publish online courses on various topics while teaching thousands of students worldwide. In 2021-2022, Idan was recognized as a top-seller and high-rated instructor in multiple leading educational providers.As part of his teaching style, Idan is well-known for simplifying complex technology topics and providing high-quality educational content suitable to the relevant audience. Every course has specific learning objectives, easy-to-follow structure, and straight-to-point material while combining various multimedia teaching options.

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.