Post Graduate Diploma in Computer Application (PGDCA)

Self-Paced

Fee:

₹14,999

Dr. Priti Maheshwary | Dean Future Skills Academy

₹14,999

Dr. Priti Maheshwary

1 Year

153

40 Yes

Aisect Learn

English

1 Year

Yes

Post Graduate Diploma in Computer Application (PGDCA) is a 1-year course focusing on advanced theoretical and development knowledge of Computer Science and computer applications in the field of Information Technologies for students from all backgrounds. PGDCA extensively deals with the theoretical and practical aspects of Computer software and its applications. PGDCA courses focus on imparting knowledge to its students on various subjects like Database Management Systems, Operating Systems, MS Office Package and Programming Languages. Eligibility Criteria : Must have completed (Bachelor’s degree) from a recognized university or educational institution

Objectives

PGDCA extensively deals with the theoretical and practical aspects of Computer software and its applications. PGDCA courses focus on imparting knowledge to its students on various subjects like Database Management Systems, Operating Systems, MS-Office Package and Programming Languages.

After successfully competing for this certification, the candidates will know the History and Generation of Computer.

Classification of Computers.

What are the various hardware devices?

How to resolve basic breakdowns in hardware.

Learn typing skills.

Work effectively on MS Excel, Word and PowerPoint

What Will You Learn

Candidates will learn fundamentals of Computers and IT, Windows Operating System, MS Word, MS Excel, and MS PowerPoint. They will understand Computer Networks, Programming with C++, RDBMS, Accounting with Tally, Programming with Visual Basic .NET, and Concepts of Entrepreneurship.

Storage devices & their physical structure

Operating system & file system

Computer networks

MS-word, MS-excel &Power Point, Outlook

Programming concept coding

Debugging & testing of the program

Evolution of internet

HTML, DHTML, XML, .NET, PHP, JAVA, JavaScript, AJAX, VB.NET, C# & CSS.

Communication skills

Compile, Link & execute the C++ programs

SQL constructs basic statements

Concepts of accounting and inventory Tally configuration

SKILLS YOU WILL GAIN

Storage devices & their physical structureOperating system & file systemComputer networksMS-word, MS-excel &Power Point, OutlookProgramming concept codingDebugging & testing of the programEvolution of internetHTML, DHTML, XML, .NET, PHP, JAVA, JavaScript, AJAX, VB.NET, C# & CSS.Communication skillsCompile, Link & execute the C++ programsSQL constructs basic statementsConcepts of accounting and inventory Tally configuration

Want to know more about the course

Prepare for your career path

Software Developers design software solutions by building programs, applications, and websites.

Key Skills To Learn

Fundamentals of Computers & Information Technology, Windows & MS-Office (MS-word, MS-excel & Power Point, Outlook), Programming Methodology & Programming in Foxpro, Computer Network & Internet , Communication Skills and Personality Development, Safety Practices in the Work Environment, Object Oriented Programming with C++, RDBMS and SQL, Computerized Accounting with Tally, Programming with Visual Basic .Net, Entrepreneurship

Jobs in India

More than 50 k per year

Average Salary

2-5 LPA

Job Growth

35%

Jobs in India

More than 50 k per year

Average Salary

2-5 LPA

Job Growth

35%

Learn from the industry experts and stay ahead of the curve

Curriculum

Introduction to Computers

History of Computers

Generation of Computers.

Classification of Computers

Understanding Hardware

Modern I/O devices & Storage View

Memory

Software

Humanware & Firmware

Interacting with Computer

Malicious Programs

Typing Skills

Introduction

Understanding Desktop and its features View

Using windows App : Calculator

Using windows App : Notepad

Using windows App : Paint

Using windows App : WordPad

Using File Explorer

Performing primary settings

Introduction to Word Processing and MS Word View

Working with Text and File View

Formatting

Page Layout and Breaks

Working with Tabs and Lists

Inserting illustrations

Style and Themes

Working With Tables

Miscellaneous Features

Using Mail Merge

Introduction and facts

Entering and Editing information's

Creating and Formatting Spreadsheet View

Working With Sheets

Using Formula

Working with Data (part 01)

Working with Data (part 02)

Excel Functions

Working with Charts

Pivot Tables

What if Analysis

Introduction to PowerPoint

Creating Presentation

Editing Contents

Formatting Contents

Using Transition and Animation

Customizing Slide Design View

Using Hyperlink and Action Buttons

What is Computer ?

Types of Network

OSI Model

Introduction to Internet

Using Email

Definition & Importance

Reading

Writing

Speaking

Safety Signs And Color At work

First Aid and Artificial Respiration

Safe Lifting and Carrying Techniques

Fire and Fire Extinguishers

Introduction to Internet

TCP/IP – Internet Technology and Protocols

Internet connectivity

Internet Network

Services of Internet (Definition and Functions)

Electronic Mail

Web Publishing

World Wide Web

Browsers

Hyper Text Markup Language Programming Basics

Introduction to C++

Building Blocks of ‘C++’ Language

Data Types in ‘C++’ Language

Structure of a C++ Program

Variables and Constants

Input and Output Operations

Comments in C++

Operators in C++

Control Statements in C++ (Branching) View

Control Statements in C++ (Looping)

Break and Continue Statements in C++

Practical Questions based on Control Statements

Functions in C++

Arrays in C++

OOP Concepts

Classes and Objects in C++

Constructors in C++

Inheritance in C++

Polymorphism in C++

Abstraction in C++

File streams in C++

Pointers in C++

What is RDBMS SQL

Installation SQL and Workbench

MySQL workbench and command line client

Data Types in SQL

Operators in SQL

SQL Database (create ,Drop, Rename, select)

SQL tables and constrains

Table operations(create ,drop ,delete ,rename, copy ,alter)

Inserting data into tables

SQL Select Query

Operators in SQL (Arithmetic ,Comparison ,Logical)

SQL clause "where"

aggregate functions

Update query

Delete query

Pattern matching operator "LIKE"

SQL order by

SQL group by

SQL clause having

Practical Question

Meaning of Accounting

Terminologies used in Accounting

Concepts of Accounting

Double Entry System of Accounting

Golden Rules of Accounting

Introduction of Tally Prime

Features of Tally Prime

Versions of Tally

Working Tally Prime in Educational Mode , Company Creation and Setting up Company Features in Tally Prime

Alter Company Details

Shut the Company

Backup of Company Data ,Restoring of Company Data (meaning)

Backup and Restoring of Company Data in tally

Creation of Budget, Recording Transactions

Display Budgets and Variances Reports for Group Budget

GST Tax Structure

Creation of Company and Activating GST

GST Modes of Payment

Direct Tax and Indirect Tax system in India

GST Modes of Payment

Direct Tax and Indirect Tax system in India

Dot Net Framework

Visual Studio

Integrated Development Environment

Language Blocks

Control Statement

Working With Forms

GUI Programming with Windows Forms

Working With Menu

Object-Oriented Programming

The Concept of Entrepreneurship

Theories of Entrepreneurship

Growth of Entrepreneurship

Nature and Importance of Entrepreneur's

The Classification And Types of

Nature and Scope of Management

Planning(Concept,Process and Types)

Concept of Organization

Motivation

Leadership

Communication

Accounts for Small Enterprise

Enterpreneurship Development Institutions

AISECT Model of Entrepreneurship

How to Step up an Aisect Centre

Training for Self Employment

Instructor

Dr.Priti Maheshwary

Dean Future Skills Academy

IT, Computer Science

Presently working in Future Skill Academy. Involved in Computer Science and Engineering for over 20 years in higher education and training. Her career has included various software development projects, teaching, research and administrative roles. She enjoys teaching and looking into how to improve student learning experience. Published around 50 research papers in refereed journals and conferences, 7 book chapters, 6 Patents. 8 PhD thesis completed under her guidance in the field of Internet of Things, Smart Cities, Ubiquitous Computing, Wireless Sensor Network, VANET, Image Processing specialized in Satellite Images, AI/ML & Deep Learning, and Cyber Security. Also done more than 10 projects in the field of Research and Consultancy.

4.9 1045 ratings

1100 Learners

Shubhjeet Dutta

IT Trainer and Social Entrepreneur

Information Technology

Started teaching in the year 1988. He established his training center in 1992 at Bilaspur, and then became affiliated with AISECT in 1994.
Apart from training and skilling students of AISECT, he leads many innovative pilot projects under the banner of AISECT and developed the required software. Currently engaged in training of students, trainers, website, and web application development. He also provides free education and skill upgradation to underprivileged youth under the banner of various social organizations

945 Learners

Shareable Certificate

Other Details