Professional Certification Program in DATA SCIENCE & A.I.

Course Instructor Dataisgood

FREE

Course Overview

Schedule of Classes

Start Date & End Date

Jun 14 2023 - Mar 01 2024

Course Curriculum

9 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

PY201 : Python Fundamentals

8 Exercises • 25 Learning Materials

Resources

PY_201_Book

PDF

PY_201_WorkBook

PDF

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

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

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

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

Preparatory Session

0 Exercises • 4 Learning Materials

preparatory session python

preparatory_session_python

PDF

preparatory_session_SQL

PDF

Induction Session

Dataisgood Induction - PPT

PDF

Class Notes

Python Preparatory Session

ZIP

PY 204 : Machine Learning

0 Exercises • 26 Learning Materials

Lecture 1: Modelling with Linear Regression

Simple Linear Regression

ZIP

Multiple Linear regression

ZIP

DPP

PPT

kc_house_data

Audio

Linear regression

PPT

Lecture 2: Regularisation Techniques

Regularization

ZIP

DPP

PDF

Lecture 3: Regularisation Techniques II

Regularization-2

ZIP

Regularization

PPT

practice questions regularization

PDF

Lecture 5: L5 Understanding other classification algorithm like KNN _ SVM

Understanding other classification algorithm like KNN _ SVM

PPT

Understanding other classification algorithm like KNN _ SVM

ZIP

DPP

PDF

Lecture 6: L6_ Advanced Model Evaluation Techniques

Evaluating Models _ Feature selection (classification _ Regression)

PPT

Evaluating models and feature selection sample code-3

ZIP

Naive bayes

PDF

DPP

PDF

Lecture7: Introduction to Clustering and K Means

Class 6 Introduction to Clustering and K Means

PDF

K-means

ZIP

DPP

PDF

Lecture 8: Advanced Clustering Techniques

Advanced Clustering Techniques

PDF

Hierarchical Clustering

ZIP

DPP

PDF

PY 202: Python For Data Science _ Data Viz (Pandas)

0 Exercises • 13 Learning Materials

Lecture1: Using Python Numpy Library

Practice Numpy Basic Operations Day-1

PDF

Practice Numpy Basic Operations Day-1

PDF

Basic Operations using Numpy.zip

ZIP

Lecture2: Linear Algebra and Numpy

Practice Linear Algebra and Numpy Operations - Day2

PDF

Linear Algebra using Numpy

ZIP

Lecture5: Extracting and Aggregating Pandas

Extracting and Aggregating using Pandas

ZIP

DPP

PDF

Lecture6: Matplotlib and seaborn

Matplotlib and Seaborn

PDF

Visualisation using Matplotlib and Seaborn

ZIP

DPP

PDF

Lecture 7: Plotly and Cuffinks

Plotly and Cufflinks

ZIP

Plotly and Cufflinks

PDF

Class Notes [6:30]

Project Session

PDF

PY 207 : Natural Language Processing

0 Exercises • 16 Learning Materials

Lecture 1: Introduction to NLP

Basic Text processing

ZIP

Introduction to NLP

PDF

Introduction to NLP

PPT

Sample_tweets

Audio

Lecture 2: Feature Engineering in NLP _ Text Classification

NLP Feature engineering

PPT

NLP Feature engineering

ZIP

POS_tagging

ZIP

DPP

PDF

Lecture 3: Advaced Data Cleaning for NLP text classification

Advanced Data Cleaning for NLP text classification

PPT

Advanced_Data_Cleaning_for_NLP_text_classification

ZIP

DPP

PDF

Lecture 4 : Feature Extraction and Feature Encoding for NLP

Feature Extraction Feature encoding for NLP

PPT

Feature Extraction Feature encoding for NLP

ZIP

DPP

PDF

Lecture 5: Introduction to Word Embeddings

DPP

PDF

Advanced word embeddings used to solve NLP problems

PPT

PY 208 : Deep Learning

0 Exercises • 27 Learning Materials

Lecture 1: Building blocks of Deep Learning

Day 1 content

PPT

Day 1 DPP

Audio

Lecture 2 : Understanding the components of Neural Networks

Day 2 content

PPT

DPP

Audio

Building first ANN- Day 2

ZIP

Lecture 3: Introduction to Recurrent Neural Networks

Week 2- Day 3 RNN

PPT

Week 2-Day 3 DPP

Audio

Implementation of RNN

ZIP

Lecture 4: Overview of LSTM and GRU

Week 2- Day 4 LSTM and GRU- Copy

PPT

Week 2-Day 4 DPP

Audio

Lecture 5: Introduction to Bidirectional Networks

Week 3- Day 5 Bidirectional Networks

PPT

Week 3- Day 5 DPP

Audio

Lecture 6: RNN Use Cases in the Industry

tatatest

Audio

NSE-TATAGLOBAL

Audio

Language Translation

ZIP

Stock Prices Prediction

ZIP

Lecture 7: Introduction to Convolutional Neural Networks (CNN)

Week 4- Day 7 Convolution Neural Networks

PPT

Week 4- Day 7 DPP

Audio

CNN Implementation on MNIST data

ZIP

Lecture 8: Overview of Transfer Learning

Week 4- Day 8 DPP

Audio

Transfer Learning

PDF

Lecture 9: Introduction to Transformers

Week 5- Day 9 Intro to Transformers

PPT

DPP

Audio

Implementation of Transformers

ZIP

Lecture 10: overview of Autoencoders

DPP

Audio

Week 5- Day 10 Overview of AutoEncoders

PPT

Implementation of Autoencoders

ZIP

Course Instructor

Dataisgood

478 Courses • 210448 Students