SYLLABUS OF DCA
P1- Computer Essentials
Introduction to Computer, Characteristics of a Computer, Generation of computers, Introduction to the binary system, Components of a Computer, Input units, Output units, Processing units, Storage, Classification of computers, Networking, Software and Installation, Operating systems, Computer languages, Plug ins, Applications of Computer. DOS, Operating Systems (Windows/Linux)
P2 – MS Office & Internet
Word Processing in detail, Spreadsheet (Excel) in Detail, Presentation in Ms-PowerPoint or Equivalent, Outlook Express, FrontPage, MS Access, System Tools, Virus, Internet & E-Commerce and Typing (Word Processing).
P3 – Programming in C & C++
An Overview of “C” Programming, Control Structures, Macro, Arrays, Pointers, Memory Allocation, Character Handling, String Handling, User Defined Data Types, Functions, Header File Creation, Storage Class, Numerators, Enumerators, File Handling, Graphics, Data Structures, Arrays, Stacks, Queues, Linked List, Tree, Searching, Sorting, Binary Search Tree, Graph, Files.
Object-Oriented Programming, Data types, Operators and Expressions, Decision statements, Loop control statements, Arrays, Pointers, Structure and Union, C++ functions, Classes, Constructors and destructors, Overloaded operators, Inheritance, C++ I / O, Recent enhancements to C++.
P4 – RDBMS
Introduction of Database and DBMS, Advantages and disadvantages of DBMS, components of DBMS, Levels of Architecture, Instance and Schemes, DBMS facilities, Database users, Data dictionaries, Entity Relationship models, attributes, mapping constraints, aggregation, Mapping cardinalities, Entity sets and Relationship sets, Traditional Data Models, Relational Model, Relations, Normalization, Relational Algebra, Tuple Oriented Relational Calculus, Relational Database Design, Demoralization, Overview of Advanced DBMS.
Introducing Oracle, Primary Tools, Schema Manager for Tables, SQL for Queries, SQL for Data Manipulation, SQL for Tables, SQL for Views and Sequences, SQL *Plus for Reports, PL / SQL.
P5 – Web Designing & Development
Introducing HTML, Getting Started, Under Standing The Basic Tags, Tags That Affect The Appearance of your text, Indenting and Creating Spaces with & nbsp and Creating Lists, Creating Links, Images ,Tables, Frames, Animation, Forms, CSS, More Text Formatting, Image Maps, DHTML, Internet and Computer Jargon, Fun with Java Script, Adding Music to Your Web Pages
Introduction to PHP, Variables, Operators and Expressions, Loop , String, Control Statements, Functions, Arrays, String Handling , Cookies, Sessions, Forms, HTML Web Page Data Handling, Network Handling, Using My SQL Databases, Sourcing and Configuring PHP, Shopping Cart Application in PHP, Designing PHP-Based Solutions.