Dr. B.R. AMBEDKAR OPEN UNIVERSITY

డా. బి.ఆర్. అంబేద్కర్ సార్వత్రిక విశ్వవిద్యాలయం

EDUCATION AT YOUR DOORSTEP

SKILL DEVELOPMENT PROGRAMMES

Structured Query Language (SQL)

45-Day Skill Course | Online Mode | Fee: ₹1,500/-

1. Programme Overview

The Structured Query Language (SQL) skill course is a 45-day programme designed to provide learners with a strong foundation in database management and querying techniques using MySQL. The course is structured into four blocks covering twelve units, progressing from basic database operations to advanced querying and database programming.

The course begins with installation and setup of MySQL Server, along with an introduction to MySQL Shell and Workbench tools. Learners are then introduced to core SQL concepts including Data Definition Language (DDL) and Data Manipulation Language (DML) commands with practical case studies.

In the intermediate phase, the course focuses on nested queries, update and delete operations, and advanced query practices. Learners also explore integration aspects such as using MySQL with Excel. The advanced phase covers MySQL programming concepts including DCL, TCL, triggers, coding, forms, and reports. The course concludes with extensive practical exercises to reinforce real-world database skills. By the end of the programme, learners will be able to design, manage, and query databases effectively.

2. Programme at a Glance

Programme Name	Structured Query Language (SQL)
Category	Skill Course
Duration	45 Days
Fee	₹1,500/-
Eligibility	10+2 or Its Equivalent
Pre-Requisites	Laptop / Desktop / Tablet with good Internet connectivity
Mode of Delivery	Online
Medium of Instruction	English
Delivery Timings	Evening — 6 Hours per week
Admission Process	Through University website: www.braouonline.in or www.braou.ac.in

3. Programme Objectives

To understand the fundamentals of databases and SQL using MySQL tools.
To apply DDL and DML commands for creating and managing database structures and data.
To develop skills in writing queries, including nested and advanced queries.
To learn database control concepts such as DCL, TCL, and triggers.
To build practical skills in database management through case studies and exercises.

4. Syllabus

Module 1
Basics of MySQL

Downloading and Installing MySQL Server
MySQL Shell Commands
MySQL Command Line Client & Workbench

Module 2
SQL DDL & DML

SQL DDL Commands
Case Study on SQL DDL Commands
SQL DML Commands with Case Study

Module 3
Querying & Operations

Nested Queries, Update, Delete Commands
MySQL for Excel with Case Study
Advanced Query Practice

Module 4
Advanced MySQL

MySQL DCL, DBA, TCL Commands
MySQL Coding, Triggers
MySQL Forms & Reports

Module 5
Hands-on Practice

Practical Exercises (Block 1)
Practical Exercises (Block 2)
Practical Exercises (Block 3 & 4)

5. Mode of Assessment & Certification

Examination: Online Examination at the end of the Course (1 Hour 30 Minutes) - 50 Marks total.

Passing Criteria: Minimum 20 Marks required.

Certification: A University Certificate will be awarded upon successful completion of the online examination with a minimum of 20 marks out of 50. The certificate is issued by Dr. B.R. Ambedkar Open University, Hyderabad.

6. Job & Career Prospects

Database Assistant (Entry Level) - Supporting database creation, updates, and maintenance
SQL Developer (Beginner Level) - Writing queries and managing database operations
Data Analyst (Foundation Level) - Extracting and analysing data using SQL queries
MIS Executive - Generating reports and managing organizational data
Application Support Executive - Handling database-related issues in applications

7. Further Opportunities

Pathway to advanced roles in Database Administration (DBA).
Foundation for careers in Data Science, Data Analytics, and Business Intelligence.
Useful for learning tools like Power BI, Tableau, and ETL processes.
Enhances employability in both IT and non-IT sectors.