Data Analysis & Business Intelligence with MySQL/Python/SQL

Focused View

Digital Learning Academy

5:39:06

195 View

1. MySQL Setup

1. Introduction.mp4

00:20

2. What is Data Analysis.html

3. What is business intelligence.html

4. What is SQL.mp4

04:32

5. What is MySQL.mp4

03:31

6. MySQL Installation on Macs.mp4

06:58

7. MySQL Installation on Windows.mp4

10:20

8. Connecting to MySQL Server.mp4

02:53

9. What is MySQL Workbench.mp4

06:02

10. Installing MySQL Workbench on Macs.mp4

05:36

11. Basic Database Concepts.mp4

09:00

12. What is a Schema.mp4

04:50

13. MySQL Data Types.mp4

06:56

14. Displaying MySQL Databases in MySQL Workbench.mp4

02:54

15. View MySQL Database Tables using MySQL Workbench.mp4

02:06

2. Querying Data

1. Query a single Table.mp4

04:17

2. Using WHERE Clause in your query.mp4

02:37

3. Using ORDER BY Clause in your query.mp4

06:10

4. Using GROUP BY Clause in your query.mp4

03:56

5. Using HAVING Clause in your query.mp4

06:31

6. Excluding duplicates in query results.mp4

05:57

7. Limiting data returned by a query.mp4

06:18

8. Query data with the Character Length Function.mp4

01:59

9. Query data with the CONCAT Function.mp4

02:42

10. Query data using a Subquery.mp4

04:37

11. Query data using a Nested Subquery.mp4

03:22

12. Query data using a Derived Table.mp4

04:15

13. Query data using BETWEEN Operator.mp4

06:39

14. Query data using IN Operator.mp4

08:39

15. Query data using LIKE Operator.mp4

10:59

16. Query data using UNION Operator.mp4

08:05

3. Analysing Multiple Tables with Joins

1. What are Table Joins.html

2. Analysing data with INNER JOIN.mp4

11:57

3. Analysing data with LEFT JOIN.mp4

06:05

4. Analysing data with RIGHT JOIN.mp4

04:13

5. Analysing data with SELF JOIN.mp4

08:07

4. Analysing Data with Aggregate Functions

1. What are Aggregate Functions.mp4

02:05

2. Query data using AVG Aggregate Function.mp4

03:29

3. Query data using COUNT Aggregate Function.mp4

08:49

4. Query data using SUM Aggregate Function.mp4

04:22

5. Query data using MIN Aggregate Function.mp4

02:25

6. Query data using MAX Aggregate Function.mp4

02:48

5. Python and Jupyter Notebook Setup

1. What is Python.mp4

05:16

2. What is Jupyter NoteBook.mp4

01:20

3. Installing Jupyter Notebook Server.mp4

06:45

4. Running Jupyter Notebook Server.mp4

08:44

5. Some Jupyter Notebook Commands.mp4

07:28

6. Jupyter Notebook components.mp4

04:26

7. Jupyter Notebook Dashboard.mp4

04:20

8. Jupyter Notebook Interface.mp4

05:44

9. Create a Jupyter Notebook.mp4

06:45

6. Data Analysis using Python

1. Kaggle Datasets.mp4

03:06

2.1 us_baby_names.zip

2. Tabular Data.mp4

08:00

3. Exploring Pandas DataFrame.mp4

02:20

4. Analysing and manipulating Pandas DataFrame.mp4

12:57

5. What is Data Cleaning.mp4

03:28

6.1 crime_boston.zip

6. Performing Data Cleaning.mp4

22:42

7.1 listings.zip

7. Data Visualization.mp4

02:35

8. Visualizing qualitative data.mp4

12:00

9. Visualizing quantitative data.mp4

13:49

Description

Hands-on Data Analysis & Visualization with SQL and Python

What You'll Learn?

Write SQL queries to explore and analyse databases with MySQL Workbench
Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
Analyse data across multiple tables with MySQL JOIN statements
Analyse data and perform calculations using aggregate function
Analyse data using subqueries
Analyse data using various functions
Analyse data using various Operators
Analyse and manipulate data using Python & Pandas
Perform data cleaning with Python
Visualize data with Python

Who is this for?

Data Analysts

Business Intelligence Analyst

Data Scientist

More details

Description
SQL stands for Structured Query Language. SQL lets you access and manipulate databases.
SQL can execute queries against a database. SQL can retrieve data from a database.
Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
MySQL is an open-source relational database management system. MySQL is currently owned by Oracle and MySQL is free and open-sourced under the terms of the GNU General Public License and available under a variety of proprietary licenses.
MySQL isÂ used by many database-driven web applications such as Drupal, Joomla, and WordPress.
You will learn how to write queries in SQL (specifically MySQL) that will allow us to access the data inside a database.

What is Python? Python is a computer programming language often used to build websites and software, automate tasks, and conduct data analysis.
Pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool,
built on top of the Python programming language.
In this course we will query, analyse and retrieve data from a MySQL Database using SQL and also analyse and manipulate pandas data frame withÂ Python and also visualize data. We will also be performing some data cleaning using Python.

Who this course is for:
Data Analysts
Business Intelligence Analyst
Data Scientist

User Reviews

Rating

average 0

Total votes0

Focused display

Digital learning academy produces bespoke elearning which helps you to effectively gain useful and marketable skills and knowledge . We work closely with you to map out exactly what you want to bring about and discover what you want to learn and achieve. We can help you learn something completely new? Working together, we can help you acquire some useful digital skills online. Our instructors are industry experts and have years of experience to deliver the training and skills you need.

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.