+ View more
Course overview
Python & MySQL are great tools to take your Data Analysis skill-set to the NEXT LEVEL. Build project portfolios that will make you stand out from the crowd.
In the next couple of years, Data Analysis is going to remain in demand, and this means more opportunities for you.
In Data Analysis, it's your Portfolio that will speak for you.
Data Analytics and Visualization is a broad and interesting field with various tools and softwares', but having the knowledge of Python and MySQL in your skillset is critical to your success in the industry.
This comprehensive video course has been designed to help you in your journey to becoming a competent Data Analyst/Data Scientist who would be valuable to companies/businesses both at home and abroad.
It takes you from learning all about;
Database management with MySQL to
Basics of Python programming to
Performing Data Analysis and presenting great insights with appealing Dashboards.
This course comprises of Comprehensive video tutorials, Necessary tools like MySQL, Anaconda, Jupyter etc. Practice exercise files, and continuous mentorship.
It’s going to be a long journey of learning, unlearning, and re-learning. We are going to move together.
Once, you purchase this course, you will automatically have access to the step-by-step video tutorials, softwares, practice exercise files, and projects.
So first, you would need to watch the video lessons and practice along-side.
So let’s journey on, click the Start Course button above to purchase the course and get started.
What will i learn?
- Understanding SQL & Database structure
- Importing Database
- Running SQL querries on tables
- Data Integrity & Database Normalization
- Comparison, Logical & Mathematical Operators
- Inner Join, Outer Join, Right Outer Join
- Data types
- Intergers in Jupyter notebook
- Python Strings & Operations in Jupyterbook
- Python Intergers
- Python Lists
- Python Turple
Requirements
- A basic computer
- No prior knowledge required
Curriculum for this course
42 Lessons
00:00:00 Hours
MODULE 1 - Introduction and MySQL Installation
3 Lessons
00:00:00 Hours
-
Download MySQL
.
-
Install MySQL
.
-
Import Database
.
MODULE 2 - MySQL Class Starts
5 Lessons
00:00:00 Hours
-
Understanding SQL
.
-
Understanding Database Structure
.
-
Data Integrity
.
-
Database Normalization
.
-
Types of RDMS
.
MODULE 3 - MySQL Class Continues
6 Lessons
00:00:00 Hours
-
Querry a Single Table in Database
.
-
Running SQL Querries on a Single Table
.
-
Using the LIMIT and WHERE clause
.
-
Comparison Operators
.
-
Logical Operators
.
-
Mathematical Operators
.
MODULE 4 - MySQL Class Continues-2
5 Lessons
00:00:00 Hours
-
Querrying Multiple Tables
.
-
Inner join
.
-
Outer Join
.
-
Right Outer Join
.
-
Inner Join vs. Outer Join
.
MODULE 5 - Python Class Starts
7 Lessons
00:00:00 Hours
-
Introduction to Python
.
-
Data Types
.
-
Integers in Jupyter Notebook
.
-
Python Strings
.
-
Python Strings Operations in Jupyter book
.
-
Python Intergers
.
-
String Operation in Python
.
MODULE 6 - Python Class Continues
6 Lessons
00:00:00 Hours
-
Python List
.
-
Python Turple
.
-
Python List in Jupyter Notebook
.
-
Turple in Python
.
-
Operations in Python Turple
.
-
Operations in Python List
.
MODULE 7 - Python Class Continues-2
6 Lessons
00:00:00 Hours
-
Control Structure
.
-
Conditionals
.
-
Loops
.
-
The Control Structure in Python
.
-
Function and Function Types
.
-
Applications of Functions in Data Analytics
.
MODULE 8 - CODES
3 Lessons
00:00:00 Hours
-
Dataframe part -1
.
-
Introduction to Python Object Loading
.
-
Univariate Analysis
.
MODULE 9 - Assignments/Projects
1 Lessons
00:00:00 Hours
-
Assignment/Project
.
Frequently asked question
Do I need a computer?
Yes! you need a computer for effective practicing.
What is the course made up of?
✅ Step-by-step video lessons, ✅ Practice exercise files, ✅ Neccesary software s' like MySQL, Anaconda, Jupyter, etc, and their Installation Guide, ✅ Lifetime Mentorship, ✅ Certificate.
+ View more
Other related courses
00:00:00 Hours
Updated Fri, 26-Jan-2024
42
₦30000
₦5000
About instructor
Pegon Academy
Digital Courses
Student feedback
Reviews
-
Gotau Israelcool
Write a public review