PGDCA Syllabus 2024

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.

PGDCA Exam Links

Tentative PGDCA Exam Syllabus for mainly 4 subjects is given below:

• Problem Solving using C
 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)
• Computer Networks:
 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.

Direction for Your Career

Copyright @2024.www.collegedisha.com. All rights reserved