Data Analysis & Business Intelligence with MySQL/Python/SQL

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

Hands-on Data Analysis & Visualization with SQL and Python

1. MySQL Setup

1. Introduction

2. What is Data Analysis.html

3. What is business intelligence.html

4. What is SQL

5. What is MySQL

6. MySQL Installation on Macs

7. MySQL Installation on Windows

8. Connecting to MySQL Server

9. What is MySQL Workbench

10. Installing MySQL Workbench on Macs

11. Basic Database Concepts

12. What is a Schema

13. MySQL Data Types

14. Displaying MySQL Databases in MySQL Workbench

15. View MySQL Database Tables using MySQL Workbench

2. Querying Data

1. Query a single Table

2. Using WHERE Clause in your query

3. Using ORDER BY Clause in your query

4. Using GROUP BY Clause in your query

5. Using HAVING Clause in your query

6. Excluding duplicates in query results

7. Limiting data returned by a query

8. Query data with the Character Length Function

9. Query data with the CONCAT Function

10. Query data using a Subquery

11. Query data using a Nested Subquery

12. Query data using a Derived Table

13. Query data using BETWEEN Operator

14. Query data using IN Operator

15. Query data using LIKE Operator

16. Query data using UNION Operator

3. Analysing Multiple Tables with Joins

1. What are Table Joins.html

2. Analysing data with INNER JOIN

3. Analysing data with LEFT JOIN

4. Analysing data with RIGHT JOIN

5. Analysing data with SELF JOIN

4. Analysing Data with Aggregate Functions

1. What are Aggregate Functions

2. Query data using AVG Aggregate Function

3. Query data using COUNT Aggregate Function

4. Query data using SUM Aggregate Function

5. Query data using MIN Aggregate Function

6. Query data using MAX Aggregate Function

5. Python and Jupyter Notebook Setup

1. What is Python

2. What is Jupyter NoteBook

3. Installing Jupyter Notebook Server

4. Running Jupyter Notebook Server

5. Some Jupyter Notebook Commands

6. Jupyter Notebook components

7. Jupyter Notebook Dashboard

8. Jupyter Notebook Interface

9. Create a Jupyter Notebook

6. Data Analysis using Python

1. Kaggle Datasets

2.1 us_baby_names.zip

2. Tabular Data

3. Exploring Pandas DataFrame

4. Analysing and manipulating Pandas DataFrame

5. What is Data Cleaning

6.1 crime_boston.zip

6. Performing Data Cleaning

7.1 listings.zip

7. Data Visualization

8. Visualizing qualitative data

9. Visualizing quantitative data

139,000 تومان

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

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

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

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