9.13 Logical Operators

9.14 Aggregate Functions: COUNT, MIN, MWX, AVG, SUM

9.15 GROUP BY

9.16 HAVING

9.17 ORDER OF KEYWORDS

9.18 Join and Natural Join

9.19 Inner, Left, Right and Outer joins

9.20 Sub Queries/Nested Queries/Inner Queries

9.21 DML: Insert

9.22 DML:UPDATE, DELETE

9.23 DDL: CREATE TABLE

9.24 DDL: ALTER: ADD, MODIFY, DROP

9.25 DDL: DROP TABLE, TRUNCATE, DELETE

9.26 Data Control Language: Grant, Revoke

9.27 - Learning resources

#Module 10 : Plotting for exploratory data analysis (EDA)

Section 10 is divided into sub sections

👉 10.1 Introduction to IRIS dataset and 2D scatter plot

👉 10.2 3D scatter plot

👉 10.3 Pair plots

👉 10.4 Limitations of Pair Plots

👉 10.5 Histogram and Introduction to PDF(Probability Density Function)

👉 10.6 Univariate Analysis using PDF

👉 10.7 CDF(Cumulative Distribution Function)

👉 10.8 Mean, Variance and Standard Deviation

👉 10.9 Median

👉 10.10 Percentiles and Quantiles

👉 10.11 IQR(Inter Quartile Range) and MAD(Median Absolute Deviation)

👉 10.12 Box-plot with Whiskers

👉 10.13 Violin Plots

👉 10.14 Summarizing Plots, Univariate, Bivariate and Multivariate analysis

👉 10.15 Multivariate Probability Density, Contour Plot

👉 10.16 Assignment-1: Data Visualization with Haberman Dataset

10.1 Introduction to IRIS dataset and 2D scatter plot

10.2 3D scatter plot

10.3 Pair plots

10.4 Limitations of Pair Plots