Welcome to the Course.
•Welcome to the Course!
•Installing Python and Anaconda – Windows,Mac or Linux
•***Update on Reviews***
•Recommended Anaconda Version
•Basics of Jupyter Notebook
•Course Notes
•Python Crash Course
•Python Crash Course Part 1
•Python Crash Course Part 2
•Python Crash Course Part 3
•Python Exercises
•Python Exercises Solutions
•Numpy Basics
•Numpy Operations Part 1
•Numpy Operations Part 2
•Numpy Operations Part 3
•Numpy Exercises Overview
•Numpy Exercises Solution Overview
•Data Wrangling in Python: Pandas
•Introduction to Pandas.
•Pandas : Basics Functions
•Pandas : Slicing and Row Selection
•Pandas : Descriptive Statistics
•Pandas: Missing and Cleaning Data
•Pandas: Groupby and Indexing
•Pandas: Pivot Table & CrossTab
•Pandas:TimeSeries data operation.
•Pandas: Merging, Joining and Concatenating Dataframes
•Pandas: Importing and Exporting Data – CSV/Excel/AWS/SQL/Online
•In-Built Visualization in Pandas
•Pandas Exercise Solution
•Plotting Data in Python : Seaborn
•Seaborn Introduction
•Case Study 1 – Visualizing Data Distribution Using Seaborn
•Case Study 2 – Plotting Categorical Variables Using Seaborn
•Case Study 3 – Plotting Linear Relationships
•Case Study 4 – Visualizing Statistical Relationship
•Introduction to Machine Learning
•Machine Learning Algorithmns Overview
•Scikit-Learn Introduction
•Data Processing – Standardization & Normalization,OneHotEncoding
•Data Processing – Train_Test_Split
•Machine Learning PreProcessing Template
•Supervised Learning – Regression
•Linear Regression Intuition
•Linear Regression Overview
•Linear Regression Exercise Overview
•Linear Regression Solutions Overview
•KNeighborsRegressor -Intuition
•Decision Tree Regressor
•RandomForestRegressor – Intuition
•Support Vector Regression Intuition
•RANSAC Regressor – Intuition
•Lasso Regressor – Intuition
•Ridge Regression – Intuition
•Gaggle of Regressors – Overview
•Gaggle of Regressors Exercise Overview
•Gaggle of Regressors Solution Overview
•Supervised Learning – Classification
•Classification Models Intuition
•Logistic Regression Intuition
•Logistic Regression Overview Part 1
•Logistic Regression Overview Part 2
•Logistic Regression Exercise Overview
•Logistic Regression Exercise Solution Overview
•KNeighbours Classifier
•Decision Tree & Random Forest Classifier
•Decision Tree and Random Forest Classifier & Model Selection
•Support Vector Machines Classifier
•Naives Bayes Classifier
•Gaggle of Classifiers
•Gaggle of Classifiers – Exercise Overview
•Gaggle of Classifiers – Exercise Solutions Overview
•UnSupervised Learning – Clustering
•KMeans Clustering
•Model Selection and Dimensionality Reduction
•Model Selection and HyperParameters
•Feature Engineering & Dimensionality Reduction
•BONUS : Extensive SQL BootCamp
•SQL With PostgreSQL Introduction
•Setting up PostgreSQL
•Course Files
•PgAdmin 4 Overview
•Import Database in PostgreSQL
•SELECT
•ORDER BY
•SELECT DISTINCT
•WHERE CLAUSE
•LIMIT
•FETCH
•LIKE
•IN CLAUSE
•BETWEEN AND ALIAS – AS
•IS NULL CLAUSE
•JOINS INTUITION
•INNER JOIN
•LEFT JOIN
•RIGHT JOIN
•FULL OUTER JOIN
•GROUP BY
•HAVING CLAUSE
•UNION
•INTERSECT
•EXCEPT
•GROUPING SETS
•SUBQUERY
•SUBQUERY ANY, ALL, EXISTS OPERATOR
•INSERT CLAUSE
•UPDATE CLAUSE
•UPDATE JOIN
•DATA TYPES
•CREATE TABLE, SELECT INTO & CREATE TABLE AS
•ALTER TABLE – RENAME, ADD, DROP COLUMN, Change Column Data Type
•Aggregate Functions – Average, Count
•Aggregate Functions – Min,Max, Sum
•Time and Date Functions
•String Functions
•Math Functions
•SQL Case Studies
•SQL Case Study Overview
•SQL Case Study One Schema
•SQL Case Study One – Solution Overview
•SQL Case Study One – Solutions
•SQL Case Study Two Schema
•SQL Case Study Two – Solutions Overview
•SQL Case Study Two Solutions
•UPCOMING –>>>BONUS:: Learn TABLEAU
•TABLEAU OVERVIEW
•