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.

  • 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