Share this program with friends or teammates.
Duration: 35H
Category: Database
Type: Database
Topics and modules covered in mysql
RDBMS 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
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
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
Self-Join
Inner Join
Left Join
Right Join
Cross Join
Conversion Function
Logical Functions
Math Function
Aggregate Functions
String Functions
Date Functions
Trigger
Procedure
SQL Maintenance
