SQL Free Course with Project |Syllabus
With Project Data Science & Web Development
Contact for IHHPET App Support
+91-7880-113-112
Module: 1 [Fundamental of SQL and DBMS]
Unit: 1 Introduction and Installation Software
1.1. Roadmap to learn SQL
1.2. Download & Install MySQL
1.3. Download & Install XAMPP
1.4. Download & Install PostgreSQL & Pgadmin
Unit:2 Fundamentals of SQL
2.1. Introduction to SQL
2.2. Database Fundamental
2.3. Learning Resources
(Cheat Code |Practice Dataset| PDF Notes & Books |Learning Website |
Interview Questions)
Unit:3 Case Study with Example
3.1. Create Database | Drop Database | Create Table | Insert Table | Drop Table
3.2. Case study with XAMPP Software
3.3. Case study with MySQL software
3.4. Case study with PostgreSQL
Unit: 4 Data Types and Keys
4.1. All Data Type in SQL
4.2. ER / Database Diagram Example: Amazon Ecommerce
4.3. Database Keys
4.4. Cardinality of Relationships
4.5. Drawbacks of Databases
LIVE: 1 Free Monthly Workshop & Doubt Session:
Registration in IHHPET App: : [Link]
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Module: 2 [ SQL DDL Commands “Data Definition Language”]
Unit: 5 DDL Commands for SQL
5.1. DDL Commands for Databases: Create | Drop
5.2. DDL Commands for Table: Create | Truncate | Drop
5.3. Data Indignity
Unit: 6 Constraints
6.1. Constraints in MySQL (NOT NULL | UNIQUE | PRIMARY KEY)
6.2. Constraints in MySQL (AUTO INCRIMENT | CHECK | DEFAULT | FOREIGN KEY)
6.3. Referential Actions (Restrict | CASCADE | SET NULL | SET DEFAULT
Unit: 7 Alter Table
7.1. ADD Columns in Alter Table
7.2. DELETE Columns in Alter Table
7.3. MODIFY Columns in Alter Table
Unit: 8 ADD, Editing and Deleting Constraints
8.1. ADD Constraints
8.2. DELETE Constraints
8.3. EDIT Problems in MySQL, Drop Constrains
LIVE:2 Free Monthly Workshop & Doubt Session:
Registration in IHHPET App: : [Link]
Module: 3 [ SQL DML Commands “Data Manipulation Language”]
Unit: 9 INSERT Query
9.1. INSERT query
9.2. INSERT query variation
9.3. INSERT multiple values
Unit: 10 SELECT Query
10.1. SELECT all columns
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
10.2. Filter columns
10.3. Alias | renaming columns
10.4. Create expression using columns
10.5. Constant value
10.6. DISTINCT(unique) values from a column
10.7. DISTINCT Combinations
10.8. Filter rows WHERE clause
10.9. BETWEEN operator
10.10. IN and NOT IN Operator
Unit: 11 UPDATE Query
11.1. Update Query to update row(s)
11.2. Update Multiple Columns
Unit: 12 DELETE
12.1. DELETE Query to delete row(s)
12.2. Deletion based on multiple conditions
Unit: 13 Aggregate Functions in MySQL/SQL
13.1. MAX() & MIN()
13.2. AVG()
13.3. SUM()
13.4. COUNT()
13.5. STD()
13.6. VARIANCE()
Unit: 14 Scalar Functions in MySQL/SQL
14.1. ABS()
14.2. ROUND()
14.3. CEIL() & FLOOR()
LIVE:3 Free Monthly Workshop & Doubt Session:
Registration in IHHPET App: : [Link]
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Module: 4 [SQL Joins + Subquery]
Unit: 15 SQL Joins
15.1. What are SQL joins?
15.2. Types of Joins
15.3. Cross Joins --- Cartesian Products
15.4. Inner Joins
15.5. Right Joins
15.6. Left Joins
15.7. Full Outer Join
15.8. Set Operations
15.9. Self-Join
15.10. Filtering Columns
15.11. Filtering Rows
Unit: 16 Subquery
16.1. What is Subquery?
16.2. Scalar Subquery
16.3. Row Subquery
16.4. Table Subquery
16.5. Correlated Subquery
LIVE:4 Free Monthly Workshop & Doubt Session:
Registration in IHHPET App: : [Link]
Module: 5 [Grouping + Sorting + ER Diagram]
Unit: 17 Sorting
17.1. Fundamental of SQL Sorting
17.2. Sorting top 10 data
17.3. Sorting Descending Orders
17.4. Sorting functions in datasets
Unit: 18 Grouping
18.1. Fundamental of SQL Grouping
18.2. Grouping Average Function
18.3. Group By on multiple columns
18.4. Sorting Descending Orders
18.5. Sorting functions in datasets
LIVE:5 Free Monthly Workshop & Doubt Session:
Registration in IHHPET App: : [Link]
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Module: 6 [End to End Projects]
Unit: 19 Project: Data Analyst | Data Science
19.1. Case Study in Indian Premier League (IPL Dataset)
19.2. Find the top 5 batsmen in IPL
19.3. Find the 2nd highest 6 hitters in IPL
19.4. Find Batsman (M.S Dhoni, Virat Kohli) performance against all IPL team
19.5. Find the top 10 batsmen with centuries in IPL using Sub-Quires
19.6. Find the top 5 batsmen with the highest strike rate
19.7. Find 5 Batsman who have played a min of 1000 balls
Unit: 20 Project: Web Development
20.1. Writing Python Codes for Registration Form
20.2. Create Database for Registration
20.3. Login codes written in Python
20.4. Select the Database for Login
20.5. Profile Review for Login System
Scan and download
the App Now
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
