Data Science and Data Engineering using python- Day wise Syllabus |
||
Day |
Topics |
|
4hours/day |
||
1 |
Introduction to Data Science, Importance of Python programming |
|
Basics of Python, Basic of statistic using Python, Modules and packages in python |
||
2 |
Exploratory Data Analysis (EDA), case study |
|
3 |
Data Visualization, Skewness, Kurtosis, Probability Theory, case study |
|
4 |
Normal Distribution, Z-score, Confidence Interval, Z-distribution, case study |
|
5 |
T-distribution, Data Pre-processing, case study |
|
6 |
Introduction to Machine learning, Importance of Machine learning in Data Science. Supervised |
|
7 |
learning Algorithm: Naïve Bayes, case study |
|
Supervised learning Algorithm: Random Forest, case study, Linear Regression, case study |
||
8 |
||
Unsupervised learning: K-means clustering, Hierarchal clustering and dendrogram, case study |
||
9 |
Introduction to NLP , Data analysis using text mining, Text mining using NLP |
|
10 |
Text mining case study, Introduction to WordCloud, Applications of wordcloud, case study |
|
11 |
Time Series Analysis, Forecasting, case study |
|
12 |
Dimension Reduction, Association Rule Mining, case study |
|
13 |
Introduction to Data Engineering, Difference between Data Science and Data Engineer, |
|
14 |
Different data sources, Procedure of data collection from different data sources, Introduction to |
|
MYSQL |
||
Basics of database, Configuring MYSQL server and client, Steps for database creation, |
||
15 |
Database maintenance, Basics and advance database queries |
|
Python programming for SQL, Integrating data engineering with data science. |