Relational Database – MySQL

  • Learn about relational database management concepts with structured query language.
  • Detail learning for MySQL relational database concepts, data definition language, table & views, query, triggers, functions & procedures, user privilege management, indexes, joins and aggregate functions.

What this course covers

  • Course provides complete learning for relational database management concepts.
  • Covers all topics of structured query language in detail
  • Provides detail learning for MySQL relational database concepts
  • Covers data definitional language, table & views, query, triggers, functions & procedures
  • Covers user privilege management, indexes, joins and aggregate functions

Requirements for this course

  • Should have basic knowledge of Information Technology
  • Basic knowledge of Programming is not required, but advantageous

Who can benefit from this course

  • Software Developers and System Administrators interested in developing applications in any domain
  • Testing Professionals and Development Operations, who are more interested in data storage & analytics techniques
  • Candidates, who want to pursue their career in IT and its related field

Course Syllabus

Introduction to Database

  • Introduction to DBMS
  • What is a Database
  • Usage of Database
  • Different types of Databases
  • Database objects

Database Architectures

  • Centralized Database
  • Client-Server Database
  • Server system (Cloud based servers, Data servers, Transaction servers)
  • Parallel and distributed database
  • Web database system (2 tier, 3 tier, N-tier web architecture)

Database Storage Structures

  • Introduction to database storage
  • Database – Tablespace, Segment, Extent, Block, Data File
  • Indexing, Hashing, Clusters
  • Data Dictionary and Dictionary Views

Data Models

  • Introduction to various data models
  • Cardinality Ratio & Relationships
  • Representation of entities, attributes, relationship attributes
  • Representation of relationship set, generalization, aggregation
  • Structure of relational Database and different types of keys

Relational Database design

  • Basic System Development Life Cycle
  • Entity-relationship (ER) diagrams
  • Functional dependencies
  • Normalization
  • Normalization forms based on primary keys (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
  • Loss less joins and dependency preserving decomposition

Introduction to Relational Databases

  • Introduction to MySQL Database
  • Features of MySQL Database
  • Popularity of MySQL Database
  • Working of MySQL Database
  • Advantages/Disadvantages of MySQL Database

MySQL Installation

  • MySQL installation on Windows
  • MySQL installation on Linux
  • MySQL query client
  • MySQL workbench
  • MySQL connection types

MySQL Database Management

  • Database creation in MySQL
  • Database selection in MySQL
  • Database drop in MySQL
  • Database copy in MySQL

Data Definition using MySQL

  • MySQL Data Types
  • MySQL variables
  • Tables in MySQL
  • Constraints and Indexes in MySQL
  • Views in MySQL

Tables Operations in MySQL

  • CREATE Table
  • ALTER Table
  • Show Tables
  • Describe Table
  • Rename Table
  • DROP Table
  • TRUNCATE Table
  • Temporary Table
  • Copy Table
  • Repair Table
  • Add/Delete Column
  • Show Columns
  • Rename Column
  • Views
  • Table Locking
  • Account Lock
  • Account Unlock
  • Table & Column Constraints

Query Operations in MySQL

  • Basic of query writing
  • Record insert
  • Record update
  • Record delete
  • Record select
  • Record Replace
  • Duplicate key update
  • Insert Into Select
  • Insert ignore

Keys & Indexes in MySQL

  • Unique Key
  • Primary Key
  • Foreign Key
  • Composite Key
  • Create Index
  • Drop Index
  • Show Indexes
  • Unique Index
  • Clustered Index
  • Clustered vs. Non-Clustered Index

Clauses in MySQL

  • Where
  • Distinct
  • From
  • Order By
  • Group By
  • Having

Privilege & User Management in MySQL

  • Create user in MySQL
  • Drop user in MySQL
  • Show users in MySQL
  • Change user password in MySQL

Control Flow in MySQL

  • IF()
  • IFNULL()
  • NULLIF()
  • CASE
  • IF Statement

Conditions in MySQL

  • AND
  • OR
  • Boolean
  • LIKE
  • IN
  • ANY
  • Exists
  • NOT
  • Not Equal

Join Operations in MySQL

  • JOIN
  • Inner Join
  • Left Join
  • Right Join
  • Update Join
  • EquiJoin
  • Natural Join
  • Left Join vs. Right Join
  • Union vs. Join

Triggers in MySQL

  • What are Triggers
  • Uses of Triggers
  • Create Trigger
  • Show Trigger
  • Drop Trigger
  • Before Insert Trigger
  • After Insert Trigger
  • Before Update Trigger
  • After Update Trigger
  • Before Delete Trigger
  • After Delete Trigger

Aggregate functions in MySQL

  • count()
  • sum()
  • avg()
  • min()
  • max()
  • first()
  • last()

Procedures & Functions in MySQL

  • PLSQL Basics
  • Programming Concepts in PLSQL
  • Cursors
  • Nested Cursors
  • Functions
  • Procedures
  • Interoperability between Functions & Procedures

Query Optimization Techniques


  • Database connection and crud operations using programming language
  • Database procedure and function creation
  • Database trigger creation and testing for work flow
Relational Database MySQL Intro

INR 14,000 INR 8,000

Register to confirm your seat, Pay now

Course Features

View this Course on Mobile

Relational Database – MySQL

Refer this Course

Invite a friend via Facebook, Twitter, WhatsApp or Email and they’ll get a INR 500 welcome credit, plus you’ill get INR 500 in your own account with their first order, as our little thank you.

* For more details, Please refer Referral Policy

Please Login

You must have an account to refer a friend.


Please Login

You must have an account to refer a friend.