Course Outline:
DDL (Data Definitions Language) Commands
Goal: Data Definition Commands defines the syntax of a database and manipulate database objects
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:
- Relation Database Management System (RDBMS).
- Normalization.
- Create Database objects.
- Data Types in SQL.
- Alter Table Statements.
- Drop Table Statements.
- Various Constraints.
- Creating Views.
Hands-On:
- Create Table with Predefine Columns.
- Add New Column to Existing Table.
- Check the constraints on a table.
- Add Primary Key and Foreign Key on Table.
- Remove Unique Constraint.
DML (Data Manipulation Language) Commands:
Goal: DML Commands help to work with existing data. Using these commands, we can add, modify, or
delete the data
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:
- Insert the records in an existing table.
- Delete selective records.
- Update data in the table based on data from another table.
Retrieve data from multiple tables
Goal: To combines columns from multiple tables in a database by using values common to tables
Objectives:
- Retrieve records from multiple tables.
Topics:
- Self-Join.
- Inner Join.
- Left Join.
- Right Join.
- Cross Join.
Hands-On:
- Retrieve data from multiple tables.
Inbuilt Functions in SQL:
Goal: Use Built-In functions to calculate values and manipulate data
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:
- Determine the Count of rows satisfying acertain condition.
- Determine average of a column.
- Determine Sum of a column.
Create Advance database objects:
Goal: To create advanced database objects for data manipulation and data retrieval
Objectives:
- Create Stored Procedure.
- Execute Stored Procedure.
- Create Functions.
- Create Triggers.
Topics:
- Custom Functions.
- Stored Procedure.
- Triggers.
Hands-On:
- Create Functions.
- Create Triggers.
- Create and Execute Stored Procedure.