- Why Software Systems?
- Types of software Applications
- Components of a software system
- Types of Software projects
- Why to learn Data science?
- Data Science Domains
- Skills required for Data scientist
- Importance of Database management systems
- Select queries for single table
- Joins and Unions
- Aggregating data
- Designing and modifying data and tables
- Working with Subqueries
- Views and Stored procedures
- Introduction and installation of Tableau
- Connecting to different data sources
- Measures, dimensions and calculated field
- Working with colors, labels and formatting
- Performing AB test
- Aliases and anomalies
- Validating the tests
- Visualization of tests
- Introduction to Data warehouse
- Overview of ETL process
- Installing SSDT on SQL server
- Preparing data to Load
- Setting up source and destination sources
- Performing Extract and Transforms
- Due diligence upload QA
- Error handling
- Minimizing Anomalies
- Basics of ETL QA
- Python basics
- Python Data structure
- File I/O
- Exception handling
- Python OOP
- Basics of statistics
- Importing libraries and datasets
- Splitting dataset into training set and test set
- Simple and multiple linear regression
- Polynomial regression
- Decision tree regression
- Support Vector regression
- Logistic regression
- K-nearest neighbors
- Naïve Bayes
- K-means clustering
- Hierarchical clustering
- NLP libraries and example