وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 12335
    حجم: 2530 مگابایت
    مدت زمان: 325 دقیقه
    تاریخ انتشار: 28 اردیبهشت 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید