DDL (Data Definitions Language) Commands
Answer: Goal: Data Definition Commands defines the syntax of a database 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: 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/Demo/Use-case: 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
Answer: Goal: DML Commands help to work with existing data. Using these commands we can add, modify, or delete the 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
Retrieve data from multiple tables
Answer: Goal: To combines columns from multiple tables in a database by using values common to tables 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
Inbuilt Functions in SQL
Answer: Goal: Use Built-In functions to calculate values and manipulate data 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
Create Advance database objects
Answer: Goal: To create advanced database objects for data manipulation and data 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