Post Graduate Diploma in Computer Application (PGDCA)
Self-Paced
Fee: ₹14,999
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.
Skills you will gain
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
Accountants are responsible for financial audits, reconciling bank statements, and ensuring financial records are accurate throughout the year.
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
A web designer creates the layout and design of a website. In simple terms, a website designer makes a site look good. They use design programmes to create visual elements and usually have expertise in user interface (UI), which means they strategically design a site that's intuitive and easy for visitors to navigate
Key Skills to Learn
Fundamentals of Computers & Information Technology, Windows & MS-Office (MS-word, MS-excel & Power Point, Outlook), Programming Methodology Object Oriented Programming with C++, RDBMS and SQL,
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
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"
IT Consultants provide technical support in building and implementing IT systems for internal as well as external clients.
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%
Curriculum
-
Fundamentals of Computers and IT
-
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
-
-
Windows & MS-Office (MS-word, MS-excel & Power Point, Outlook)
-
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
-
-
Computer Network & Internet
-
What is Computer ?
-
Types of Network
-
OSI Model
-
Introduction to Internet
-
Using Email
-
-
Communication Skills and Personality Development
-
Definition & Importance
-
Reading
-
Writing
-
Speaking
-
-
Safety Practices in the Work Environment
-
Safety Signs And Color At work
-
First Aid and Artificial Respiration
-
Safe Lifting and Carrying Techniques
-
Fire and Fire Extinguishers
-
-
Introduction to Internet
-
Introduction to Internet
-
Introduction to Internet
-
TCP/IP – Internet Technology and Protocols
-
Internet connectivity
-
Internet connectivity
-
Internet Network
-
Services of Internet (Definition and Functions)
-
Electronic Mail
-
Web Publishing
-
World Wide Web
-
Browsers
-
Hyper Text Markup Language Programming Basics
-
Hyper Text Markup Language Programming Basics
-
-
Object Oriented Programming with C++
-
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++
-
-
RDBMS and SQL
-
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
-
-
Computerized Accounting with Tally
-
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
-
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
-
-
Programming with Visual Basic .Net-Ebook
-
Dot Net Framework
-
Visual Studio
-
Integrated Development Environment
-
Language Blocks
-
Control Statement
-
Working With Forms
-
Working With Forms
-
GUI Programming with Windows Forms
-
Working With Menu
-
Object-Oriented Programming
-
-
Introduction to Entrepreneurship -Ebook
-
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
-
-
Project
Instructor
Dr.Priti Maheshwary
Dean Future Skills AcademyPresently 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.
Shubhjeet Dutta
IT Trainer and Social EntrepreneurStarted 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
Shareable Certificate
Other Details
Post Graduate Diploma in Computer Application
Get job assistance and jumpstart your career as Computer Programmer and Operator
FAQs
-
Does this course include certificate?
yes
-
Does this course have lifetime access or limited period access?
No, 1 year access
-
Is this course available in Hindi Version as well
No