The Complete SQL Bootcamp for Data Analysis – Level 2

The Complete SQL Bootcamp for Data Analysis – Level 2, available at $59.99, has an average rating of 4.38, with 27 lectures, 5 quizzes, based on 4 reviews, and has 2515 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone interested in learning about data analysis with SQL It is particularly useful for Anyone interested in learning about data analysis with SQL.

Enroll now: The Complete SQL Bootcamp for Data Analysis – Level 2

Summary

Title: The Complete SQL Bootcamp for Data Analysis – Level 2

Price: $59.99

Average Rating: 4.38

Number of Lectures: 27

Number of Quizzes: 5

Number of Published Lectures: 27

Number of Published Quizzes: 5

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $124.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Anyone interested in learning about data analysis with SQL

Target Audiences

Anyone interested in learning about data analysis with SQL

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!

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Welcome to Level 2!

Lecture 2: Our Learning Objectives

Lecture 3: Loading the Books Datasets

Lecture 4: Loading the eCommerce Datasets

Chapter 2: SQL – Combining Data from Multiple Tables

Lecture 1: Overview

Lecture 2: Union, Intersect, Except

Lecture 3: Cross-Join

Lecture 4: Inner-Join

Lecture 5: Outer-Join

Chapter 3: SQL – Subqueries

Lecture 1: Overview

Lecture 2: What is Subquery?

Lecture 3: Conditional Logic – Single Row

Lecture 4: Conditional Logic – Multiple Rows

Lecture 5: As Inline Views (FROM)

Chapter 4: SQL – Conditional Logic (CASE)

Lecture 1: Overview

Lecture 2: Simple CASE – Data Transformation

Lecture 3: Searched CASE – Classification and Binning

Chapter 5: SQL – Window Functions

Lecture 1: Overview

Lecture 2: Creating a Window Function

Lecture 3: Sequential Numbers

Lecture 4: Ranking

Chapter 6: SQL – Simplify Queries (Views, CTEs)

Lecture 1: Overview

Lecture 2: Virtual Tables (Views)

Lecture 3: Common Table Expressions (CTEs)

Chapter 7: Course Summary

Lecture 1: Lets Recap

Lecture 2: Level 2 – Final Project

Lecture 3: *** BONUS ***

Instructors

Idan Gabrieli
Online Teacher | Data, Cloud, AI

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 1 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!