PACE || Academy for Career Exellence

Post Graduate Diploma in Computer Applications

PGDCA is a government-recognized course, eligible for PSC (Public Service Commission) recruitments

Overview
Content

Course description

Course Description: PGDCA (Post Graduate Diploma in Computer Application)

The PGDCA is a one-year advanced government approved program designed to provide in-depth knowledge of computer applications, focusing on logic building and business applications. The course integrates program coding, database management, communication networks, and website designing through both theory classes and practical lab sessions. It also covers the Office suite extensively, ensuring students gain comprehensive skills essential for modern IT roles.

Duration: 720 Hours (1 Year)
Eligibility: Any Degree

Why is this Course Important?

The PGDCA program is vital for individuals aiming to build a strong foundation in computer applications and software development. In today’s technology-driven world, mastering coding languages, database management, and web development tools is essential. This course equips students with both theoretical knowledge and hands-on experience, making them industry-ready to tackle real-world IT challenges.

Benefits of PGDCA

Technical Proficiency: Gain expertise in multiple programming languages and software tools.
Industry-Relevant Skills: Learn practical applications in web design, database management, and software development.
Career Advancement: Opens doors to high-demand roles in the IT industry.
Project Management: Hands-on projects and seminars develop problem-solving and project execution skills.

What Will You Learn?

Programming languages like Python, C++, Java, VB.Net, and PHP/ASP.Net.
Database management with RDBMS and SQL.
Web designing and development.
Android programming and mobile application development.
Advanced Office Suite and Excel for business applications.
Communication networks and system engineering concepts.
Project management through live projects and seminars.

Who Will Benefit the Most from This Course?

Graduates from any discipline seeking a career in IT.
Aspiring software developers and programmers.
Entrepreneurs aiming to implement IT solutions in business.
Professionals looking to upgrade their technical skills for career growth.
Data analysts and those interested in database management.

Fundamentals of Computer

Computer Fundamentals - Introduction
Functional Organization of Computer
Hardware & Software
Network & Data Communication
Number Systems
Hardware & software requirement for internet
Internet services
Types of personal computers
Algorithm and Flow chart

Operating System

Windows OS - Introduction, Versions and Elements of Windows Screen
MS-DOS Part 1 - Booting Process, Commands and File Types
MS-DOS Part 2- Batch Files and External DOS Commands
Linux OS - Introduction to Linux
Linux OS - Commands
Linux OS - Utilities

Object oriented Programming Languages
principles of oops
Over view of C++
Tokens
Example for C++ Sample Programming
Variables, Data Types and Operators
Arrays in C++
Example for Arrays in C++
pointers
Strings
Other Data Types
Functions
Classes and Objects
Constructors and Destructors
Inheritance and Polymorphism
Managing Console I/O Operations and Working With files
Exception Handling

IF AND OR and SUM if , COUNT IF
Pivot and Vlookup
Sort and Formatting
Powerful Data Analysis
Charts

Introduction to Data Structures
Advanced Sorting Techniques
Searching Algorithms & Stacks
Queues, Linked lists & Binary Trees

Introduction to .NET
VB.NET Basics Part1
VB.NET Basics Part 2
Windows Forms and Common Controls
Containers
Menu & Toolbars
Data, Components and Printing
Dialogs
Crystal Reports
Sub Procedures, Functions n User Control
Class and modules
Sample Exercise using complete Structures with MS SQL Database

Data Communication & Networks

Data Communications
Communication networks
Network types
Multiple Access
Switching
Naming & Addressing
Services & Applications

Android Programming

Introduction to the Android Computing Platform and History
Installing Android Studio
My First Android Application: Its Structure
Running on the Emulator/Device
Android - Layout Editor
Building Apps with Multiple Screens (Destinations)
Understanding the Activity Life Cycle
App Architecture (UI Layer) – Classes, View Model, and Live Data
RecyclerView: Displaying Large Collections of Data
Connecting to the Internet Server to Retrieve and Display Data
Implementing Offline Caching

Introduction to DBMS
Entity and relational Data models
Relational Data Models
Database Normalization
Relational Algebra and Relational Calculus
Backup and Recovery
Database Security and Integrity
Design and Development of Database Applications on CRDBMS
A brief Introduction to Mongo DB (NOSQL DB)

System Engineering

Introduction to System Engineering
Systems documentation consideration
System Planning
Input/output
System Implementation and Maintenance
Introduction to Management Information System (MIS)

Introduction to Python
Python Data Types and Data structures
Flow Control, Functions and Modules
File Handling and Regular Expressions
Object Oriented programming and Exception handling
Towards Data Science

Introduction to Java
Overview of Java language
Constants, Variables and Data Types
Operators and Expression
Decision making and branching
Classes, Objects and methods
Arrays, Strings and Vectors
Inheritance and Interfaces
Packages in Java
Managing errors and exceptions
Multithreaded programming
Java APIs
Network Programming in Java

Introduction to SQL
SQL Commands
Views and Indexes
Sub queries
Joins, Unions, Intersection, Minus
Unions
Cursors in SQL
Embedded SQL
Stored procedures
Functions in SQL
Practical Exercises for SQL

Kotlin Programming

Installation and Kotlin Basics
Handling Nullability and Data Structures
Collections and Functional Programming
Working with Kotlin Collections
Managing Constants in Kotlin
Kotlin Advanced Features
Input and Ouput in Kotlin
Object-Oriented Programming in Kotlin

Web Design with HTML

Introduction to Web designing
Introduction to HTML Part 1
Advanced HTML
Introduction to HTML Part 2
Introduction to HTML Part 3

Microsoft Excel

Introduction
Text functions
Mathematical functions
Logical functions
what is the table and features
Logical function problems
chart
Goal seek and Pivot Table
V Lookup

INTRODUCTIONS TO MS WORD
INSERT TABLE
INSERT SHAPES
PICTURES AND LINK
Header and Footer, Smart Art, Drop Cap, Book Mark
Page design
Layout and View
Mail merge

Microsoft Access

Introduction Table and Data type
Lookup Wizard and Filter
Query
Form and Report

Microsoft Powerpoint

Introduction to Powerpoint
Shapes, Image and 3D
Table, Chart and Link
Create a Presentation
How to use 3D model and Shapes

Introduction to CSS Part 1
Advanced CSS
Introduction to CSS Part 2

Introduction to JavaScript
Data Types
Advanced JavaScript
Control Structures
Functions
DOM Manipulation
Advanced JavaScript
Math Object, array map, filter, reduce and foreach
Project

Duration 1 year
Subjects 21
Lessons 197
+ Certificate Yes