SQL and Data Visualization – The Complete Bootcamp

سرفصل های دوره

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

1 - Introduction to this SQL & Data Viz course

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

2 - Create Your First Database & Data Set

2 - The tools we will use Metabase Heroku and PGAdmin

3 - Deploy Heroku Server through Metabase

4 - Deploy PGAdmin the tool to build our database

5 - Install Heroku Plugins

5 - heroku-plugins.zip

6 - Deploy your first Database

7 - Dive into our PostgreSQL tables

8 - Know more about tables relationship

8 - Tables.zip

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

10 - Implement all remaining tables in your Database

11 - Download Metabase your Data Visualization tool

12 - Finalize your setup

3 - Learn SQL Basics From Scratch

13 - The SELECT command

14 - Use the AS to define an Alias

15 - The WHERE clause to filter your queries

16 - Sort your queries with the ORDER BY

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

18 - DISTINCT to deduplicate data

19 - Create your first Aggregate Function

20 - The IN operator

21 - LIKE NOT LIKE or ILIKE Enhance your filters

22 - Start to code with Boolean values

23 - GROUP BY to group your results

24 - Its time to create your first Graph Data Viz

4 - Improve your SQL skills & start doing Data Visualization

25 - The Comparison Operators

26 - GREATER or LESS the basics

27 - GREATER or LESS advanced coding

28 - EQUAL or NOT EQUAL

29 - BETWEEN Filter between 2 values

30 - DISTINCT FROM

31 - Create your first Business Analysis

32 - Enrich your dashboard with graphs

33 - Advanced filters and analysis

5 - Advanced SQL From newbie to expert

34 - Find the MIN & the MAX values

35 - SUM your values

36 - Make some conditional expressions with the CASE WHEN

37 - AVG to calculate an average value

38 - Know everything on Median & Percentiles

39 - Filter your aggregate functions

40 - Sort out your data by dates with the DATETRUNC

41 - DATEPART Go further with dates

42 - Calculate the difference between 2 dates

43 - Transform your dates in text with TOCHAR

6 - SQL Level Expert

44 - JOINS Use 2 tables at the same time

45 - Focus on the LEFT JOIN

46 - Focus on the INNER JOIN

47 - Focus on the RIGHT JOIN

48 - Dive in Common Table Expressions CTE

49 - Start using the Common Table Expressions CTE

50 - Get a Cumulative SUM

51 - GENERATESERIES Generate a sample of data Explanations

52 - GENERATESERIES Generate a sample of data Coding

7 - BONUS Cohort Analysis & World Map

53 - Create your first Cohort Analysis

54 - Split your clients in a World Map

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training