DABC Course Syllabus

DBMS and Business Intelligence

• Introduction to Database Management System
• E/R Model
• Normalization
• SQL, PL/SQL
• Query Processing and Optimization
• Database Design using Oracle 11g
• Database Administration

Data Warehousing and Data Mining

• Concept of Data-ware House
• Data cube concept and operators
• Dimensions and Measures
• Different schema model
• Different real time applications
• Data mining algorithms

Linux Operating System

• Operating System Concepts
• Case Study: Linux Operating System
• Linux commands
• Linux Shell Programming

Object Oriented Analysis and Design & Unified Modeling Language

• Object oriented concepts
• Modeling and Design Techniques
• UML basics and building blocks
• Use cases

Core Java & Data Structures using Java

• Classes and Objects
• Packages
• Exceptions
• Inner Classes, Abstract Class and Interface
• Event Delegation through Listener interfaces and Adapter classes
• Serialization and Externalization
• Threads and Synchronization
• Collection Framework
• GUI Development using AWT and Swing
• LinkedList, Priority Vectors, Sorting – Quick Sort, Radix Sort, Trees - Binary Search Tree, Tree Traversals

Network Computing

• Client/Server systems and multi-tier systems
• Internet and Intranet, Virtual Private Networks
• Web and Application Servers: IIS, Apache, Apache Tomcat
• HTML and XML Technologies
• JavaScript, CSS, AJAX

Platform Independent Computing

• Java EE application model
• Servlets, JSP, JSTL
• EJB 3.0
• Hibernate
• Struts, Spring
• .Net Framework
• C#
• ASP.Net

Network Protocols

• Introduction to LAN, MAN, WAN
• Overview of TCP/IP protocol stack
• Application protocols
• Multimedia over IP (Voice/video over IP)

Web Services

• SOAP
• WSDL
• UDDI
• SOA
• JAX-WS

Web Application Security

• Principles of Security: Issues, Services & Mechanisms
• Firewalls and Network Segmentation
• Cryptographic Algorithms & PKI Infrastructure
• Application Layer Security
• TLS & IPSec VPN
• Input Validation, Web Application
• Vulnerabilities: Retrieving application source code, Sifting through source code for hidden secrets, Remote Code Execution, e-Shoplifting, Impersonation using cookies, Buffer Overflows, Format String Vulnerabilities, SQL injection, Cross-site scripting, Canonicalization
• Secure Coding Guidelines in Java
• Security testing and Code reviews

Software Technology Update

Software Project Management and Testing Methodologies

• Software development life cycle
• Phases of software development
• Software Project management
• Fundamentals of testing
• Testing methodologies
• Types of testing
• Testing process
• Test Case Design

Cloud Computing

• Virtualization Tools & techniques
• Cloud Computing Architecture
• Types of Cloud
• On demand Computing
• Virtualization at the infrastructure level
• Large Data sets and the handling issues
• Security in Cloud computing environments
• MapReduce using Hadoop
• Examples of Cloud platforms
• Developing Applications using ANEKA
• Deploying Java Application on Google Infrastructure using Google App Engine

Semantic Web

• Introduction to Semantic Web
• Resource Description Framework
• SPARQL query Language
• Web Ontology Language
• JENA - A Semantic web framework for Java

Project & Seminar