Boss That Sql

Master SQL with Databricks and Become A Job-Ready Data Analyst Fast

What you'll learn

Learn to use Databricks cloud platform to perform data analysis

Learn to build fundamental SQL queries

Learn to apply the knowledge to run queries from big datasets (9 million+ rows)

Learn to draw insights and tell story from the big data analysis

Requirements

Open mind and curiosity to learn. This SQL course is different from all other available online SQL courses because you will truly have hands-on experience working on big datasets

Description

This course is designed for beginners who want to become a job-ready data analyst fast and look for practical tools to get trained and mentored right away. By the end of the course, you will build a strong foundation in query techniques and a general knowledge of applying these techniques to solving business problems. You will also get real big data analytics experience because this course is built and taught entirely on the cloud platform.Specifically, this course provides 4 datasets with a combined total of over 9 million records, 47 lesson files, 284 practice problems including solutions, and a case study in the end. In addition, it offers comprehensive step-by-step instructions for each training video. We also have Facebook study community to host Q&A sessions so you are not alone in the journey.If you are looking for a course that:1. provides plenty of big data analysis exercises2. provides coherent and comprehensive teaching that builds up your knowledge3. provides cloud learning opportunity that better prepares you for today's analytics job market4. cares about your study progress and challenges5. provides a thorough end to end data analysis walk-throughThen look no further, try Boss That SQL today

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course Navigation

Section 2: Get Databricks

Lecture 3 Create An Account

Lecture 4 Create an Account - Step by Step Instructions

Lecture 5 Run Databricks Cluster

Lecture 6 Run Databricks Cluster - Step by Step Instructions

Lecture 7 Upload Files

Lecture 8 Upload Files - Step by Step Instructions

Lecture 9 Load Data

Lecture 10 Load Data - Step by Step Instructions

Lecture 11 Additional Databricks Control Panel Navigation Instructions

Section 3: SQL Structure and Syntax

Lecture 12 Retrieve, Limit, and Sort Data

Lecture 13 Retrieve, Limit, and Sort Data - Step by Step Instructions

Lecture 14 Compare Data

Lecture 15 Compare Data - Step by Step Instructions

Lecture 16 How to Use In, Null, Like

Lecture 17 How to Use In, Null, Like - Step by Step Instructions

Lecture 18 SQL Database Schema and Table Structure

Section 4: SQL Date and Timestamp

Lecture 19 Convert String into Date and Timestamp

Lecture 20 Convert String into Date and Timestamp - Step by Step Instructions

Lecture 21 How to Use Interval, Extract, Subtract, and Add

Lecture 22 How to Use Interval, Extract, Subtract, and Add - Step by Step Instructions

Lecture 23 Additional SQL Data Types Summary

Lecture 24 Additional SQL Functions Summary

Section 5: SQL Aggregation

Lecture 25 Count(), Sum(), Avg() with Groupby

Lecture 26 Count(), Sum(), Avg() with Groupby - Step by Step Instructions

Lecture 27 Case, Case Sum, Case Count Distinct with Groupby

Lecture 28 Case, Case Sum, Case Count Distinct with Groupby - Step by Step Instructions

Section 6: SQL Windows Functions

Lecture 29 Row_Number(), Rank(), and Dense_Rank()

Lecture 30 Row_Number(), Rank(), and Dense_Rank() - Step by Step Instructions

Lecture 31 Cumulative Sum(), Avg(), Lead(), and Lag() with Subquery

Lecture 32 Cumulative with Subquery - Step by Step Instructions

Lecture 33 Cumulative Sum(), Avg(), Lead(), and Lag() with CTE

Lecture 34 Cumulative with CTE - Step by Step Instructions

Section 7: SQL Joins

Lecture 35 Inner, Left, Right, and Full Join

Lecture 36 Inner, Left, Right, and Full Join - Step by Step Instructions

Lecture 37 Subqueries

Lecture 38 Subqueries - Step by Step Instructions

Lecture 39 Subqueries with Joins

Lecture 40 Subqueries with Joins - Step by Step Instructions

Lecture 41 Subqueries with Unions

Lecture 42 Subqueries with Unions - Step by Step Instructions

Lecture 43 CTEs

Lecture 44 CTE - Step by Step Instructions

Lecture 45 CTE with Joins

Lecture 46 CTE with Joins - Step by Step Instructions

Lecture 47 CTE with Unions

Lecture 48 CTE with Unions - Step by Step Instructions

Lecture 49 How to Write and Style Subqueries

Lecture 50 How to Write and Style CTEs

Section 8: SQL Pivot

Lecture 51 Pivot

Lecture 52 Pivot - Step by Step Instructions

Lecture 53 Unpivot

Lecture 54 Unpivot - Step by Step Instructions

Section 9: Pulling Everything Together

Lecture 55 Data Visualization

Lecture 56 Data Visualization - Step by Step Instructions

Lecture 57 Tell a Story with Data - Plan Data

Lecture 58 Tell a Story with Data Plan Data - Step by Step Instructions

Lecture 59 Tell a Story with Data - Customers Data

Lecture 60 Tell a Story with Data Customers Data - Step by Step Instructions

Lecture 61 Make Recommendations

Lecture 62 Make Recommendations - Step by Step Instructions

This is for people with no SQL background and are serious about getting a job as a SQL data analyst,This is for people who look for real practice experience not just learning the syntax