PGDCA Syllabus: Post Graduate Diploma in Computer Applications (PGDCA) Course is a 1-year course that is bifurcated into two trimesters.
➥ The PGDCA Exam Syllabus is prescribed by the concerned authority of various colleges or universities on their official website. The candidates must visit the website of their respective colleges to download their exam syllabus to be able to give various papers of the PGDCA Course more confidently.
➥ PGDCA Exam Syllabus is prepared to provide the right direction to the candidates in terms of their preparation for various exams under this course.
➥ Every college and university may have their different PGDCA Exam Syllabus and the students should stick to the syllabus prescribed by their college or university only.
The candidates can find a tentative syllabus of various papers taught in the PGDCA Course but they should keep in mind that PGDCA Exam Syllabus may vary from college to college.
Tentative PGDCA Exam Syllabus for mainly 4 subjects is given below:
|
Topics
|
Sub-Topics
|
|
Problem Solving Approach
|
- Introduction to Programs and Algorithms
- Algorithm Devising
- Basic Features of an Algorithm
- Algorithm Design using Pseudo Codes
- Algorithm Implementation
- Program Verification
- Flowcharts: Symbols and Conventions
|
|
Basic Concepts of C
|
- Character Set
- Keywords, Identifier, Constants, and Variables
- Constant Types-Numeric and Character Constants
- Data Types
- Operator and Expression
- Precedence and Associability of Operators
- Managing Console etc.
|
|
Functions
|
- Library Functions, User Defined Functions, Function Declaration and Function Definition
- Function Arguments
- Function Calls
- Returning Multiple Values from a function, Recursion and Recursive Function etc.
|
|
Arrays, Strings and Pointers
|
- Single Dimensional Array
- Accessing Array Elements
- Initializing an Array
- Multidimensional Arrays
- Initializing Multidimensional Arrays etc.
|
|
Structure, Union, Enumeration, and Files
|
- Structure Declaration and Initialization
- Accessing Structure Members
- Structure Assignments
- An array of Structures and Array within structures
- Nested Structured
- The structure as Function Arguments
- Structure Pointers
- Unions etc.
|
- Web Technology and Internet
|
Topics
|
Sub-Topics
|
|
Internet Principals
|
- Introduction to the Internet
- Clients Server Module
- Protocol
- Internet IP Address
- Domain Name
- Internet Services
- Electronic Mail
- World Wide Web
- Internet Security
- Electronic Commerce etc.
|
|
Introduction to HTML
|
- A Brief History
- HTML Tag
- HTML Documents
- Header Documents
- Body Sections
- Heading etc.
|
|
Frames and Forms
|
- Frames Definition
- Frames
- Nested Frames
- Elements of Form
|
|
Elements of Javascript
|
- Data Types
- Variables
- Operators
- Conditional Statements
- Array Objects
- String Objects
|
|
Server-Side Scripts with JSP
|
- Clients Responsibilities
- Server Responsibilities
- Introduction to JSP
- JSP Architecture
- JSP Servers
- JSP Tags
- Request Objects
|
|
JSP with JDBC
|
- Creating a JDBC Data source name
- Introduction to JDBC
- Prepared Statement Class (SQL Statement)
|
|
Topics
|
Sub-Topics
|
|
Introduction to Computer Networks
|
- Definition of Computer Networks
- Application of Computer Networks
- Kinds of Computer Networks: Local Area Network, Wide Area Network, Metropolitan Area Network
- Topologies of Networks
- Layered Architecture of Networks
|
|
Fundamentals of Data Communication
|
- Types of Signals
- Types of Transmission
- Modes of Transmission
- Serial Transmission
- Parallel Transmission
- Basic Transmission Categories- Simplex, Half Duplex, Full Duplex
|
|
Fundamental of Networks
|
- Point to Point Networks
- Broadcast Networks
- Multicast Networks
- Physical Layer Coding Techniques
- Differential NRZ
- Manchester
- Different Manchester Coding
- Switching etc.
|
|
Layered Architectures
|
- Layered Architectures, TCP/IP Model, OSI Model. Overview of Physical Layer, Data Link Layer, MAC, Network Layer, Transport Layer Functions, etc.
|
|
LAN Technologies
|
- CSMA/CD or Ethernet
- IEEE 802.3 Standard
- Token Bus
- IEEE 802.4 Standard
- Token Ring
- IEEE 802.5 Standard
- Overview of DNS, FTP, TELNET, HTTP, SMTP, and Client/Server Computing
|
- Database Management Systems
|
Topics
|
Sub-Topics
|
|
Database
|
- Data, Database, and Database Management System
- Database vs. Traditional File System Approach
- Three Schema Architecture of DBMS
- Data Independence
- Classification of DBMS
- Centralized and Client-Server Architectures for DBMS etc.
|
|
Database Models
|
- Introduction
- Categories of Database Models
- Object Data Models
- Entity-Relationship (ER) Diagram: Basic Concepts and Representations- Entity, Entity Type and Entity Set, Attributes and Keys, Relationships, Relationship Types, and Structural Constraints
- Weak Entity
- Naming Conventions
- Design Issues in ER Models etc.
|
|
Relational Database Models
|
- Structure of the Relationship Model
- Domains
- Attributes
- Tuples and Relations
- Characteristics of Relations
- Relational Constraints- Domain Constraints, Key Constraints, Entity Constraints, and Referential Integrity Constraints
- Relational Database Schema
- Relational Algebra Operations- Select, Project, Rename, Union, Intersection, Set Difference, Join and Division Operations, etc.
|
|
Functional Dependencies and Normalization
|
- Informal Design Guidelines for Relation Schemas
- Functional Dependencies
- Inference Rules for Functional Dependencies
- Normalization using Functional Dependencies- 1NF, 2NF, 3NF
- Boyce-Codd Normal Form
- Relation Decomposition and insufficiency of Normal Forms
- Dependency Preserving and Lossless Join Decompositions
- Null Values
- Dangling Tuples etc.
|
|
Oracle and Structured Query Languages (SQL)
|
- Introduction to Oracle
- Features of Oracle
- Form Design
- Schema and Table Deletion
- Table Modification
- Insert, Select and Update Statements
- SELECT-FROM-WHERE Structure
- Renaming Attributes
- Nested Queries and Set Comparisons etc.
|
✍ Note: This PGDCA Exam Syllabus is given just to give an idea of the topics under these 4 subjects but this is not an exhaustive list. Different colleges and universities may add or delete the topics which are included in the subjects as per their discretion.
Importance of PGDCA Syllabus 2024:
PGDCA syllabus is an important asset that sets the standard of what is expected to come in the examination. It prescribes what topics and concepts will appear in the examination:
- It established a road map for the applicants by stating the objectives and goals to be achieved in order to crack the PGDCA Examination.
- It includes useful information that will facilitate the success of an applicant.
- It provides the exam structure, goals, and learning outcomes
- PGDCA syllabus describes the topics and concepts which should be covered while preparing for the examination.
- The PGDCA Exam Syllabus also maintains the wastage and allotment of different units and chapters so a candidate can know which strategy to create in order to crack the examination according to the preparation of chapters with high and low weightage.
- Having a clear understanding of the PGDCA Paper Syllabus and weightage involved in the various topics and sections will help a candidate to decide how much time he should invest in that particular topic of the section.
- Generally, PGDCA Exam is designed as per the syllabus prescribed by the official authority. So preparing according to the topics and instructions mentioned in the syllabus will obviously help a candidate to crack the examination.
