
SMARTECH EDUCATION COMPUTER INSTITUTE
An ISO Certified Institute | NIELIT Accredited Institute | Regd. Under Govt. of Punjab
SQL SYLLABUS
MODULE 1: (Introduction)
TOPIC 1: (Get started with database, SQL and MySQL)
1.1: What is database?
1.2: Why use SQL?
1.3: Importance of MySQL
​
MODULE 2: (SQL Server Languages and Relational Databases)
TOPIC 1: (SQL language statements)
1.1: (DDL)
1.2: (DCL)
1.3: (DML)
1.4: (TCL)
​
TOPIC 2: (Relational Database Terminology)
2.1: (Relational Database essentials)
2.2: (Primary key)
2.3: (Foreign key)
2.4: (Unique key and null values)
​
TOPIC 3: (Installing MySQL)
3.1: (Get acquainted with the interface)
​
MODULE 3: (Basics of SQL)
TOPIC 1: (First Steps in SQL)
1.1: (Creating a database)
1.2: (Introduction to datatypes)
1.3: (Creating a table)
​
MODULE 4: (Constraints of MYSQL)
TOPIC 1: (Different constraints in MySQL)
1.1: (Primary key constraint)
1.2: (Foreign key constraint)
1.3: (Unique constraint)
1.4: (Default constraint)
1.5: (Not null)
​
MODULE 5: (The Select Statement)
TOPIC 1: (Load the database)
1.1: (Loading employees’ database)
​
TOPIC 2: (Starting with SELECT statement)
2.1: (Select-From)
2.2: (Where)
2.3: (And-Or)
2.4: (In-not in)
2.5: (Like-not like)
2.6: (Wildcard characters)
2.7: (Between-and)
2.8: (Is not null-is null)
2.9: (Select distinct)
2.10: (Aggregate statement)
2.11: (Order by-Group by)
2.12: (Using Aliases)
2.13: (Having and Limit)
​
MODULE 6: (The SQL Statement)
TOPIC 1: (Insert statement)
1.1: (Inserting data INTO tab
​
TOPIC 2: (Update statement)
2.1: (Commit and rollback)
​
TOPIC 3: (Delete statement)
3.1: (Drop vs Truncate)
​
MODULE 7: (AGGREGATE FUNCTIONS)
TOPIC 1: (Functions)
1.1: (Count())
1.2: (Sum())
1.3: (Min() and Max())
1.4: (Avg())
1.5: (Round())
​
MODULE 8: (SQL JOINS)
TOPIC 1: (Introduction to Joins)
1.1: Joins
1.2: Left join
1.3: Right join
1.4: Cross join
1.5: Union and Union all
​​
MODULE 9: (SUBQUERIES)
TOPIC 1: (Working with Subqueries)
1.1: IN nested inside Where
1.2: EXISTS nested inside Where
​
MODULE 10: (STORED ROUTINES)
TOPIC 1: (Introduction to Stored Procedures)
1.1: With input parameter
1.2: With output parameter
1.3: Variables
1.4: User defined functions
