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.

Live (Instructor-led)
Intermediate

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
IS NULL
IS NOT NULL
BETWEEN

Join Operations in MySQL

JOIN
Inner Join
Left Join
Right Join
CROSS JOIN
SELF JOIN
DELETE 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

Project

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

~~INR 14,000~~ INR 8,000

Register to confirm your seat, Pay now

Course Features

365 days access
Live interactive sessions
Certificate of completion
Mock interview
Hands on labs
Practice assignments
Resume preparation
Interview guidance
Job assistance
Industry use cases
Doubt clarity sessions

View this Course on Mobile

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