Types of Data-Types | None & Numeric

Introduction to Strings | Sequences | Constants | Literals | Reserved words

Operators | Arithmetic | Assignment | Relational | Membership | Identity

Bitwise | Logical | Operator Precedence

Input/Output Statements | Control Statements | if/else

Loops | for & while

Nested Statement

Break | Pass | Continue | Assert

Patterns In Python

Advanced Patterns

Introduction | Reverse | Slicing | Membership in String | Comparison

Advanced String

List | Creating list using range() | Update | Del | Remove | Repetition | Membership | Cloning

All List Methods

Project Using All 12 List Methods

Tuple

Introduction to Dictionary | Methods

Advanced Dictionary

Practice Questions

Functions | Return Statement

4 Properties of Functions

Types of Arguments | Local VS Global Variables

Generators & Decorators

Modules | Packages | Libraries

Functional Programming | OOPs Introduction

Objects & Classes | Attributes | Methods | Constructor

Inheritance

All types of inheritance

Properties of OOPs

Exceptions

Exception Handling Advanced

File Handling

Calendar Module

Thread | Process | 3 Steps to create thread

Advanced Threading

Prerequisites for DSA

Prerequisite for DSA Part 2

Prerequisites DSA Part 3

Prerequisites DSA Part 4

Pre-requisites DSA Part 5

Prerequisites DSA Part 6

Prerequisite DSA Part 7

Introduction to Data Structure and Algorithm

Insertion in Singly List Without test Case

Insertion In Singly Linked List With Test Case

Deletion In Singly Linked List

Doubly Linked List

Doubly Linked List Part 2

Circular Singly Linked List

Circular Doubly Linked List

Header Linked List

Hackerrank Setup & Practice

Linked List Practice Set

Stack using list and linked list

Multistack Datastructure

Queue using list and linked list

Circular + Double Ended Queue

Introduction To Binary Tree Data Structure

Operations In Binary Tree

Complete and Perfect Binary Tree

Binary Search Tree Part 1

Binary Search Tree Part 2

AVL Tree Part 1

AVL Tree Part 2

Graph Data Structure Part 1

Graph Data Structure Part 1

BFS and DFS In Graph

Add and Remove Edges and Vertices in Graph

Greedy Algorithm Part 1

Greedy Algorithm Part 2

Greedy Algorithm Part 3

Heap Data Structure Part 1

Heap Data Structure Part 2

Sorting Algorithm

Divide And Conquer Algorithm

Non Comparing Algorithm

Hashing Data Structure

Hashing Data Structure Part 2

Dynamic Programming

MYSQL Lecture 1

My SQL Lecture 2

MYSQL Lecture 3

MYSQL Lecture 4

MYSQL Lecture 5

MYSQL Lecture 6

MYSQL Lecture 7

MYSQL Lecture 8

MYSQL Lecture 9

MYSQL Lecture 10

MYSQL Lecture 11 Final Project

Introduction to the Module

Python Refresher-Lists

Numpy Arrays vs Lists, Importing of Numpy Array,Ndim and Shape

Numpy Arrays- 2D, 3D, Shape, Arange, Type Conversion, Dtypes

Aggregation in Numpy Array for 1d and 2d Array

Sort and Argsort in Numpy Array

Case Study- Net Promoter Score on Numpy

Sorting and Multiplication in 2d and 1d Arrays

Case Study- Fitbit Health Data Analysis

Introduction to Pandas and Comparison with Numpy

Introduction to Pandas and Comparison with Numpy Part 2

Mckinsey Case Study- Data Statistics, Mean, Renaming, Value Counts, Unique and Nunique and Series

Indices and Inplace Usage in Pandas Dataframe

loc and iloc, Drop , Set Index, in Pandas Dataframe

Reset Index, Concat, Drop Duplicates in Pandas Dataframe

Merge, Type of Joins in Pandas Dataframe

Concat vs Merge and Netflix Dataset Case Study

Unpivot, None vs Nan, Date Time Functions, Save a csv file and Drugs Data Case Study

Introduction to Data Visulization, Matplotlib vs Seaborn

Introduction to SQL and RDBMS

Primary Key vs Foreign Key vs Unique Key, Relationship in SQL

First Step in Writing the SQL query, Datatypes in SQL

Type of SQL Commands, Relationships in SQL

Filtering using Where (and, or), Order By in SQL

LIKE, IN, Concat, Round, Derived Functions, Case Statements in SQL Part-1

Derived Functions, Case Statements in SQL Part-2

Is Null, Null vs Blank, Subqueries in SQL

Group by, Count, Sum,Avg , Order of Executions of Functions in SQL

Aggregation Functions- Min and Max, Having clause in SQL

Interview level Questions on Agggregation Functions

Joins-Need of Joins, Left, Right and Inner Joins

Joins- Duplicate, Null and Blank Records Concept and Interview Questions

SQL Questions on Joins, Self Join, Cross Join combined with Aggregation Statements

SQL Joins Interview Questions-Part-3

Window Functions-Part-1

Window Functions-Part-2

Pivot, Lead, Lag, Cummulative, Union vs Union all, Date and Time Functions

CTE Functions, Subqueries,Interview Level Questions on Joins

Lecture-1 Introduction to Data Analytics Module

Lecture-2 Case Study-Cars 24 Part-1