top of page

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

SQL Database Icon

Smartech Education Services Society | Smartech Education Computer Institute | Established Since 2009

bottom of page