DATA

SCIENCE
1
 INDEX

TOPICS PAGE NO.

1. PYTHON 3

2. VISUALIZATION 6

3. SQL 9

4. STATISTICS 12

5. MACHINE LEARNING 15

6. NODE JS. 18

2
Level 1:
Python

3
Adv. Python (Each Session 2hrs.)
Course Duration: 60Hrs with Project

Session1
History, features Setting up path, working with Python, Basic Syntax, Variable and Data
Types Operator.

Session2
Condition statement, Relational operator and logical operator, Simple If, If- else, If elif,
Nested if-else

Session3
What is Looping, For, While, Nested loops, control Statements, Break, continue, pass.

Session4
Math and Random, Number and Math, Basic Operations, Random, Function and Methods

Session5
String Manipulation, Accessing Strings, Basic Operations, String slices, Function and
Methods

Session6
Introduction List, Accessing list, Operations List, Working with lists, Function and Methods

Session7
Introduction tuple, List vs Tuple Accessing tuples, Operations Working Functions and
Methods

Session8
Introduction Dictionary, List vs Tuple vs Dictionary, Accessing values in dictionaries, working
with dictionaries, Properties Functions

Session9
Introduction set, Access the set item, add set item, remove set item, loop the set, join the
set and set pre define set method.

Session10
What is function, Defining a function, type of function (user define) Calling a function, local
and global variable, Anonymous functions (lambda function).

Session11

What is Module, benefit of module, Importing module, Math module, Random module,
Packages, Composition

Session12
Printing on screen, Reading data from keyboard, Opening and closing file Reading and
writing files Functions
4
Session13
Compile time and runtime Exception, Exception Handling, Exception Handling, except
clause, try? Finally clause, User Defined Exceptions

Session14
Class and object, Constructor, Parameterize and default constructor init method,
Overloading, Data hide

Session15
What is Inheritance, single Inheritance, Multilevel inheritance, Encapsulation,
polymorphism, Overriding

Session16
Regular expression, Match function, Search function, Matching VS Searching,
Modifiers Patterns

Session17
What is Database connectivity, Introduction Connections Executing queries Transactions
Handling error

Session18
Insert, update, delete, select, where clause and joining statement, limit data cursor, row
count

Session19
What is GUI, Library tkinter, place, pack and grid system, mainloop, explain with event,
draw line, rectangle, and circle.

Session20
Component, Label, Entry, Button, Radio, Checkbox, Combo Box, List, Menu Editor and
command, paddy, bg, fg, font size.

Session21

Data Visualization Library: Matplotlip | Setting the Axis, Ticks, Grids | Line Appearance| Using Labels,

Session22

Annotations and Legends, Seaborn, Plotting Data.

Session23

Data Manipulation in Python: Data Preprocessing | Missing Data Cleaning Data

Session24

Exploring Data Types, Normalizing And Standardizing Data | Data Modeling and Scaling.

Session25

Project based on python (12 Hours)

5
Numpy (Total Session 10 Hours)

Each Session 2 hours.

Session 1

What is numpy? Benefit of numpy, download numpy, PIP Install Numpy, What is Array and
terminology of Array in numpy.
Session 2

NumPy Array Creation of NumPy Arrays from List, tuple etc. Indexing of Array in 1D, 2D and 3D,
slicing in numpy
Session 3

Operations on Arrays, Arithmetic, Transpose and sorting in numpy, Concatenating Arrays in

Numpy.
Session 4

Reshaping Arrays in numpy, Reshaping in 1D, 2D and 3D, data type, dtype in numpy type,
Splitting Arrays with split method.
Session 5

Statistical Operations on Arrays, STD (), sum (), min (), max (), mean (), describe () in numpy
_______________________________________________________________________

Pandas (20 Hours)

Each Session 2 hours.

Session 1
What is Pandas? Use of Pandas, how to install pandas, pip install pandas in command prompt, import
pandas.

Session 2
What is Series and DataFrame, Dataframe terminology, shape, head, tail, column, and type? Operation
on Dataframe, set index.

Session 3
How to load csv and excel file in pandas Different way creating Dataframe using List, dictionary, and tuple
in pandas.

6
Session 4
Read and Write csv and Excel files in pandas, skiprows, header, nrows, rename of column, writing,
dataframe.to_csv (), to_excel ().

Session 5
Handling Mission Data, Fillna, interpolate, dropna, type, method ffill, bfill, and axis column, limit, method
time, dropna how all, inserting missing date.

Session 6
Handling Mission data –replace method, replacing single value, replace list with single value, replace per
column, replace list with another list.

Session 7
Pandas Group by, group by max (), group by min (), group by mean (), group by describe (), group by size
(), count ().

Session 8
Pandas Concatenate, concat (), concat with ignore index, concatenation and key, loc, concatenation using
index, concatenation dataframe and series.

Session 9
Merge in pandas, like join in database, merge with inner, outer, left, right and join method in pandas.

Session 10
Pivot in pandas, Pivot Table, Margins, Grouper, Reshape pandas dataframe using melt.

7
LEVEL 2:
VISUALIZATION

8
VISUALIZATION WITH TABLEAU (Total 30 Hours)
Each Session 2 hours
Session 1
Introduction: Data Types, Types of Graphs in Visualization, Basic Use-Case of Each Grap

Session 2
Data Visualization Tools: Excel, Python, R, Tableau, Qlik Power BI, D3 Is

Session 3
Tableau: - Introduction Installation of Tableau Tool Tour for User Data Loading and Handling Process
Connecting To Tableau from Different Database Tableau

Session 4
Data Joining and Blending In Tableau: Joining and Blending Of Data, Understanding How LEFT, RIGHT
INNER and Joins Work, Joins With Duplicate Values

Session 5
Joining On Multiple Fields Data Blending, Joining Data Vs Blending Data in Tableau, Creating Calculated
Fields in Blend.

Session 6
Advance Data Preparation: What Format Your Data Should Be? Data Interpreter, Pivot, Splitting Column
into Multiple Columns

Session 7
Bar Charts in Tableau: Tableau Basic: Your First Bar Chart Navigating Tableau | Creating Calculated Fields

Session 8
Adding Colors, Adding Labels And Formatting, Exporting Your Worksheet, Get Visualization And Insights.

Session 9
Line Chart in Tableau: Time Series, Aggregation and Filters Introduction | Working With Time Series

Session 10
Understanding Aggregation, Granularity and Level of Detail, Creating and Learning and Area Chart
Adding Filters

Session 11
Pie Chart in Tableau: Dealing with Pie Chart, Table Chart and Tree Graphs, Applying Filters Into Above
Charts Creating Table Calculations for Gender

Session 12
Map and Scatter Plots: Maps and Scatter Plots Creating a Map and Working with Hierarchies Creating a
Scatter Plot and Applying Filters, Dual Axis Chart

Session 13
Slicer In tableau, Creating Calculated Fields, KPI in tableau I, Table and Matrix table in tableau

9
Session 14
Dashboard: Creating Your First Dashboard (Applying Filters into Multiple Sheet Creating & Analyzing A
Customer Segmentation Dashboard (Advance Dash Board Interactivity | Creating A Storyline)

Session 15
Project Based on tableau

10
LEVEL 3:
SQL

11
SQL (Total Session 30 hours)
Each Session 2 hours.
Session 1
INTRODUCTION: What, Why and How of Dashboard, Types of Database, What Is SQL? What Is Data
Science? Why Is SQL Required For Data Science?

Session 2
Installation of My Sql: Architecture Client and Server Installation Connecting To the Data Base

Session 3
Basic of Sql: Explore Database Data Types in SQL Server, Types of Commands, DDL- Data Definition

Session 4
Sql Language – Creation /Updating/ Deletion of Schema |DML – DATA Manipulation

Session 5
SQL Vs No SQL: What, Why and How of No SQL Difference between Nosql

Session 6
Sql Language – Manipulating Data in Tables, insert, update, delete, Tables Creation Inserting into Tables.

Session 7
Select Statement, WHERE Clause NULL Vs NOT NULL, is null and is not Null, Order by, desc, asc.

Session 8
Modifying Database Structure alter table add column and drop column and rename table name

Session 9
Importing and Exporting Data: Import Data from CSV to Sql, Export Data from Sql to CSV Backup
Database, Restore Database.

Session 10
DATA ANALYTICS: What Is Data Analytics? Types of Analytics, Descriptive Analytics, Slicing and Dicing
Data, Sorting Data, Grouping Data

Session 11
Joining, Combining Multiple Tables, Introduction to Joins, Joins Vs Processing With Cube Types Of Joins

Session 12
Advance Sql Indexing | Introduction | Primary Key/Foreign | Key/Unique Constraint, default, check
12
Session 13
Built In Functions string function, date function, math function, Views create view and drop view

Session 14
Transaction control language, begin transaction, save points, Rollback, commit.

Session 15
Access and Privilege, Grant and revoke, unlimited tablespace, create user and drop user

13
 Level 4:
STATISTICS
14
STATISTICS (Total 16 Hours)
Each 2 Hours
Session 1
Introduction to Data science, what is Data Science? Application of Data Science Roles performed
by data scientist.

Session 2
Introduction to statistics what is Statistics? Importance of Statistics why Statistics for Data
Science

Session 3
Basic Statistical Concepts, Variable, population, sample, sampling, Simple Random Sampling,
Stratified Random Sampling

Session 4
Cluster Random Sampling, Types of Data Types of Analysis Categories in Statistics

Session 5
Introduction to probability and Distributions probability Theory, Conditional Probability Random
Variable, Probability Distributions

Session 6
Descriptive Statistics Measures of center, Measures of Spread

Session 7
Inferential Statistics Hypothesis Error, Confidence Levels Critical Region Level of Signification
Correlation Matrix

Session 8
Parametric test Types Z-test, t-test, ANOVA, one way, two way Non-Parametric test Chi-Square
Test

15
 Level 5:
Machine
Learning
( AI )
16
Machine Learning(Each Session 2 hours)
Total Session 60 Hours with Project
Introduction
Session 1

What is Artificial Intelligence (AI), Application of AI, What is Machine Learning?

Session 2

Relation between AI, ML, DL, Traditional vs Machine Learning?

Techniques of Machine Learning:

Session 3

What is Supervised Learning, Example of Supervised Learning, Regression, classification?

Session 4

What is Unsupervised Learning, Example of Unsupervised, clustering, Anomaly Detection, Reinforcement Learning

ML Model Building Recipe:

Session 5

What is Machine Learning Model, Steps of Machine Learning, and Business Problem?

Session 6

Data acquisition, exploratory data Analysis, Data Modelling, Prediction, Communication

Regression
Session 7

What is Linear Regression? Types of Regression, Linear Regression, and Multiple Regression

Session 8

What is Logistic regression? Algorithm of Logistic, Example of Logistic, implements of Logistic regression in python

Session 9

What is Polynomial Regression? Example of polynomial, implements of polynomial regression in python

Session 10

What is Decision Tree? Algorithm of tree, Example of polynomial, implements of Decision tree in python

Session 11

What is Random Forest? Algorithm of Random Forest, implements of Random Forest in python.

Session 12

Evaluation Metrics R-square, Adjusted R- Square, mean square error, root mean square Error.

17
Classification:
Session 13

What is Classification, Use cases, Linear Classification and Models,

Session 14

Support vector Machines (SVM), Non-Linear Classification Models, K-Nearest Neighbours (KNN),

Session 15

What is Navie Bayes? Algorithm of Navie Bayes? Example and implements of Navie Bayes in python.

Clustering:
Session 16

What is Clustering Use cases, Types, Exclusive, Overlapping, Hierarchical,

Session 17

What is K-means Clustering? Algorithm of K-Mean Clustering, Implements of K-Means in python

Model Improvement:
Session 18

Model Improvement Need of Improvement, Techniques, Cross Validation, K-Fold Cross Validation,

Session 19

Leave one out cross Validation, Hyper-parameter tuning using Grid Search Pipelines

Recommendation System:
Session 20

Application, Types, Content Based, Collaborative Filtering, Matrix Factorization, Evaluation Metrics of

Session 21

Recommendation System, Recall, Precision, Root Mean Square Error, Mean Average Precision at k(MAP at k)

Session 22

Artificial Neural Networks and Deep Learning

Session 23

Introduction: Perceptron, Activation Functions and Perceptron, Artificial neural Networks (ANN),

Session 24

Back propagation, Limitations of ANN, Towards Deep Learning

Session 25
Project Based on Machine and AI (12 Hours)

18