Scribd
Upload
215 views5 pages

Industries Helping Hands SQL Syllabus

This document outlines an SQL training course with 6 modules covering fundamental SQL concepts, commands, joins, subqueries, grouping, sorting, and two end-to-end projects. The course includes download instructions for software, learning resources, live workshops for doubts, and units on topics like data types, constraints, aggregation, and scalar functions. It also provides contact information and links to download their mobile app for course registration and support.

Uploaded by

advertisewave
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
215 views5 pages

Industries Helping Hands SQL Syllabus

This document outlines an SQL training course with 6 modules covering fundamental SQL concepts, commands, joins, subqueries, grouping, sorting, and two end-to-end projects. The course includes download instructions for software, learning resources, live workshops for doubts, and units on topics like data types, constraints, aggregation, and scalar functions. It also provides contact information and links to download their mobile app for course registration and support.

Uploaded by

advertisewave
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

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: : https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet

Install our IHHPET Android App: https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet


Contact : +91-7880-113-112 | Visit Website: www.industrieshelpinghands.com
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: : https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet

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: https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet
Contact : +91-7880-113-112 | Visit Website: www.industrieshelpinghands.com
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: : https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet

Install our IHHPET Android App: https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet


Contact : +91-7880-113-112 | Visit Website: www.industrieshelpinghands.com
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: : https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet

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: : https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet

Install our IHHPET Android App: https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet


Contact : +91-7880-113-112 | Visit Website: www.industrieshelpinghands.com
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: https://play.google.com/store/apps/details?id=com.logixhunt.ihhpet


Contact : +91-7880-113-112 | Visit Website: www.industrieshelpinghands.com

You might also like