Skip to content
SawariyaComputer Classes
Programming

MySQL

Almost every app and business system stores its data in a database. You'll learn how relational databases are designed and how to get answers out of them with SQL.

Enquire About AdmissionAsk on WhatsApp
Rows of labelled wooden index-card drawers, an old-fashioned way of storing records
Duration
3 months
Level
Beginner
Format
Classroom, 1 hour a day, any time 9 am – 9 pm
Fee
₹8,000Payable in 3 instalments

What you'll learn

  • Design tables with the right keys and relationships
  • Insert, update and delete data
  • Write SELECT queries with filters and sorting
  • Join tables and group results
  • Use views, indexes and basic stored procedures

Course curriculum

  1. Module 01

    Database concepts

    • Tables, rows and columns
    • Primary and foreign keys
    • Normalisation basics

  2. Module 02

    SQL basics

    • CREATE, INSERT, UPDATE, DELETE
    • SELECT with WHERE and ORDER BY

  3. Module 03

    Querying

    • Aggregate functions
    • GROUP BY and HAVING
    • Joins
    • Subqueries

  4. Module 04

    Beyond queries

    • Views
    • Indexes
    • Stored procedures
    • Backup and restore

Practical work

Every class includes time at the computer. Alongside daily exercises, you'll complete:

  • A school database with students, classes and fees, plus the queries to report on it

Is this course for you?

Good fit for

  • Programming and web development students
  • Anyone who works with data

Before you join

  • Basic computer use. Some programming helps.

Where this course fits

Becoming a web developer

  1. Web Development
  2. MySQL
  3. Full Stack Development (MERN)

Questions about this course

What is the fee, and can I pay in parts?

The full course fee is ₹8,000, which can be paid in 3 instalments. We'll confirm the schedule with you at admission.

What are the batch timings?

Classes run from 9 am to 9 pm, every day of the week. Tell us whether morning, afternoon or evening suits you and we'll fit you into a batch at that time.

Will I get a certificate?

Yes. You'll receive a course completion certificate from Sawariya Computer Classes when you finish the course.

Other programming courses

All courses

Beginner

C / C++

The classic first programming language, from variables and loops to pointers and OOP.

Duration
3 months
Fee
₹5,500

View course

Beginner to Intermediate

Python Programming

A readable, practical first language: logic, data structures, files and object-oriented Python.

Duration
3 months
Fee
₹8,000

View course

Beginner to Intermediate

Java Programming

Core Java from syntax to object-oriented design, collections and exception handling.

Duration
3 months
Fee
₹7,000

View course

Want to talk it over first?

Tell us what you already know and what you want to be able to do. We'll suggest where to start, explain the fees and timings, and show you the lab. No pressure to sign up.

Enquire About AdmissionWhatsAppCall
CallWhatsAppEnquire