Best Seller Icon Bestseller

Achievement In PGDCA(S-AP-6618)

  • Last updated Oct, 2026
  • Certified Course

Course Includes

  • Duration1 Year
  • Enrolled0
  • Lectures300
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

PGDCA (Post Graduate Diploma in Computer Applications) is a comprehensive computer applications course designed to develop strong practical and professional skills in computer technology, programming, database management, web development, networking and office applications.

The course covers computer fundamentals, MS Office, Advanced Excel, DBMS, MySQL, C, Java, Web Designing, PHP, Software Engineering, Networking, Data Structures and practical project development.

Students gain hands-on experience through practical exercises and real-world projects, helping them prepare for careers in IT, software development, web development, database management and computer applications.

🎯 What You Will Learn

  • Computer fundamentals and operating systems
  • MS Word, Excel and PowerPoint
  • Advanced Excel and MIS reporting
  • Database management and MySQL
  • C and Java programming
  • Data structures and algorithms
  • HTML, CSS, JavaScript and Bootstrap
  • PHP and MySQL web development
  • Software engineering concepts
  • Computer networking fundamentals
  • Internet, cloud and digital technologies
  • Basic graphics and multimedia
  • Practical project development
  • Debugging, testing and documentation

👨‍🎓 Who Can Join?

  • Graduates from any stream
  • Students interested in computer applications
  • Working professionals looking to develop IT skills
  • Candidates preparing for IT-related jobs
  • Students interested in programming and web development
  • Anyone looking for a comprehensive computer applications qualification

📌 Prerequisite

  • Graduation from a recognized university/institution
  • Basic knowledge of computers is helpful but not mandatory

🚀 Course Outcome

After completing PGDCA, students will be able to:

  • Work confidently with computer applications
  • Create professional documents, spreadsheets and presentations
  • Design and manage databases
  • Develop basic software applications
  • Create dynamic websites using PHP and MySQL
  • Understand programming and data structures
  • Perform basic networking and troubleshooting
  • Develop and present practical IT projects
  • Build a foundation for further studies and IT careers

💼 Career Opportunities

  • Computer Application Executive
  • Computer Operator
  • Data Analyst – Entry Level
  • Web Developer – Entry Level
  • PHP Developer – Entry Level
  • Database Assistant
  • IT Support Executive
  • Software Support Executive
  • MIS Executive
  • Office Automation Executive
  • Junior Programmer
  • Technical Support Executive


Show More

Course Syllabus

Module 1 – Computer Fundamentals

  • Introduction to Computers
  • Characteristics and Applications of Computers
  • Computer Generations
  • Types of Computers
  • Hardware and Software
  • Input and Output Devices
  • Memory and Storage Devices
  • Number System Basics

Module 2 – Operating System

  • Introduction to Operating Systems
  • Windows Operating System
  • Linux Basics
  • File and Folder Management
  • System Settings and Utilities
  • Software Installation and Uninstallation
  • Basic Troubleshooting

Module 3 – MS Word

  • Introduction to MS Word
  • Document Creation and Formatting
  • Page Setup and Layout
  • Tables and Lists
  • Headers and Footers
  • Styles and Templates
  • Mail Merge
  • Printing and PDF Creation

Module 4 – MS Excel

  • Excel Interface and Workbook Management
  • Data Entry and Formatting
  • Formulas and Functions
  • Relative and Absolute References
  • Mathematical and Statistical Functions
  • Logical Functions
  • Text and Date Functions
  • Sorting and Filtering
  • Charts and Graphs

Module 5 – Advanced Excel

  • Lookup Functions
  • IF, AND, OR Functions
  • VLOOKUP, HLOOKUP and XLOOKUP
  • Data Validation
  • Conditional Formatting
  • Pivot Tables and Pivot Charts
  • What-If Analysis
  • Dashboard and MIS Reports
  • Basic Excel Automation

Module 6 – MS PowerPoint

  • Presentation Creation
  • Slide Layouts and Themes
  • Text, Images and Shapes
  • Tables and Charts
  • SmartArt
  • Animations and Transitions
  • Audio and Video
  • Professional Presentation Design

Module 7 – Database Management System

  • Introduction to DBMS
  • Database Concepts
  • Tables, Records and Fields
  • Keys and Relationships
  • Database Design
  • Normalization
  • SQL Fundamentals
  • Data Manipulation
  • Database Security

Module 8 – MySQL

  • MySQL Introduction
  • Database and Table Creation
  • INSERT, UPDATE and DELETE
  • SELECT Queries
  • WHERE, ORDER BY and GROUP BY
  • Aggregate Functions
  • Joins
  • Subqueries
  • Views
  • Basic Database Administration

Module 9 – C Programming

  • Introduction to Programming
  • C Language Fundamentals
  • Variables and Data Types
  • Operators
  • Conditional Statements
  • Loops
  • Arrays
  • Strings
  • Functions
  • Pointers
  • Structures and Unions
  • File Handling

Module 10 – Object-Oriented Programming

  • Programming Concepts
  • Introduction to OOP
  • Classes and Objects
  • Encapsulation
  • Inheritance
  • Polymorphism
  • Abstraction
  • Constructors and Methods
  • Practical OOP Programs

Module 11 – Java Programming

  • Introduction to Java
  • Java Development Environment
  • Variables and Data Types
  • Operators
  • Conditional Statements
  • Loops
  • Arrays and Strings
  • Classes and Objects
  • Inheritance
  • Exception Handling
  • Collections Basics

Module 12 – Web Designing

  • Introduction to Web Technology
  • Internet and Web Concepts
  • HTML Fundamentals
  • HTML Forms
  • CSS Fundamentals
  • Responsive Web Design
  • Bootstrap Basics
  • JavaScript Fundamentals
  • Web Page Development

Module 13 – PHP Programming

  • Introduction to PHP
  • PHP Syntax
  • Variables and Data Types
  • Operators
  • Conditions and Loops
  • Functions
  • Arrays and Strings
  • Forms and Form Handling
  • Sessions and Cookies
  • PHP with MySQL

Module 14 – Software Engineering

  • Introduction to Software Engineering
  • Software Development Life Cycle
  • Requirement Analysis
  • System Design
  • Development Models
  • Testing
  • Maintenance
  • Documentation
  • Software Project Management

Module 15 – Computer Networking

  • Networking Fundamentals
  • LAN, MAN and WAN
  • Network Topologies
  • Network Devices
  • IP Addressing
  • Internet and Intranet
  • TCP/IP Basics
  • Client-Server Concepts
  • Network Security Basics

Module 16 – Internet & Digital Technologies

  • Internet Fundamentals
  • Web Browsers
  • Search Engines
  • Email Communication
  • Cloud Computing
  • Google Workspace
  • Online Collaboration
  • Digital Services
  • Basic Cyber Security

Module 17 – Data Structures & Algorithms

  • Introduction to Data Structures
  • Arrays
  • Linked Lists
  • Stacks
  • Queues
  • Searching Techniques
  • Sorting Techniques
  • Algorithm Basics
  • Time and Space Complexity

Module 18 – Computer Graphics & Multimedia

  • Introduction to Computer Graphics
  • Raster and Vector Graphics
  • Image Formats
  • Basic Graphic Designing
  • Multimedia Concepts
  • Audio and Video Basics
  • Image Editing Fundamentals
  • Digital Media Applications

Module 19 – Practical Projects

Students will work on practical projects such as:

  • Student Management System
  • Employee Management System
  • Inventory Management System
  • Billing System
  • Database Management Project
  • Personal Portfolio Website
  • Dynamic PHP-MySQL Website
  • Excel-based MIS Report

Module 20 – Final Project & Practical Assessment

  • Project Planning
  • Requirement Analysis
  • Database Design
  • Application Development
  • Testing and Debugging
  • Project Documentation
  • Project Presentation
  • Final Practical Assessment


Review

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



Call
Text Message
Review
Email
CHAT