Course Topics

Introduction to SQL
Database Management and Filtering and Aggregations in SQL
Analysis using SQL Functions
Group by and Joins in SQL
Constraints
(Pre-requisites: NA) Advanced SQL Functions
SQL Subqueries
Window Functions
Advanced Features of SQL 1
Advanced Features of SQL 2
Data Manipulation using Adv. Basics of Excel
Excel Operators
Charts & Table
Functions
(Pre-requisites: NA) Advanced Excel -I
Advanced Excel -II
Data analytics using Google Sheets Basics
Googlesheets Report Making using Sheets
Data Validation
Statistics using Sheets
Data Visualization using PowerBI Power Query in Power BI
Advanced Functions in Power BI
Dashboarding in Excel / Power BI
Introduction to Python
Python Programming
Loops
Data Structures 1
Data Structures 2
(Pre-requisites: NA)
Functions
Modules & Packages
File Handling in Python
Advanced Python Concepts
Advanced Python Programming Introduction to Object Oriented Programming
(Pre-requisites: Python) Object methods
Decorators in Python
Classes and Object Methods
Advanced OOPs Concepts
Pyspark With Python DataFrames in Pyspark
(Pre-requisites: Python) Functions and Mlib
Databrics
Flask with Python Web Development using Flask
(Pre-requisites: Python) Web Frameworks in Flask
Introduction to Numpy
EDA using Python
Datatypes in Pandas
CSV Reading using Pandas
File Handling using Pandas
(Pre-requisites: Python)
Data Visualisation using Python
Bivariate Analysis
Univariate Analysis
Duration: 24 Hrs
Data Cleaning
 Advanced Mathematics Calculus
(Pre-requisites: Basic Linear Algebra
Mathematics) Logarithms
Polynomial Functions
Probability
Distance Metrics
Probability Permutations and Combinations
(Pre-requisites: Basic Conditional Probability
Mathematics) Random Variables
Applied Statistics Matrices and Statistics
(Pre-requisites: Basic Univariate Analysis
Mathematics) Statistical Distributions
Applied Statistics using EDA
Guesstimates 1
Guesstimates 2
Business Skills Case Studies 1
(Pre - requisities: NA) Case Studies 2
Case Studies 3
Case Studies 4
Case Studies 5
Introduction to Linear Regression
Linear Regression Deep Dive
Machine Learning - Supervised Polynomial Regression
Learning Logistic Regression
(Pre-requisites: Python) Logistic Regression Deep Dive
Naive Bayes
Naive Bayes Deep Dive
KNN
Support Vector Machines
SVM Deep Dive
Machine Learning - Unsupervised Clustering
Learning K Means Clustering
(Pre-requisites: Python) Hierarchical Clustering
Principal Component Analysis (PCA)
t-Distributed Stochastic Neighbor Embedding (t-SNE)
Ensemble Techniques Decision Trees Part 1
(Pre-requisites: Python) Decision Trees Part 2
Bagging
Random Forest
Boosting
Feature Engineering & Feature Feature Engineering
Selection Feature Selection
Deep Learning Neural Networks
(Pre-requisites: ML) Optimising Neural Networks
TensorFlow & Keras
Building Blocks of Neural Networks
Babysitting the Neural Networks
Introduction to NLP
Text Preprocessing
Language Modeling
 Named Entity Recognition (NER)
Part-of-Speech (POS) Tagging
Sentiment Analysis
Text Classification
NLP Topic Modeling
(Natural Language Processing) Named Entity Linking (NEL)
(Pre-requisites: ML) Machine Translation
Dependency Parsing
Text Summarization
Named Entity Recognition (NER)
Document Classification
Coreference Resolution
Relation Extraction
Text Generation
Information Retrieval
Speech Recognition
Chatbots and Conversational Agents
Ethical and Social Implications of NLP
Future Directions in NLP
Introduction to Computer Vision
Computer Vision
Image Processing & Feature Extraction
(Pre-requisites: ML)
Image Classification & Object Detection
Image Segmentation & Instance Segmentation
Object Tracking & Pose Estimation
Image Generation & Image Captioning
Image Registration & Image Stitching
Ethical and Future Considerations
AWS SageMaker For Machine
Learning, Deep Learning & NLP
(Pre-requisites: ML,DL,NLP)

Build,Train,Deploy Machine Learning, Deep Learning & NLP Models