3 - Using SELECT statement to retrieve entire Table data
4 - Using the SELECT Statement to Retrieve Columns from a Table
5 - Using Distinct to remove duplicate records
6 - Filter Records based on Single Criteria using the WHERE Clause
7 - Filtering with SQL AND Operator
8 - Filtering with SQL OR Operator
9 - Filtering with SQL NOT Operator
10 - Sort SQL Data AscendingDescending using the ORDER BY Keyword
11 - INSERT INTO Inserting Data into Every Column of a Table
12 - IS NULL Handling nulls and blanks
13 - DELETE Delete a row in table using conditions
14 - UPDATE update values in rows or columns
15 - LIMIT Top rows of a table
16 - LIMIT Select Top rows conditionally
17 - MINMAX values of a column
18 - COUNT of records
19 - COUNT DISTINCT records in the tablecolumn
20 - AVG Average of the numeric values
21 - SUM Sum of the numeric values
22 - Conditional Average
23 - Filter using LIKE operator in SQL
24 - Filtering using IN operator in SQL
25 - Filtering using BETWEEN operator in SQL
26 - Renaming a column using AS
27 - GROUPBY and SUM
28 - GROUPBY and Average
29 - GROUPBY and WHERE
30 - GROUPBY and COUNT
31 - Filtering Grouped Data with the SQL Having Clause
32 - CREATE TABLE SCHEMA
33 - INSERT values in table created
34 - DROP a table
35 - Introduction to JOINS
36 - SQL INNER JOIN
37 - SQL LEFTRIGHT JOIN
38 - SQL OUTER JOIN
39 - UNION vs UNION ALL
40 - CREATE A VIEW
41 - DELETE A VIEW
42 - Conclusion