MySQL

Many computer programs, including web-based programs need to store and retrieve data. MySQL is kind of DB language which helps to store and retrieve data in DB. There are many databases that support the use of SQL to data, among them MySQL is one of them. For example, blog software need to store the posts (ie, articles) you write, and retrieve them when a visitor goes to your site.

Course Contents

RDBMS Concepts

SQL Commands – DDL,DML,DCL,DQL

Data Constraints

Clauses – Group by, Order by

Types of Joins

Set Operations

Aggregate Functions

Indexes & Sequences

Transaction Control

Queries

Sub Queries

Procedures & Functions

Working with Triggers

Working with Views

Designed by BootstrapMade