SkillManthan Logo - Best IT Training Institute in Lucknow
Loading your future skills...
+91-6392-361-443,+91-9120-341-047
theskillmanthan@gmail.com
Our Placements Scholarship Test Training Brochure Company Profile
Register Now Scholarship Test
Best Summer & Industrial Training in Lucknow | Affordable IT Internships
Verify Certificate Register Now
Download Courses - SkillManthan Technologies Pvt Ltd
MySQL Course Banner

MySQL / Database Management

Learn MySQL and database fundamentals — design databases, write efficient queries, and manage real-world data for web and software applications.

Course Description

This course covers complete database management using MySQL. You will learn SQL queries, relational database design, normalization, and integration with applications through hands-on practice and real-world scenarios.

Detailed Course Syllabus

L.N. Contents Hours
1
  1. Introduction to Databases
  2. What is DBMS & RDBMS?
  3. Database Concepts
  4. Installing MySQL
  5. MySQL Tools (Workbench / CLI)
 2
2
  1. SQL Basics
    • Data Types
    • Creating Databases & Tables
    • Primary Key, Foreign Key
 2
3
  1. Data Manipulation (DML)
    • INSERT
    • UPDATE
    • DELETE
    • SELECT
 2
4
  1. Filtering & Sorting
    • WHERE Clause
    • ORDER BY
    • LIMIT
 2
5
  1. Joins
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • SELF JOIN
 2
6
  1. Aggregate Functions
    • COUNT
    • SUM
    • AVG
    • GROUP BY
    • HAVING
 2
7
  1. Constraints
    • NOT NULL
    • UNIQUE
    • DEFAULT
    • CHECK
 2
8
  1. Indexes & Optimization
    • Indexing
    • Query Optimization
 2
9
  1. Views & Stored Procedures
    • Creating Views
    • Stored Procedures
    • Functions
 2
10
  1. Normalization
    • 1NF, 2NF, 3NF
    • Database Design Principles
 2
11
  1. Backup & Security
  2. User Management
  3. Final Project
  4. Interview Preparation
 2