SQL and Data Visualization The Complete Bootcamp

SQL and Data Visualization – The Complete Bootcamp, available at $54.99, has an average rating of 4.37, with 54 lectures, based on 584 reviews, and has 3102 subscribers.

You will learn about SQL PostgreSQL sql SQL Language Business Intelligence Data Analysis Data Visualization Metabase This course is ideal for individuals who are People who want to improve their reporting and analysis or People who want to learn SQL or Marketing Manager who wants to improve business analysis or Product Marketer who wants to learn SQL to improve a Product or Anyone who wants to get rid of Excel or Spreadsheet to do an analysis It is particularly useful for People who want to improve their reporting and analysis or People who want to learn SQL or Marketing Manager who wants to improve business analysis or Product Marketer who wants to learn SQL to improve a Product or Anyone who wants to get rid of Excel or Spreadsheet to do an analysis.

Enroll now: SQL and Data Visualization – The Complete Bootcamp

Summary

Title: SQL and Data Visualization – The Complete Bootcamp

Price: $54.99

Average Rating: 4.37

Number of Lectures: 54

Number of Published Lectures: 54

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Original Price: 19.99

Quality Status: approved

Status: Live

What You Will Learn

SQL

PostgreSQL

sql

SQL Language

Business Intelligence

Data Analysis

Data Visualization

Metabase

Who Should Attend

People who want to improve their reporting and analysis

People who want to learn SQL

Marketing Manager who wants to improve business analysis

Product Marketer who wants to learn SQL to improve a Product

Anyone who wants to get rid of Excel or Spreadsheet to do an analysis

Target Audiences

People who want to improve their reporting and analysis

People who want to learn SQL

Marketing Manager who wants to improve business analysis

Product Marketer who wants to learn SQL to improve a Product

Anyone who wants to get rid of Excel or Spreadsheet to do an analysis

In this course you will learn how to write and execute SQL queries on your own database. Starting with basic SQL, we will learn how to use PostgreSQL to make advanced data analysis, graphs, reports and tables. 

Who should attend this SQL and Data Viz course?

You who are dependent on Business Analysts to create Reports

You who are limited to Excel or Spreadsheet for your data analyses

You who would like to do some in-depth analysis and blow your boss or client away

You’re the one who always said, “I need to learn SQL!”

You who find your business analysis dull and graphless.

Why learn SQL?

Whether you are a Marketer, Product Marketer, Developer, Sales or Manager, SQL is one of the most sought-after skills in the job market. This extraordinary skill takes your CV into another world, the world of autonomy and rigor in your reporting.

To learn SQL and Data Viz, you don’t need to have a “Business Analyst” career plan. This skill will serve you in all areas, just like some tools such as Excel or Google Spreadsheet have served you well. The only difference? SQL is much more advanced than these!

Become an expert in data visualization

You’ll learn how to become a business analyst and produce reports that are as visual as they are effective. In just a few clicks, create your own PostgreSQL database and connect the best tools to make your analyses dynamic, attractive and orderly. You can then create your own charts, histograms, curves and world maps for specific business situations.

Learn SQL from A to Z

SQL will have no secrets from you. Of course, we’ll go over the basics. Then, you’ll even become an expert as you get more and more powerful as you watch the videos.

CASE
       WHEN ‘become better in analysis’ THEN ‘join this course’
       ELSE  ‘keep working on Excel’
END AS expert_sql_and_data_viz

The tools you will master

– Metabase, the perfect data visualization tool to run your data analysis
– Heroku, to host your database
– PGAdmin, to create your database and data set

Why is this course different from the others?

1- You will apply SQL in real business cases that you will be able to reuse
2- You will work on your own database
3- You will create your own graphs in a few minutes
4- You will progress step by step in the SQL language
5- I will answer all your questions in a few minutes

Anyway, I just wanted to tell you that I’m not from the Data world. I’m a Marketing Manager who got tired of doing his reports in Excel and wanted to take it to the next level by learning SQL! So, if I did it, you can do it.

So, join me in this course “SQL & Data Visualization: the complete guide”, and don’t hesitate to leave a note if you like this course &&

Raffi

Course Curriculum

Chapter 1: Introduction to this SQL & Data Viz course

Lecture 1: Who am I and what will you learn in this cours?

Chapter 2: Create Your First Database & Data Set

Lecture 1: The tools we will use (Metabase, Heroku and PGAdmin)

Lecture 2: Deploy Heroku Server through Metabase

Lecture 3: Deploy PGAdmin, the tool to build our database

Lecture 4: Install Heroku Plugins

Lecture 5: Deploy your first Database!

Lecture 6: Dive into our PostgreSQL tables

Lecture 7: Know more about tables relationship

Lecture 8: Implement your first table customers and insert data from a .csv file

Lecture 9: Implement all remaining tables in your Database

Lecture 10: Download Metabase, your Data Visualization tool

Lecture 11: Finalize your setup

Chapter 3: Learn SQL Basics From Scratch

Lecture 1: The SELECT command

Lecture 2: Use the AS to define an Alias

Lecture 3: The WHERE clause to filter your queries

Lecture 4: Sort your queries with the ORDER BY

Lecture 5: Use the LIMIT clause to limit the results of your query

Lecture 6: DISTINCT, to deduplicate data

Lecture 7: Create your first Aggregate Function!

Lecture 8: The IN operator

Lecture 9: LIKE, NOT LIKE or ILIKE – Enhance your filters

Lecture 10: Start to code with Boolean values

Lecture 11: GROUP BY, to group your results

Lecture 12: Its time to create your first Graph (Data Viz)

Chapter 4: Improve your SQL skills & start doing Data Visualization

Lecture 1: The Comparison Operators

Lecture 2: GREATER or LESS – the basics

Lecture 3: GREATER or LESS – advanced coding

Lecture 4: EQUAL or NOT EQUAL

Lecture 5: BETWEEN – Filter between 2 values

Lecture 6: DISTINCT FROM

Lecture 7: Create your first Business Analysis

Lecture 8: Enrich your dashboard with graphs

Lecture 9: Advanced filters and analysis

Chapter 5: Advanced SQL – From newbie to expert

Lecture 1: Find the MIN & the MAX values

Lecture 2: SUM your values

Lecture 3: Make some conditional expressions with the CASE WHEN

Lecture 4: AVG to calculate an average value

Lecture 5: Know everything on Median & Percentiles

Lecture 6: Filter your aggregate functions

Lecture 7: Sort out your data by dates with the DATE_TRUNC

Lecture 8: DATE_PART – Go further with dates

Lecture 9: Calculate the difference between 2 dates

Lecture 10: Transform your dates in text with TO_CHAR

Chapter 6: SQL, Level Expert!

Lecture 1: JOINS – Use 2 tables at the same time

Lecture 2: Focus on the LEFT JOIN

Lecture 3: Focus on the INNER JOIN

Lecture 4: Focus on the RIGHT JOIN

Lecture 5: Dive in Common Table Expressions (CTE)

Lecture 6: Start using the Common Table Expressions – CTE

Lecture 7: Get a Cumulative SUM

Lecture 8: GENERATE_SERIES – Generate a sample of data (Explanations)

Lecture 9: GENERATE_SERIES – Generate a sample of data (Coding)

Chapter 7: BONUS – Cohort Analysis & World Map

Lecture 1: Create your first Cohort Analysis

Lecture 2: Split your clients in a World Map

Instructors

Raffi Sarkissian | SQL | PostgreSQL | Metabase
Head of Monetization & BI

Rating Distribution

1 stars: 5 votes

2 stars: 9 votes

3 stars: 59 votes

4 stars: 203 votes

5 stars: 308 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!