Best Seller Icon Bestseller

'O' Level In My SQL(M-MS-1275)

  • Last updated Apr, 2026
  • Certified Course
₹5,000 ₹10,000

Course Includes

  • Duration3 Months
  • Enrolled0
  • Lectures90
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

MySQL is an open-source database management system used to store, organize, and manage data efficiently. It works using Structured Query Language (SQL) to perform operations like inserting, updating, deleting, and retrieving data.

It is widely used in web development and is an important part of the LAMP Stack (Linux, Apache, MySQL, PHP).

Show More

Course Syllabus

Module 1: Introduction to Database

  • What is a Database?
  • Types of Databases
  • Introduction to DBMS
  • Overview of MySQL
  • Uses of databases in real life

Module 2: Installation & Setup

  • Installing MySQL
  • MySQL Workbench overview
  • Creating first database
  • Understanding database environment

Module 3: Database & Table Operations

  • Creating database (CREATE DATABASE)
  • Selecting database (USE)
  • Creating tables (CREATE TABLE)
  • Data types in MySQL
  • Altering and dropping tables

Module 4: SQL Commands

  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • DCL (Data Control Language)
  • TCL (Transaction Control Language)

Module 5: Data Manipulation

  • Inserting data (INSERT)
  • Retrieving data (SELECT)
  • Updating data (UPDATE)
  • Deleting data (DELETE)
  • Filtering data (WHERE, ORDER BY)

Module 6: Constraints & Keys

  • Primary Key
  • Foreign Key
  • Unique Key
  • Not Null
  • Default Constraint

Module 7: Joins & Relationships

  • Types of Joins (INNER, LEFT, RIGHT)
  • Table relationships
  • Combining multiple tables

Module 8: Functions & Queries

  • Aggregate functions (COUNT, SUM, AVG)
  • Grouping data (GROUP BY)
  • Filtering groups (HAVING)
  • Subqueries

Module 9: Advanced Concepts

  • Indexes
  • Views
  • Stored Procedures (basic)
  • Introduction to triggers

Module 10: Practical & Projects

  • Creating student database system
  • Employee management system
  • Real-life database design
  • Mini project 


Course Fees

Course Fees
:
₹10000/-
Discounted Fees
:
₹ 5000/-
Course Duration
:
3 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%



Call
Text Message
Review
Email
CHAT