Learn Real-World SQL and Data Visualization

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

1. Introduction

1. Introduction

2. Course Structure

1.1 course structure.txt

1. important SQL and Data Visualization

3. Installation for Required Tools Java, Metabase & MySQL

1.1 java installation.txt

1. Install Java Runtime Environment for Metabase & MySQL

2.1 metabase installation.txt

2. Install Metabase

3.1 mysql installation.txt

3. Install MySQL

4.1 metabase mysql installation.txt

4.2 property transaction mod.csv

4. Setup connection for Metabase & MySQL

5.1 property transaction mod.csv

5. Material.html

4. SQL fundamental SELECT, INSERT, UPDATE, DELETE

1.1 insert keyword.txt

1.2 table creation.txt

1. Learn INSERT keyword

2.1 select keyword.txt

2. Learn SELECT keyword

3.1 update keyword.txt

3. Learn UPDATE keyword

4.1 delete keyword.txt

4. Learn DELETE keyword

5. SQL conditional keywords IN, BETWEEN, CASE WHEN, LIKE

1.1 in keyword.txt

1. Learn IN keyword

2.1 between keyword.txt

2. Learn BETWEEN keyword

3.1 case when.txt

3. Learn CASE WHEN keywords

4.1 like.txt

4. Learn LIKE keyword

6. SQL Aggregation Fuctions & Visualisation

1. Introduce aggregation functions and useful charts

2.1 property transaction mod.csv

2. Prepare real world data

3.1 count.txt

3. Learn SQL count function & create chart

4.1 sum.txt

4. Learn SQL sum function & create chart

5.1 average.txt

5. Learn SQL average function & create chart

6.1 max.txt

6.2 min.txt

6. Learn SQL Max Min Functions & create chart

7. Learn on Aggregating charts into one dashboard

7. SQL string functions & Visualization

1.1 concate 2.txt

1. Introduce string functions and useful charts

2. Learn substring index function and create chart

3. Learn with keyword

4. Learn lower and upper functions

5. Learn substring function

6.1 concate.txt

6. Learn concate function & recap on case when & create chart

7. Learn on Aggregating charts into one dashboard

8.1 sum over.txt

8. Extra Learn on sum over functions

189,000 تومان

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

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

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

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