Basic DBMS Terminology, Database System versus File System, Keys, Entity Relationship Model, Relational Model.
SQL: Query Processing and Optimization, Transaction Processing, Locking Techniques, Database Recovery and Security, Distributed Database System.
7. Network Management & Information Security:
Network Management: Standards, Functions, SNMPv1 Protocol. Cryptography Techniques and Encryption Algorithms (DES & RSA), Network Attacks, IPSec, Network Scanning, Security of web Browsers and Servers, Firewalls and Intrusion Detection System.
8. Software Engineering:
Software Development Paradigms and Models, Information Gathering, Software Requirement Specification, Software Process and Design, Modular Design, Process vs. Data Oriented Design. Software Testing: Functional and Structural, Testing Tools. Software Maintenance, Software Quality Assurance, Concept of Object Oriented Software Engineering.
9. Data Warehousing & Mining:
Data Warehousing: Introduction, Architecture, Implementation, OLAP, Data Cleaning, Data Reduction, Data Integration and Transformation, Data Compression. Data Mining: Data Mining Concepts, Data Mining Primitives, Architecture of Data Mining System, Data Mining Techniques, Mining Class Comparison, Mining Descriptive Statistical Measures, Associative Rule Mining, Apriori algorithm, Classification and Prediction, Mining of WWW.
10. Web Design and Development:
Introduction to Internet, WWW, Scripting for Web Browser Portability, Client Vs Server Side Web Development, HTML, DHTML, XHTML, Java Script and Introduction to PHP.
11. Emerging Technologies in the field of IT:
E-Commerce, Multimedia, Expert Systems, Machine Learning Techniques (Genetic Algorithm, BP algorithm & Fuzzy logic), Concept of Cyber Crimes and Cyber Laws.