DCA (Diploma in Computer Application) Syllabus, Subjects, Books, Course Curriculum 202

DCA or Diploma in Computer Application is a one year diploma program, which is usually divided into two semesters and students are also required to submit a project work on a given relevant topic in their last semester.

From introducing computers, project management to operating systems, computer graphics and even more, DCA covers all the aspects of computers to make a student industry-worthy.

Important Links

DCA Career Options	Top Computer Application Courses in India	Top Computer Application Colleges in India

DCA Syllabus

Below mentioned is the detailed semester wise syllabus and topics covered in DCA that one can check to know what the course has stored in for them. However, there can be variations in syllabus depending on the university chosen.

Semester 1	Topics Covered	Semester 2	Topics Covered
Computer fundamentals	Functions, applications, classification and components of computer, various types of devices and concepts of windows in detail	Database System	Data models, rdbms, table design, key, data definition language, data control language SQL queries
Office Automation	Aspects of Microsoft tools in details like MS-Word, MS-Excel, MS-PowerPoint, etc.	App development	Introduction to programming, PHP basics, PHP advanced, PHP database connectivity,PHP database management
Network Fundamentals	Network devices, types of networks, internet and intranet and network protocols and anti-virus	Project work	Related to web designing, using PHP, MySQL AND reports will be supplied
Web design	Working of HTML in detail, phrase tags, meta tags, hyperlinks and frame management	-	-
Java Script	Basics of JavaScript, JavaScript Syntax, placing JavaScript, cookies, page redirection, dialog box and xml fundamentals	-	-

DCA Books

In order to be able to cover the above mentioned syllabus properly, here are a few prevalent books mentioned for DCA that may help the students in acquiring knowledge and understanding of the subject in an elaborate manner.

DCA Books	Authors
Diploma in Computer Application	Madhur Kumar Telang
Introduction to computer and programming using python	John.V.Guttag
Comprehensive Computer Learning	B. kumar
Java The Complete Reference	Herbert Schildt
Operating System	Dr. Mohamed Rafi Mr. Vikram Sindhu.S