Tutors

Innomatics Research Labs

PROGRAM OVERVIEW

CURRICULUM

  Welcome to the Course

  • Discord Innomatics Server Community Link
  • Zoom Mentoring Sessions Link

  Python Programming

  • Jupyter Note and Basic Programming File
  • week1_class_file
  • Strings
  • Lists
  • Tuples and sets
  • Dictionary File
  • Conditional statements
  • Loops File
  • Functions File
  • File Handling File
  • Exceptional Handling
  • OOPs File

  Data Analysis - Python

  • Numpy Class File
  • Numpy Files
  • Data Frame File
  • Loan Dataset
  • Basic Understanding File
  • Pandas - Subsetting File
  • Pandas - Groupby Crosstab File
  • Visualization Files
  • Pandas - Merge and Pivot Table
  • Pandas - Missing Value and Data Time Fil e
  • EDA Use case - COVID and Loan Files
  • Datasets Files
  • EDA - Seaborn Class File
  • Pandas - Advanced Lambda and Measure of Dispersion Class File
  • Regular Expression Class File
  • Regex by Ram
  • Web Scraping part - I
  • Web Scraping part - 2

  Assignments

  • Variables and Datatypes
  • Strings
  • List and Tuples
  • Sets
  • Dictionary
  • Conditional Statements and Loops
  • Functions
  • Python - Class and Object
  • Python - Numpy
  • Data Analysis - Pandas
  • Tableau Assignment - 1
  • Tableau Assignment - 2
  • Tableau - Assignment - 3
  • Tableau: - Assignment - 4
  • Statistics - Descriptive Statistics & EDA Assignment
  • Statistics: - Hypothesis Testing Assignment
  • SQL Assignment - I
  • SQL Assignment - II

  Projects

  • Web Scraping With EDA
  • Web Scraping Project Documentation
  • Sample PPT Template
  • Web Scraping Project Final Submissions
  • Portfolio
  • Telephone Directory Using Flask
  • CRUD Operations using Flask

  Statistics

  • Intro to Statistics
  • Sampling Techniques and Data and its measures
  • Intro to Statistics and Data its Measures PDF
  • Descriptive Statistics - Part 1 Lab
  • 18th July Descriptive Statistics - Part 1 Lab
  • Descriptive Statistics - Part 2 Lab
  • 19th July Descriptive Statistics - Part 2 Lab
  • Probability
  • Probability - II
  • 21st July Probability Lab
  • Bayes Theorem Class PDF
  • Probability + Random Variables + Probability Distributions PDF
  • Probability Distribution
  • Probability Distribution - Part 2 Normal Distribution
  • CLT
  • 27th july Probability Distributions and CLT Lab File
  • Hypothesis Testing - I
  • 28th July Hypothesis Testing - Part 1 File
  • Hypothesis Testing - II
  • Hypothesis Testing - III
  • Chisquared and anaova files
  • Hypothesis Testing - II

  Tableau

  • Introduction to Tableau and Desktop Tableau Data Types
  • tableau_intro and data types PDF
  • Sorting Files Types Grouping Data Relationship Filters
  • Class 1 & 2 Files
  • Calculated Fields Tableau Calculation Logical Functions Shapes Font Shading functionalities
  • Number & String Functions Actions on Worksheets Dual axis Models and Forecasting
  • Reference Line & band Clustering Filters at Worksheet level Dash Board making and Story boards
  • July-11-15th Lab Files
  • Special chart and Creating COVID dashboard

  SQL

  • Introduction to SQL and RDMS
  • DDL - Create Table Datatypes and constraints
  • DDL - II
  • DDL Commands Files
  • DML and DDL Commands Files
  • DML Commands
  • Class Task - 1
  • SQL Revision
  • 8th Aug aggregation function and group by
  • 9th Aug - string operations
  • Joins
  • Joins - II
  • 12th Aug
  • Window Function

  Machine Learning

  • This section has no content published in it.

  Deep Learning

  • This section has no content published in it.

  Python Programming and Data Analysis - Video Recording

  • Basic programming Class File
  • Python Data Structure File
  • Conditional Statement File
  • Functions
  • Functions File
  • File handling and Date Time File
  • File handling and Date Time
  • File handling and Date Time_II & Introduction to Numpy Arrays
  • Numpy_I
  • Numpy_II
  • Numpy_material
  • Numpy_3
  • Pandas Dataframes
  • Pandas Dataframes materail
  • Pandas dataframes II
  • Pandas and matplotlib and seaborn
  • Matplotlib and seaborn
  • Matplotlib and seaborn II
  • Matplotlib and seaborn III
  • Matplotlib and seaborn
  • Exploratory data analysis
  • EDA and Sales data csv file
  • EDA - I
  • EDA Materail
  • EDA-II
  • Descriptive statistics
  • Descriptive statastics_II and Handling missing values
  • Descriptive statistics and Missing values handling
  • Updated EDA File
  • Regular Expression
  • Regular Expression and Web Scraping - I Nakuri
  • Web Scraping - Naukari and klipkart
  • Web Scraping File - Nakuri
  • Web Scraping File - Flipkart
  • Regular expressions material
  • Web Scraping - flipchart - II
  • webscraping Flipkart III
  • Python Test Solving and Interview Question
  • Python Descriptive Interview Questions

  Placement and Interview Preparation Sections

  • Presentation Skills for Project /Interviews
  • Data Analysis Interview Preparation Session
  • Python Interview Session
  • SQL Interview Preparation
  • Window Function

  Application Development - Flask

  • HTML
  • HTML and CSS
  • HTML and CSS Video
  • Bootstrap
  • Introduction to Flask
  • Bootstrap and Introduction to Flask Video
  • Jinja Templating
  • Login Validation using Flask
  • Template Inheritance
  • How to call variable, Creating loops and conditional Statements in HTML Video
  • Jinja Templating and Form Validations Video
  • Database Connection Using Flask
  • Database connection with Flask Video

  Technical Assessment - MCQ's

  • Python Technical Assessment
  • Python Coding Questions

  SQL - New Videos

  • MySQL Workbench Installation Processor
  • MySQL_Installation Processor
  • 19th Jan - Intro to SQL and Databases
  • SQL Intro PDF
  • SQL 2 - DDL and DML Commands File
  • 20th Jan - DDL and DML Commands
  • 20th Jan - DDL and DML Commands
  • 23rd Jan - More on DDL & DML Commands
  • 24th Jan - MYSQL DATA MODEL
  • 24th Jan - Data Model File
  • 25th Jan - TCL and DATA QUERYING
  • TCL Querying File - 25th Jan
  • 24th Jan - Updated file
  • 27th Jan - GROUP BY, HAVING, UNION/ UNION ALL, ALIAS, JOINS
  • GROUP BY, HAVING, UNION/ UNION ALL, ALIAS, JOINS - 27th jan File
  • 30th Jan - JOINS AND TEMPORARY TABLES
  • JOINS AND TEMPORARY TABLES - 30th Jan File
  • 31st Jan - Aggregate Functions Comparison &Date & String Functions, Window Functions, Math Functions
  • 31st Jan File Data String window Functions
  • 1st Feb - Stored Procedures and Views connecting python to sql
  • storedprocedure File