Goal: Data Definition Commands define a database's syntax and manipulate database objects. 

Module Objectives: 

• RDBMS (Relational Database Management System) Introduction

• Normalization in RDBMS

• Create database objects i.e. Create Table

• Delete database objects i. e. Delete Database

• Alter database objects i.e. Change Column Name

• Create, alter and delete constraints 

Topics:

• Relational Database Management System (RDBMS)

• Normalization

• Create Database objects

• Data Types in SQL

• Alter Table Statements

• Drop Table Statements

• Various Constraints

• Creating Views

Hands-on/Demo/Use-case:

• Create Table With Predefined Columns

• Add New Column to Existing Table

• Check the constraints on a table

• Add Primary Key and Foreign Key on Table

• Remove Unique Constraint

Goal: DML commands make it easier to deal with existing data. We can use these instructions to add, change, or remove data. 

Module Objectives: 

• Insert record/data in tables

• Modify/Update the existing data

• Retrieve the data from database from single table

• Use of operators for data retrieval

• Delete the data from tables

Topics:

• Insert Statements

• Insert – As- Select Statement

• Update Statements

• Delete Statements

• Truncate Statements

• Select Statement

• Sorting and Filtering

• SQL wildcard

• CASE Expression

Hands-on/Demo/Use-case:

• Insert the records in an existing table

• Delete selective records

• Update data in the table based on data from another table

Goal: Using values shared across tables, merge columns from many tables in a database.

Module Objectives: 

• Retrieve records from multiple tables

Topics:

• Self-Join

• Inner Join

• Left Join

• Right Join

• Cross Join

Hands-on/Demo/Use-case:

• Retrieve data from multiple tables

Goal: To compute values and handle data, use built-in functions.

Module Objectives: 

• Use of Built-in Functions

• Use of Group by Command

• Use of Having Commands

Topics:

• Conversion Function

• Logical Functions

• Math Function

• Aggregate Functions

• String Functions

• Date Functions

Hands-on/Demo/Use-case:

• Determine the Count of rows satisfying a certain condition

• Determine average of a column

• Determine Sum of a column

Goal: To develop sophisticated database objects for data management and retrieval.

Module Objectives: 

• Create Stored Procedure

• Execute Stored Procedure

• Create Functions

• Create Triggers

Topics:

• Custom Functions

• Stored Procedure

• Triggers

Hands-on/Demo/Use-case:

• Create Functions

• Create Triggers

• Create and Execute Stored Procedure