DATA SCIENCE

Syllabus

DATA SCIENCE SYLLABUS

WHAT YOU WILL LEARN IN DATA SCIENCE – ML AND AI

Data Science Mathematics – Revising School Level Math
Python Programming Language
Python Data Science Libraries
Data Science Techniques
Basic Of Artificial Intelligence
Machine Learning
Data Visualization Tools
Deep Learning

DATA SCIENCE INTRODUCTION – MODULE I

Data Science and It’s Concepts
Scope Of Data Science
Data Science Business and Business Intelligence (BI) Use Cases
Data Science Field Discussions
Data Science Artificial Intelligence (AI) and AI Subset Machine Learning (ML) and ML Subset Deep Learning (DL) Involvements
Analytics – Introduction
Understanding Data, Types Of Data
Understanding Dataset – Structured, Unstructured and Semi Structured

DATA SCIENCE PROGRAMMING LANGUAGE (PYTHON)– MODULE II

Python – Introduction and installation
Python – Setup and Interpreter
Python – Keywords, Statements and Statements Syntax
Python – Variables, Literals, Data Types and Data Structure
Python – Operators
Python – Functions
Python – Input and Output (IO)
Python – Errors and Exceptions
Python – Modules
Python – classes
Python – Threading and Multi-threading
Python – Batteries
Python – Package Management Tools: pip and conda
Python – Virtual Environments

DATABASES MODULE- III

Structure Query Language (SQL)
SQL – Introduction
SQL – Data Definition Language(DDL)
SQL – DDL Operations – create tables or views, alter tables or views etc.
SQL – Data Manipulation Language(DML)
SQL – DML Operations – insert, update and delete etc.
SQL – Select
SQL – Constraints
SQL – Normalizations
SQL – Joins and indexes

DATA SCIENCE LIBRARIES: Numpy, Pandas, Scipy, Scikit-learn, Matplotlib MODULE -IV

Introduction to Anaconda/Jupyter Notebook

Numpy:

Introduction to numpy
Difference between Python Lists and Numpy
Creating arrays
Using arrays and Scalars
Indexing Arrays
Array Random functions
Array Search,Sort
Array Filter
Array Input and Output
Exercise on Numpy

Pandas:

Introduction to pandas?
Where it is used?
Index objects
Data Structure of Pandas
Reindex
Drop Entry
Selecting Entries
Data Alignment
Rank and Sort
Loc and iloc indexing
Summary Statics
Handling Missing Data
Index Hierarchy
Exercise on Pandas

Matplotlib: Data Visualization

Introduction of Data Visualization
Introduction to Matplotlib
Types of plots in Matplotlib
3D plotting with Matplotlib
Basic and Specialized Visualization Tools

Scikit-learn

Machine learning Process Flow
Feature selection and extraction in machine learning

PROBABILITY AND STATISTICS MODULE – V

Probability, Mean, Median, SD, Variance
Probability distributions, Poisson distribution, Binomial distribution

ARTIFICAL INTELLIGENCE AND MACHINE LEARNING (ML) – MODULE VI

What is Machine Learning (ML)?
Introducing Supervised ML
Introducing Unsupervised ML
Introducing Reinforcement Or Semi Supervised ML
Supervised ML Algorithms (Regression and Classification)
Unsupervised ML Algorithms (Association and Clustering)
Reinforcement ML Algorithms

MACHINE LEARNING Algorithms – MODULE VII

Linear Regression
Polynomial Regression
Multinomial Regression
Train/Test method
KNN
K Means
Logistic Regression
Support Vector Machine 2.5.6
Decision Tree
Naïve Bayes
Ensemble Methods – Random Forest, Boosting and Optimization
Clustering and PCA
Recommendation system
Time Series Analysis

Deep Learning – MODULE VIII

Introduction to Deep Learning
Importance of Deep Learning
Types of Deep Learning
Introduction to Tensor flow & Keras
Artificial Neural Network
Convolutional Neural Network
Recurrent Neural Network
Introduction to Computer Vision, Open CV library
Recurrent Neural Network
Introduction to Natural Language Processing
Using Regex in NLP
Category of Techniques for NLP
Spacy vs NLTK
Tokenization in Spacy
Stemming and Lemmatization
Name Entity Recognition

Developing GUI Application Using WINFORMS

Basic Controls
Panel & Layouts
Drawing and GDI Devices
MenuStrip, ToolbarStrip and ContextMenuStrip
Model and Modeless Dialog boxes
Mutiple Document Interface( MDI)
Form Inheritance
Building Login Form
Working with Resource Files and Setting
Notify Icon Controls
Using Components like Timer, FileSystemWatcher, Process, BackgroundWorker
Drag and Drop
Working with Advanced Controls like TreeView and ListView

Database Programming Using ADO.NET

Prerequisite – Knowledge of SQL Queries
Introduction and Evolution of ADO.NET
Understanding the Role of Managed Provider and ADO.NET Objects
installing Required Software – Sql Server and Management studio
Connecting to Database and Connection Pooling
Performing Insert, Update and Delete Operations
Fetching Data from database – Executing Select Statements
How to implement Login facility with database
Use of Multiple Active Result Sets
Parameterized Prepared Statements
Inserting Image into Database table
Executing Stored Procedure
Using Transaction
Asynchronous Execution of Queries
Writing Provider Independent Code
Writing Common Code for Execution of Stored Procedures
Quick Overview of all ADO.NET objects

Managing Data using DataSet

Introduction DataSet and its Object Model
Filling DataSet using DataAdapter
Binding DataSet to DataGridView
Updating changes to database using DataAdapter
Using SqlCommandBuilder
Managing DataTable Programmatically
DataAdapter events
Handling concurrency issue
Working with DataViews
Constraints in DataTable
Using DataRelations object
Creating DataSet/DataTable dynamically
Working with Typed DataSet
Summary and Important Classes and their properties and methods

N-Tier Layered Architecture Application

Understanding Tier and Layer
Dividing Application into multiple layers
Developing an application using Layered Architecture

Creating Table and Stored Procedure

b.Creating Data Class c.Creating DAL Class d.Creating BO Class

e.Creating Form and handlingevents

f.Creating Dialog Box for Add and Edit OPerations.

XML

Introduction
Well Formed and Valid XML Document
Structure of XML Document
XML DOM Parser
XPath Specification
XML and DataSet
XMLDataDocument for reading from DataSet
XMLTextWriter & XMLTextReader
XPathDocument & XPathNavigator

Windows Services

Introduction to Windows Service
Windows Service Project Template
Developing Windows Services
Installing, Deploying and Launching Windows Service
Developing a Service Controller Application
Handling Custom Commands in Windows Services

Delegates & Events

Introduction to Delegates
Creating a Chat Application Using Delegates
Events Declaration, Raising and Handling
Anonymous Methods

User Control and Custom Control Multithreading

Threading Overview
Scheduling
Thread States
Programming Threads
Methods of Thread Class
Thread Pool
Thread Synchronization
- Monitor
- Mutex
- Semaphore
- Events
Parallel Programming using Task Parallel Library
Asynchronous Programming using async and wait keywords

Packaging and Deployment

File System Editor
Registry Editor
File Types Editor
User Interface Editor
Custom Actions
Launch Condition Editor
Creating Uninstall Shortcut

Debugging and Diagnostics

What is Debugging?
Build Configuration(Debug and Release)
List of Debugging Windows
Break Point Hit Count and Condition
Debugging Exception
What is Diagnostics?
Debug and Trace Classes
Types of Listeners
Boolean and Trace Switch

ASP.NET Syllabus Web Programming Inroduction

Understanding role of Web Server and Web Browser.
Brief about HTTP Protocol.
HTTP Request structure.
Form Tag and comparison between Get and Post methods.
HTTP Response Structure.

HTML and JavaScript

Understanding HTML Form Tag and elements within it.
Javascript using Sample Programs.

Introduction to ASP

Introduction to ASP.
Types of Path.
Examples using Response object of ASP.
Working with FORM tag.
Important Points about the FORM submission.
Few more examples.
Problem with ASP.

ASP.NET Introduction & Sample Programs

How to create and run the first ASP.NET application.
Understanding the code generated by VS.NET.
Example Programs.
Understanding AutoPostBack.
Types of Server Controls

HTML controls.
Web Server Controls.

Exploring Server Controls.

Validation Controls

BaseValidator
ValidationSummary
RequiredFieldValidator
CompareValidator
RangeValidator
RegularExpressionValidator
CausesValidation Property of Button

Applying Themes and Styles to Controls

Working with CSS
Using Themes to Customize a Site
Named Skins within a Theme
Server-side Styles using Themes
Contents of a Theme and Skin
Themes and Profiles

ASP.NET Architecture

What is AppDomain
Life cycle of a WebForm when requested by a client.
How does a control manages its state
EnableViewState property
Event Handling in WebForms
Writing / Using Custom Classes in WebApplication

Page Navigation Options

Response.Redirect
Server.Transfer
CrossPagePostBack property of Button

Accessing controls of PreviousPage
Accessing Properties of PreviousPage
PreviousPageType page directive

Creating a Layout Using Master Pages

Why Master Pages.
Significance of ContentPlaceHolder Tag in MasterPage and Content Tag in WebForm.
How a control of MasterPage can be accessed / programmed in WebForm.

Master.FindControl
Public property in MasterPage and <%@MasterType directive in WebForm.

Load and LoadComplete events of the Page and MasterPage classes.
Understanding ClientID and UniqueID properties.

User Control

Creating a UserControl.
Adding a Usercontrol to the WebForm.
Register – Directive.
Loading UserControl Dynamically.
Usage of Page.ClientScript.RegisterClientScriptBlock Method

ASP.NET State Management

Need for state management
Static members in Webform
Global Class in App_Code folder
ViewState
HiddenField
QueryString
HttpContext
HttpCookie and Cookie Dictionary
HttpSessionState
HttpApplicationState

Databound Controls

Rendering Table o/p using SqlDataAdapter and SqlCommandReader
SqlDataSource
GridView
DetailsView
FormsView
DataList
Repeater
ListView