Course Overview
Schedule of Classes
Course Curriculum
4 Subjects
EXL301 :Data Analysis with Excel
4 Exercises • 12 Learning Materials
Resources
EXL_301_Book
PDF
Class Notes
P2: Data Analysis with MS Excel
Audio
P3: Summarizing and Forecasting
Audio
P2: Data Analysis with MS Excel (Math Function)
Audio
P2: Data Analysis with MS Excel (Conditional Statement)
Audio
P3: Summarizing and Forecasting
Audio
P4: Macros and Dashboarding
Audio
Sample Superstore Database
Sample Superstore
Audio
L1: Unleashing the Power of Excel
L1_Excel_Learning Material
PDF
L1: Unleashing the Power of Excel (DPP)
Exercise
L2: Data Analysis with MS Excel
L2_Excel_Learning Material
PDF
L2: Data Analysis with MS Excel (DPP)
Exercise
L3: Summarizing and Forecasting
L3_Excel_Learning Material
PDF
L3: Summarizing and Forecasting (DPP)
Exercise
L4: Macros and Dashboarding
L4_Excel_Learning Material
PDF
L4: Macros and Dashboarding (DPP)
Exercise
SQL103 : Data Analysis with SQL
8 Exercises • 33 Learning Materials
Resources
SQL_103_Book
PDF
SQL_103_WorkBook
PDF
Lecture 1
PDF
Lecture 2
PDF
Lecture 3
PDF
Lecture 4
PDF
Lecture 5
PDF
Lecture 6
PDF
Lecture 7
PDF
Class Notes
L3: Data Filtering
ZIP
L4: Data Analysis using aggregate functions and group by
ZIP
L5: Joins and Keys
ZIP
L7: Object Oriented Programming
ZIP
Python Project
ZIP
Clauses of the MySQL
ZIP
Exception handling & L6: Regular Expressions
ZIP
L6: Regular Expressions
ZIP
L6: Subqueries and Views
ZIP
SQL Assignment
SQL Assignment
Assignment
Questions Assignment-2[SQL]
ZIP
L1: Introduction to SQL and Installation
L1_SQL_Learning Material
ZIP
L1 Introduction to SQL and MySQL installation (Daily Practice Problem)
Exercise
L1_SQL_DPP Solutions
application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess
L2: Data Creation and Retrieval
L2_SQL_Learning Material
ZIP
L2 Data Creation and Retrieval (Daily Practice Problem)
Exercise
L2_SQL_DPP Solutions
application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess
L3: Data Filtering
L3_SQL_Learning Material
ZIP
L3: Data Filtering (Daily Practice Problem)
Exercise
L3_SQL_DPP Solutions
application/vnd.openxmlformats-officedocument.wordprocessingml.documentapplication/vnd.openxmlformats-officedocument.wordprocess
L4: Data Analysis using aggregate functions and group by
L4_SQL_Learning Material
ZIP
L4: Data Analysis using aggregate functions and group by (Daily Practice Problem)
Exercise
L4_SQL_DPP Solutions
Audio
L5: Joins and Keys
L5_SQL_Learning Material
ZIP
L5: Joins and Keys (Daily Practice Problem)
Exercise
L5_SQL_DPP Solutions
Audio
L6: Subqueries and Views
L6_SQL_Learning Material
ZIP
L6: Subqueries and Views (Daily Practice Problems)
Exercise
L7: Window/Analytical Functions
L7_SQL_Learning Material
ZIP
L7: Object Oriented Programming (DPP)
Exercise
L7_DPP_Solutions
Audio
Databases
Databases
ZIP
PY201 : Python Fundamentals
8 Exercises • 25 Learning Materials
Resources
PY_201_Book
PDF
PY_201_WorkBook
PDF
Assignment
Assignment
Assignment
L1: Introduction to Python and Data Science
L1 Python Learning Material
ZIP
L1: Introduction to Python and Data Science (DPP)
Exercise
L1 DPP Solutions
Audio
L2: Working with Python Data Structures
L2_Python Learning Material
ZIP
L2: Working with Python Data Structures (DPP)
Exercise
L2_DPP_Solutions
Audio
L3: Control Flow Statements
L3_Python_Learning_Material
ZIP
L3: Control Flow Statements (DPP)
Exercise
L3_DPP_Solutions
Audio
L4: Functions in Python
L4_Python_Learning_Material
ZIP
L4: Functions in Python (DPP)
Exercise
L4_DPP_Solutions
Audio
L5: File Handling in Python
L5_Python_Learning_Material
ZIP
L5: Control Flow Statements (DPP)
Exercise
L5_DPP_Solutions
Audio
L6: Regular Expressions
L6_Python_Learning_Material
ZIP
L6: Regular Expressions (DPP)
Exercise
L6_DPP_Solutions
Audio
L7: Object Oriented Programming
L7_Python_Learning_Material
ZIP
L7: Object Oriented Programming (DPP)
Exercise
L7_DPP_Solutions
Audio
Class Notes [9AM]
L1 Introduction to Python and Data Science
ZIP
L2: Working with Python Data Structures[6/4/24]
ZIP
L2: Working with Python Data Structures[7/4/24]
ZIP
L2: Working with Python Data Structures[13/4/24]
ZIP
L3: Control Flow Statements[14/4/24]
ZIP
L3: Control Flow Statements[20/4/24]
ZIP
L4: Loops[21/4/24]
ZIP
L4: Loops-II[27/4/24]
ZIP
L4: Functions in Python I[28/4/24]
ZIP
SP101 : Statistics & Probablity
5 Exercises • 6 Learning Materials
Resources
SP101W-Workbook-ebook(DPP's)
PDF
SP101-Course Book
PDF
Stats_and_Probability_learning_material
PDF
Class Notes
Data Filtering
ZIP
L1: Introduction to Statistics
L1_Stats_Learning Material
ZIP
L1: Introduction to Statistics (DPP)
Exercise
L2: Probability Theory
L2: Probability Theory (DPP)
Exercise
L3: Sampling Theory
L3_Stats_Learning Material
ZIP
L3: Sampling Theory (DPP)
Exercise
L4: Statistical Inference I
L4: Statistical Inference I (DPP)
Exercise
L5: Statistical Inference II
L5: Statistical Inference II (DPP)
Exercise
Course Instructor
/2581423-DIG-X-SKILLARBI-BLUE-600x391-1.png)
Dataisgood
478 Courses • 210448 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy