PG Diploma in Data Science and Machine Learning

Relational Database - SQL – 10 Days

Introduction to databases and RDBMS

Read, update and delete operations on tables. Working with nulls

Joins in SQL and working examples

SQL set based operations and data aggregation, Sub-queries in SQL

EBS(Elastic Block Storage),VPC

Database creation, concept of relation and working examples

Querying tables: Select statement, examples and its variations

Insert, Update, Delete operations and working examples

Normalization and de-normalization: Views and Temporary tables, Transactions in SQL

EBS volumes and Snapshots

Creating tables. Design view of the table, Alter table operations & Key Constraints

Filtering, Sorting, Predicates and working examples

Scalar functions in SQL and working examples

SQL programming, Creating stored procedures, Cursors in SQL

RDS

Python for Data Science - 10 Days

Advanced Python (Testing and Web scraping) –10 Days

Exploratory Data Analysis with Pandas- 10 Days

Exploratory Data Analysis with Pandas- 10 Days

Data Science Specialization:

Mathematics and Statistics for Data Science – 10 Days

Logarithm

Standard Deviation

Descriptive and Inferential Statistics

Linear Algebra

Differential Calculus

Chain Rule

Python Scipy Library

Mean, Median, Mode

Percentile

Log Normal Distribution

PCA: principle component Analysis

Probability and Distribution

Binomial Theorem

Hypothesis testing

Mean Absolute Deviation

Normal Distribution and Z Score

Visualizing Data

Variance: ANOVA

Statistical Significance

Inferential Statistics

Chi-square test, T test

Machine Learning Using SK-Learn – 13 Days

Machine learning model improvement – 5 Days

Deep Learning using Tensor Flow – 10 Days

Data Analysis and Visualization Using Tableau –7 Day

Natural Language processing - 5 Days