PG Diploma in Computer Application (PGDCA)

Duration : 6 Months or 12 Months | Certification : ECIL - ECIT Certification

Course Description

PGDCA (Post Graduate Diploma in Computer Applications) which covers all the basic needs of any office or govt.dept for data entry and office assistant jobs. The course content includes MS Office, Computer Basics, C++ Programming, Web Designing, SQL, Java, Asp.net, and Software Engineering.

Course Includes :

Hands-On Training
Live Projects
100% Placement Assistance

Course Duration :

Regular Course :   12 Months
Fast Track Course :   6 Months

Course Advantages

  • Certificate can be added to your PSC/UPSC profile.
  • Govt. of India ( ECIL-ECIT) approved certificate
  • Online/Offline Facility Available
  • Latest syllabus and advanced lab facility
  • Excellent Placement Support

Course Features

  • PGDCA is designed for graduate students who are interested in computer applications. This course has been made for students who want to learn computer applications in different fields like banking, insurance and accounting. This program allows students to seek professional knowledge in computer applications.
  • Career Scope as Data Entry Operator, Office Assistant, Office Executive, Bank Clerks, BPO/Call Centers, Office Computer Operators, Computer Teacher, Software Engineer, Computer Programmer & Analyst

What you'll cover in this course

Introduction to Computers PC Architecture And OS Concepts

  • IDP Concepts
  • Introduction to Operating Systems
  • MS – DOS Internal Commands
  • MS – DOS External Commands

MS Word

  • Microsoft Office 2002 Premium
  • Start Word 2002
  • Menus
  • Toolbar
  • Working with files
  • Different ways of viewing document
  • Working with text
  • Formatting paragraphs
  • Lists
  • Tables, Graphics
  • Spelling and grammar
  • Page Formatting
  • Mail Merge in XP
  • Keyboard Shortcuts
  • Creating Web Pages

Ms-Excel

  • Introduction
  • Workbook
  • Worksheet
  • Spreadsheet
  • Basics
  • Modifying a worksheet
  • Formatting cells
  • Formulas and Functions
  • Sorting and filling
  • Filtering and database Tables
  • Charts
  • Pivot Table
  • Protection
  • Macros
  • Goal seek
  • Page Properties and Printing

Ms-Power Point

  • Introduction
  • Power point Screen
  • Working with Slides
  • Working with Text
  • Color Schemes
  • Graphics
  • Slide Effects
  • Master Slides
  • Saving and Printing
  • Keyboard shortcuts

MS ACCESS

  • DBMS Concept
  • MS Access (Office Button)
  • Ms Access Home
  • TABLES, Forms
  • Reports, Query
  • External Data
  • Database Tools
  • Datasheet, Relationship

Programming Techniques And Flowcharting

  • Algorithms and its characters
  • Program Flow Charting and Flow Charting Symbols
  • Control Structures
  • Multidimensional Arrays
  • Single and Multilevel Tables

C++ With OOPS Concepts

  • General OOP concepts
  • Getting started with C++
  • Data handling
  • Operators and expression
  • Algorithms and flow charts
  • Flow of controls
  • Arrays and structures
  • Functions
  • Introduction to OOPs concepts, Classes, Objects
  • Function Overloading
  • Special Member Functions, Constructors
  • Constructors, Destructors, *this pointer
  • Operator Overloading
  • Inheritance
  • Constructors and Destructors in Inheritance
  • Virtual Functions, Polymorphism
  • Streams, Manipulators
  • Exception handling
  • Graphics

Html

  • Introduction
  • HTML Tags
  • Headings on HTML
  • Links on HTML
  • Tables
  • Frames
  • Images
  • External Style Sheet

VB.NET

  • Introduction to VB.Net
  • Introduction to Visual studio.Net
  • Object Oriented Programming
  • GUI Application Development
  • Assemblies
  • Data Access with ADO.Net
  • Delegates
  • Multithreading
  • Windows Control Library
  • Windows Services
  • Interoperability with COM
  • Crystal Reports

ASP.NET

  • Introduction to Web Technologies
  • ASP.Net introduction
  • Server side Controls
  • ADO.Net
  • XML Programming
  • Security in ASP.Net
  • Localization and Globalization
  • Working with Master Pages
  • State Management
  • Introduction to Web Services
  • Introduction to Crystal Reports

RDBMS, ORACLE,SQL PLUS

  • Introduction to RDBMS
  • Data base Concepts
  • Data Module
  • E-R Diagram
  • Difference between DBMS & RDBMS
  • Normalization
  • Client - Server concept
  • Introduction to Oracle
  • Advantages of Oracle
  • Oracle as on RDBMS
  • SQL
  • SQL Concepts
  • Benefits of SQL
  • DDL
  • DML
  • DCL
  • Constraints Operators
  • Function
  • Group By
  • Having Clause
  • Views and Joins
  • Sub Queries
  • SQL Plus
  • Security
  • SQL
  • Reports

JAVA

  • Java Fundamentals : Data Types and Operators Control Statements and Arrays
  • OOP in JAVA: Class Fundamentals Objects and Construction Method Overloading and Overriding
  • Packages and Interface and Inner Classes
  • Access Modifiers Understanding Interface and Using Interfaces
  • Inner Classes in JAVA
  • Exception Handling: Exception types using TTY and Catch throw, throws and finally
  • Multi Threaded Programming: Java Thread Model
  • Thread class, Runnable Interface Thread Priorities and Synchronization
  • Inter Thread Communication
  • Applet Fundamentals and AWT (Abstract Window Toolkit)
  • Applet Basic and Architectures
  • Graphics, Color and Font AWT components/controls Event Handling and Layouts
  • Animation: Images in java playing sound Advanced JAVA programming
  • Network Programming: Packet & Datagram socket
  • Java Data Base Connectivity: Overview of RDBMS/ODBC
  • Introduction to JDBC connecting to various RDBMS products
  • Java as Database Front End JDBC, API
  • Swing (JFC)
  • Light weight component Swing hierarchy top level container intermediate container swing related events
  • Common Gateway Interface
  • Introduction to CGI GET & POST Methods what is name values pair content types
  • \
  • Java Servlets
  • Servlet as an improved CGI Servlet fundamentals Servlet API Running a servlet
  • Remote Method Invocation (RMI) Object Persistence & Serialization
  • Introduction to Distributed computing RMI Architecture RMI for Distributed computing
  • JAVA BEANS – Bean Archi and Bean Event module
  • Bean properties of Bean in for interface
  • Using java been as ActiveX controls
  • JNI-Java Native Interface – Java program with native methods

Project Work

Talk to Our Expert