
Discord Innomatics Server Community Link

Zoom Mentoring Sessions Link
Tutors
Innomatics Research Labs
PROGRAM OVERVIEW
CURRICULUM
Course Took Kit (Discord and Mentoring Link)
Python Programming

Ananconda Installation for Jupyter notebook IDE and Python

numerical_datatypes File

operators_python. File

Python Revision and Intro to List

List Operations

Sets File

List and Tuple File

Conditional Statement and Loops File

Functions File

Function Files

Class and Objects File

Anaconda Installation Google Colab and Jupyter notebook

Basic Programming  Part 1

Basic Programming  Part 2

Strings  Part 1

String  Part 2

List and Tuple  Part 1

List Tuple and Set  Part 2

Dictionary and Conditional Statement I

Conditional Statement  Part 2

Conditional Statement and Loops  Part 3

Functions  Part 1

Functions  Part 2

Modules and Problem Solving  Part 1

Problem Solving  Part 2

File Handling

Exceptional Handling and OOPS  Part 1

OOPs  Part 2
Data Analysis Using Python

Numpy  15th Nov

Numpy  Part 2 16th Nov

Numpy  III 17th Nov

Descriptive Stats  Data and Descriptive Stats PDF

Pandas Basics, Subsetting , Groupby pivot Files

pandas_pivot_merge 29th Nov

Regular Expressions

Web Scraping  I

Visualization and EDA File

Descriptive Statistics  I

Descriptive Statistics  II and Numpy

Numpy  II

Pandas  Series and DataFrame and Basic Operations

Indexing and Merge concatenation & Joins

Basic Cleaning and Filtering

Missing Data Handling

Grouping_and_Summarising and Lambda_Functions_Pivot_Tables

Regular Expression

Reg ex  II and Web Scraping

Web Scraping  III

Web Scraping  II

Visualization  Matplotlib

Visualization  Seaborn
Assignments

Python  Variables and Datatypes

Python  Strings

Python  List and Tuples

Python  Sets

Python  Dictionary

Python  Conditional Statements and Loops

Python  Functions

Python  Class and Object

Data Analysis  Numpy

Data Analysis  Pandas

Data Analysis  Visualization

SQL  Assignment 1

SQL  Assignment 2

Statistics Assignment
Projects

Web Scraping Project Final Submissions

Web Scraping Project Documentation

SQL Project Demonstration

SQL Project 

Excel  Dashboard Project

Tableau  DATA ANALYSIS PROJECT
SQL

MySQL Workbench Installation Processor

MySQL_Installation Processor

Day 1 & 2 Lab File on DDL Commands  CREATE, DROP & Data TYpes

SQL INTRODUCTION PDF

23rd Dec  DDL and DML Commands File

MYSQL  Datatypes File

26th Dec  DML Commands File

RetailDB_Class Code

27th Dec  Update Delete Filters Copy of table

28th Dec  OPERATORS ,GROUP BY ,FOREIGN KEY,TCL

29th Dec  Joins SubQuery ,Operator Aggregate and String & Math Function

30th Dec  windows functions, stored procedures and views case studies

30th Dec  Python Connection MySQL

SQL All Files along with Adv Topic and Revision PDF

SQL Lab  1

SQL Lab  2

SQL Lab  3

SQL Lab  4

SQL Lab  5 Joins Merges Concepts

SQL Lab  6

SQL Lab  7
Tableau

Introduction to visualization & Tools
Statistics

23rd Jan  Descriptive_stats File

24th Jan  Descriptive_stats_ File

Introduction to Descriptive Statistics

Measure of Dispersion

Correlation Correlation, Percentiles, Deciles, Quartiles, IQR, Population, Sample, Data Categories

25th jan  Covariance_Correlation

27th Jan  Probabbility_Theroy_RandomVariable File

30th Jan  Descrete Random Variables File

Importance of Probability, Introduction to Probability, Types of Probability

Revision of Probability, Conditional Probability, Bayes Theorem, Independent Events

random variables, Types of Random Variables , Bernouli , Binomial

Expected values, PDF, PMF, CDF, Uniform Distribution in continuous space and discrete space

Poisson and Exponential Distributions, Example problems

31st Jan  Poisson_Exponential Distributions File

2nd Feb Unifrom Distribution File

3rd Feb  Normal Distribution

6th Feb  Normal Distribution File

7th Feb  CLT File

Normal Distribution, Empirical Rules, How to Plot Normal Distribution

Standard Normal Distribution, Problems on Normal Distribution, Ztables, Transformations

Bootstrapping, Central Limit Theorem

8th Feb  Confidence Interval

CLT for Proportion Estimation of Population parameters point and Interval

Confidence Interval, Criterial Value Significance Level

Example on CI , T Distribution and Excel Lab

9th Feb  Confidence_Interval_Problems

10th Feb  T distribution, Python Implementation, Confidence Interval with T distribution

13th Feb  What is Hypothesis Testing, Null & Alternative, Apps of CLT in Hypothesis testing.

14th Feb  left & Right Tail and p value approch and evaluation

15th Feb  Hypothesis testing 1 sample testing, ztest, ttest.

Chebyshev's theorem, Bias, Introduction to Hypothesis testing, Null & Alternative Hypothesis

Hypothesis Testing  Part 2 Type 1 & 2 Errors

ZTest, Ttest, p value approach, p value calculation, Example Problems.

17th Feb Chisquare File

ZTest, Ttest, p value approach, p value calculation, Example Problems.

Python lab of hyp testing, Chi square dist, Chi square test for independence

Chi Sqaured and F Distribution & ANOVA

20th Feb  Chi Square File

21st Feb  F test and ANOVA

22nd Feb File
Machine Learning
 This section has no content published in it.
Deep Learning
 This section has no content published in it.
Test

Basic Python Test
Excel Module

1st Mar  Intro to Excel

2nd Mar  Conditional Formatting File

1st Mar  Introduction to Excel

2nd Mar  Conditional Statement

3rd Mar  Excel  Data Validation

conditional_formatting File

Intro to excel File

Data_validation File

6th Mar  Pivot Table

Pivot Table File

7th Mar  Dashboard

Dashboard File 7th march

9th Mar  VLOOKUP & HLOOKUP

VLOOKUP & HLOOKUP File

10th Mar  EXCEL MACROS

Macros File
Data Analysis Assessment

Python Data Analysis Assessment