Certificates shipped for course completion till 25th of the last month.

Select Your Style

Choose your layout

Color scheme

MySQL- A Practical Approach

MySQL- A Practical Approach

MySQL- A Practical Approach

About the course

This course helps the learners to get complete hang of the database concepts using MySQL, which is one of the most widely used database in the industry. In this course, you’ll learn to deal with databases which is the backbone of any personal or commercial software. This course facilitates the user to understand fundamentals of database, which includes dealing with database, working with tables and data, understanding and writing queries.This course comprises of video lectures which can be viewed online and offline as per the convenience of the user. It also has practice questions, downloadable source code files for saving user's time in typing the source code, since almost the entire course is hands on. So, this makes it all together a complete package.

This course covers the fundamental concepts of relational database management system. This course covers creation of database, creation of tables, writing queries to insert data, update, delete and fetch the data from the tables. Merging of tables, using aggregate functions, clauses to filter and sort the data, has been covered in detail. The course mainly focuses on practical approach and expects the user to try hands on with the exercises to get completely proficient in working with MySQL.


Advantages of learning this course
Target Audience
Why learn MySQL?
Course Features
Test & Evaluation
  • Timeline
  • Scholarship Details

Please Login or Register to fill the Scholarship form.

Scholarship Application

Under Graduate

Post Graduate



Other Information


*CGPA to percentage conversion formula:

Equivalent Percentage = CGPA obtained X 9.5 X (10/CGPA Scale)
Example: If CGPA obtained is 8.00 on the scale of 10, then Equivalent
percentage will be 8.00 X 9.5 X (10/10) = 76%,
or If CGPA is 3.7 out of 4, then Equivalent percentage will be 3.7 X 9.5 X (10/4) = 87.88%


We urge you to provide correct information to your best knowledge. Certificates will be withheld if found that you have misrepresented any data / information.


  1. What is a Database

  2. MySQL overview

  3. Using MySQL Queries

    You can download the source code files by clicking on the button "Download Source"
  4. Datatypes in MySQL

  5. Designing Databases Using MySQL

    1. Principles and Normalization

    2. Creating Database

  6. Installation

    1. Setting up XAMPP

    2. Introduction to phpmyadmin

  7. SQL Queries

    1. Show Use and Describe

    2. Importing data in MySQL database

    3. Select Single Column

    4. Select Multiple Column


    6. ORDER BY

    7. WHERE and BETWEEN

    8. AND and OR

    9. IN, NOT IN and LIKE

    10. AND (&&) and OR (||) again

    11. Regular Expressions

    12. String Functions

    13. Aggregate Functions

    14. GROUP BY

    15. SUB Queries

    16. JOINS

    17. Full Text


    19. UPDATE and DELETE

    20. ALTER, RENAME and DROP


    22. Concat and Count

    23. Using the IN clause

    24. Math and SubQueries

    25. Using Group By

  8. Database Structure

  9. Managing Users and Privileges

  10. MySQL Performance Management

  11. Backing up and Restoring Database

  12. MySQL-Final Quiz