Dr. B.R. AMBEDKAR OPEN UNIVERSITY

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

EDUCATION AT YOUR DOORSTEP

SKILL DEVELOPMENT PROGRAMMES

Web Designing with PHP & MySQL

45-Day Skill Course | Online Mode | Fee: ₹2,000/-

1. Programme Overview

The Web Designing with PHP & MySQL course is a 45-day skill development program designed to provide learners with comprehensive knowledge of building dynamic, database-driven web applications. It covers PHP programming, SQL commands (DDL, DML, DCL, TCL), MySQL database management, OOP concepts in PHP, and practical implementation through case studies and exercises.

The course emphasizes hands-on learning through weekly structured modules, enabling students to design, develop, and manage real-time web applications using PHP and MySQL. By the end of the program, learners will gain the skills required to create interactive websites and handle backend data efficiently.

2. Programme at a Glance

Programme Name	Web Designing with PHP & MySQL
Category	Skill Course
Duration	45 Days
Fee	₹2,000/-
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 PHP programming and develop dynamic web pages using server-side scripting.
To learn SQL commands and database management techniques using MySQL for data handling and manipulation.
To apply object-oriented programming concepts in PHP for building modular and reusable applications.
To integrate PHP with MySQL for developing real-time, data-driven web applications.
To gain practical experience through case studies, coding exercises, and project-based learning.

4. Syllabus

Module 1
Basics of PHP

Introduction to PHP
Arrays and Functions in PHP
OOPs using PHP

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

Completing this course opens entry-level opportunities and builds a strong foundation for careers in web development and software industries:

Junior PHP Developer — Developing and maintaining dynamic websites using PHP and MySQL for real-time applications.
Web Developer (Entry-Level) — Designing responsive and interactive web pages with frontend and backend integration.
Backend Developer (Beginner) — Managing server-side logic and database operations for web applications.
Database Assistant / MySQL Developer — Handling data storage, retrieval, and query optimization using MySQL.
Web Support / Technical Support — Maintaining websites, troubleshooting, and ensuring smooth performance.

7. Further Opportunities

Builds a strong foundation in advanced PHP frameworks like Laravel and CodeIgniter.
Enhances employability in IT companies, startups, and digital service sectors.
Enables freelancing, website development, and client-based project opportunities.
Supports career growth in e-commerce, CMS, and dynamic web applications.
Prepares learners for APIs, cloud deployment, and scalable web solutions.
Aids in technical interview preparation and competitive exams in IT.
Encourages entrepreneurship through development of business and startup websites.