🎉 Special Offer: Enroll Now and Get 20% Discount on All Courses! 🎉
|
New Batch Starting Soon - Limited Seats Available!
|
Free Career Counseling Session for All Students!
Home
Course
Contact
Login
Menu
Home
Courses
Contact
Login
Home
Courses
mysql
Database
mysql
Share
Share
Copy Link
Duration:
35H
Category:
Database
Type:
Database
₹6,000
₹4,500
Save ₹1,500
Course Syllabus
48
Request Course Information
Name
*
Email
*
Mobile
*
For Training
Select Training Type
Corporate Training
Online Training
Offline Class
Request Course
Course Syllabus - 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
