• MySQL count()
• MySQL sum()
• MySQL avg()
• MySQL min()
• MySQL max()

MySQL JOIN

DATA PRE-PROCESSING/WRANGLING

• Fundamentals of NumPy
• Types of arrays in NumPy
      Ones
      Empty
      Zeros
      Create Random Array
• Reshaping of the array
       1-D to 2-D array
       2-D to 3-D array
       3-D to 1-D array
• Arithmetic operations on  Array
       Addition
       Subtraction
       Multiplication
       Exponential
• Slicing of the array
      How to slice array
      Change in properties during slicing
• Transpose of a matrix
      How to take transpose
      Rows and columns  while taking transpose
• Dot product of the matrix
     How to take Dot product of the Matrix

• Data Frame
       What is Pandas Dataframe
       Different ways to create a Dataframe
      Read data from different sources and convert them to the Dataframe.
• Pandas Series
      What is panda Series
      How to create a Panda Series.
• Data inspection
       Using Count, info, head, tail.
       Using Shape, describe, unique, value etc
• Data Slicing
      Data Slicing loc and iloc
• Dataframe operations
       How to create a column or row
      How to delete a column or row
  Operations on Rows and Columns
• Arithmetic operations on rows and
  columns
• Handle Duplicate value and Null value
• Handle outlier data
• Group by Operations
• Data Reshaping
• Merging, Joining ,concatenation and
  append
• Time series

• Matplotlib for 3-D visualization
• Bar, Pie, line, histogram
• Countplot, boxplot, heatmap

• Scikit models
• Preprocessing using Scikit learn
• Classification using Scikit-learn
• Clustering using Scikit-learn
• Regression using Scikit-learn

• Scalar and vector
• Introduction to linear algebra
• Measure of central tendency mean
• Measure of central tendency mode
• Measure of central tendency mode
• Variance
• Standard deviation
  Measure of shape skewness
  Measure of shape kurtosis
  Covariance and correlation

• Importance of probability
• Discrete and continuous variable
• Bayes Theorem
• Central Limit theorem
• Normal Distribution
• Bernoulli distribution
• Uniform Distribution

• Hypothesis testing and mechanism
• Confidence interval
• Margin of Errors
• Confidence levels
• T test and P values using python
• Z test and P values using python
• Chi Squared Distribution using python

• Types of variables
• Types of Linear variables
• Mathematics Behind it
• Implementation of the model
• Testing and Check
• Performance of the model
• Assumptions of the Linear Regression

• Need of polynomial Regression
• Types of Variables in the Polynomial regression
• Mathematics behind it
• Implementation of the model
• Testing and check performance of the
  model

• Need of multiple Regression
• Mathematics behind it
• Implementation of the model
• Testing and check performance of the model

• Why to use random Forest
• Assumptions in random Forest
• Working and Implementation of the Model
• Data Pre-processing in Random Forest

• Types of SVM
• Implementation of the SVM
• Creating confusion matrix

• Bayes Theoram
• Implementation of Naïve Bayes
  Classifier
• Type of Naïve Bayes Model

Event listeners and handlers
Mouse events
Keyboard events

Accessing and manipulating HTML elements
DOM navigation and manipulation
Creating and removing HTML elements

What is React.js?
History and evolution of React.js
React.js components and their role in
building web applications
Setting up the development environment

Introduction to JSX
Basic syntax and rules of JSX
Embedding expressions in JSX
Conditional rendering in JSX
Working with lists in JSX

Understanding components
Creating class components
Creating functional components
Props and state in React components
Lifecycle methods in React components

Handling events in React
Binding event handlers in React
Passing data to event handlers in React
Conditional rendering based on events in
React

Creating forms in React
Handling form submission in React
Controlled and uncontrolled components
in React

Introduction to React Router
Setting up routing in React
Creating routes in React

What is MongoDB?
Advantages of MongoDB over RDBMS
MongoDB data model and architecture
Setting up the development environment

Creating and inserting documents in
MongoDB
Reading documents from MongoDB
Updating documents in MongoDB
Deleting documents from MongoDB

Querying MongoDB using find() method
Querying MongoDB using comparison and
logical operators
Querying MongoDB using regular
expressions
Querying MongoDB using aggregation
framework

What is Node.js?
Advantages of Node.js over other serverside technologies
Node.js architecture and event-driven
programming model
Setting up the development environment

Introduction to Node.js modules
Creating and using built-in modules
Creating and using custom modules
Working with NPM (Node Package
Manager)

Creating HTTP server in Node.js
Understanding HTTP methods and status
codes
Handling HTTP requests and responses
Serving static files in Node.js

Introduction to Express.js framework
Creating and configuring Express.js
application
Handling HTTP requests and responses in
Express.js
Implementing middleware in Express.js

Introduction to database connectivity in
Node.js
Connecting to MongoDB database in
Node.js
Performing CRUD operations in Node.js
using MongoDB
Using Mongoose ORM with MongoDB in
Node.js

Introduction to security in Node.js
Understanding and implementing
authentication and authorization in
Node.js
Implementing HTTPS in Node.js
Preventing common security vulnerabilities
in Node.js

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.