• Define RDBMS and three normalization forms
• Using DDL Statements to Create and Manage Tables
• Manipulating Data Using DML
• Retrieving Data Using the SQL Select Statement
• Restricting and Sorting Data
• Displaying Data from Multiple Tables
• Using the built-in functions.

• Building a Multi table Relational Database
• Problems and exercises based on given schema. 25 exercises will be given as a part of the project.

• 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 

• Relation Database Management System (RDBMS)
• Normalization
• Create Database objects
• Data Types in SQL
• Alter Table Statements
• Drop Table Statements
• Various Constraints
• Creating Views

• 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

• 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

• Insert Statements
• Insert – As- Select Statement
• Update Statements
• Delete Statements
• Truncate Statements
• Select Statement
• Sorting and Filtering
• SQL wildcard
• CASE Expression

• Insert the records in an existing table
• Delete selective records
• Update data in the table based on data from another table

• Retrieve records from multiple tables

• Self-Join
• Inner Join
• Left Join
• Right Join
• Cross Join

• Retrieve data from multiple tables

• Use of Built-in Functions
• Use of Group by Command
• Use of Having Commands

• Conversion Function
• Logical Functions
• Math Function
• Aggregate Functions
• String Functions
• Date Functions

• Determine the Count of rows satisfying a certain condition
• Determine average of a column
• Determine Sum of a column

• Create Stored Procedure
• Execute Stored Procedure
• Create Functions
• Create Triggers

• Custom Functions
• Stored Procedure
• Triggers

• Create Functions
• Create Triggers
• Create and Execute Stored Procedure

You will never miss a lecture at Certhippo! You can choose either of the two options:

• View the recorded session of the class available in your LMS.
• You can attend the missed session, in any other live batch.

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.

• Once you are successfully completed your project (Reviewed by the Certhippo experts), you will be awarded with Certhippo's Selenium Training certificate.

  Certhippo certification has industry recognition and we are the preferred training partner for many MNCs e.g.Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc. Please be ensured.