SQL and Data Visualization - The Complete Bootcamp

Focused View

Raffi Sarkissian | SQL | PostgreSQL | Metabase

5:24:31

94 View

1 - Introduction to this SQL & Data Viz course

1 - Who am I and what will you learn in this cours.mp4

02:11

2 - Create Your First Database & Data Set

2 - The tools we will use Metabase Heroku and PGAdmin.mp4

01:48

3 - Deploy Heroku Server through Metabase.mp4

05:16

4 - Deploy PGAdmin the tool to build our database.mp4

10:35

5 - Install Heroku Plugins.mp4

11:01

5 - heroku-plugins.zip

6 - Deploy your first Database.mp4

06:11

7 - Dive into our PostgreSQL tables.mp4

02:43

8 - Know more about tables relationship.mp4

08:16

8 - Tables.zip

9 - Implement your first table customers and insert data from a csv file.mp4

08:13

10 - Implement all remaining tables in your Database.mp4

11:01

11 - Download Metabase your Data Visualization tool.mp4

03:00

12 - Finalize your setup.mp4

04:50

3 - Learn SQL Basics From Scratch

13 - The SELECT command.mp4

05:27

14 - Use the AS to define an Alias.mp4

04:40

15 - The WHERE clause to filter your queries.mp4

03:15

16 - Sort your queries with the ORDER BY.mp4

02:41

17 - Use the LIMIT clause to limit the results of your query.mp4

03:48

18 - DISTINCT to deduplicate data.mp4

01:44

19 - Create your first Aggregate Function.mp4

04:18

20 - The IN operator.mp4

02:27

21 - LIKE NOT LIKE or ILIKE Enhance your filters.mp4

04:55

22 - Start to code with Boolean values.mp4

03:06

23 - GROUP BY to group your results.mp4

06:22

24 - Its time to create your first Graph Data Viz.mp4

04:29

4 - Improve your SQL skills & start doing Data Visualization

25 - The Comparison Operators.mp4

04:00

26 - GREATER or LESS the basics.mp4

03:48

27 - GREATER or LESS advanced coding.mp4

06:06

28 - EQUAL or NOT EQUAL.mp4

05:10

29 - BETWEEN Filter between 2 values.mp4

03:13

30 - DISTINCT FROM.mp4

01:48

31 - Create your first Business Analysis.mp4

08:50

32 - Enrich your dashboard with graphs.mp4

05:02

33 - Advanced filters and analysis.mp4

07:47

5 - Advanced SQL From newbie to expert

34 - Find the MIN & the MAX values.mp4

06:32

35 - SUM your values.mp4

09:07

36 - Make some conditional expressions with the CASE WHEN.mp4

10:34

37 - AVG to calculate an average value.mp4

08:31

38 - Know everything on Median & Percentiles.mp4

06:15

39 - Filter your aggregate functions.mp4

04:23

40 - Sort out your data by dates with the DATETRUNC.mp4

09:30

41 - DATEPART Go further with dates.mp4

02:32

42 - Calculate the difference between 2 dates.mp4

03:51

43 - Transform your dates in text with TOCHAR.mp4

02:45

6 - SQL Level Expert

44 - JOINS Use 2 tables at the same time.mp4

06:08

45 - Focus on the LEFT JOIN.mp4

04:44

46 - Focus on the INNER JOIN.mp4

02:09

47 - Focus on the RIGHT JOIN.mp4

04:11

48 - Dive in Common Table Expressions CTE.mp4

03:50

49 - Start using the Common Table Expressions CTE.mp4

13:10

50 - Get a Cumulative SUM.mp4

08:44

51 - GENERATESERIES Generate a sample of data Explanations.mp4

03:45

52 - GENERATESERIES Generate a sample of data Coding.mp4

07:56

7 - BONUS Cohort Analysis & World Map

53 - Create your first Cohort Analysis.mp4

32:19

54 - Split your clients in a World Map.mp4

05:34

Description

Become an expert in SQL, Data Analysis, Business Intelligence & Data Visualization. Learn SQL from A to Z

What You'll Learn?

SQL
PostgreSQL
sql
SQL Language
Business Intelligence
Data Analysis
Data Visualization
Metabase

Who is this for?

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

More details

Description
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
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Hello,I am Raffi Sarkissian, one of the co-founders of Lago, the no-code data tool for Growth Teams.Previously, I was the Head of Growth Operations & Business Intelligence at Qonto, a 500-person fintech that raised €135 million in funding. I manage a team of 4 data analysts. This has allowed me to install or use powerful data visualization tools like Metabase or Tableau and to work on Postgresql databases or Warehouses like Snowflake. My expertise allows me to teach beginners the art of SQL and data analysis in a simple, fun and multi-step way: 1- Installing a database with PGAdmin, a data visualization tool with Metabase and a server with Heroku. 2- The basics of SQL3- Building graphs and BI dashboards for a first step in the world of data visualization4- Advanced SQL to meet business needs (cohorts, median, quartiles, series generation etc...)Kind regardsRaffi

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.