CPSP / Advance Development

Duration : 6 Months

1: N+

  1. Networking Fundamental
  2.  LAN, MAN, WAN
  3.  Topology
  4.  Networking Cables
  5.  OSI Models
  6.  TCP/IP
  7.  IP Addressing and Subneting
  8.  MAC Address
  9.  DHCP/DNS
  10.  Windows Server 2003
  11.  User Account/ Group Account

2: Database

1:Introductory concepts of DBMS :

Introduction and applications of DBMS, Purpose of data base, Data, Independence, Database System architecture- levels, Mappings, Database, users and DBA

2: Relational Model :

Structure of relational databases, Domains, Relations, Relational algebra – fundamental operators and syntax, relational algebra queries, tuple relational calculus

3: Entity-Relationship model :

Basic concepts, Design process, constraints, Keys, Design issues, E-R diagrams, weak entity sets, extended E-R features – generalization, specialization, aggregation, reduction to E-R database schema

4: Relational Database design :

Functional Dependency – definition, trivial and non-trivial FD, closure of FD set, closure of attributes, irreducible set of FD, Normalization – 1Nf, 2NF, 3NF, Decomposition using FD- dependency preservation, BCNF, Multi- valued dependency, 4NF, Join dependency and 5NF

5: Query Processing & Query Optimization :

Overview, measures of query cost, selection operation, sorting, join, evaluation of expressions, transformation of relational expressions, estimating statistics of expression results, evaluation plans, materialized views

6:SQL Concepts :

Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator,
Functions - aggregate functions, Built-in functions –numeric, date, string functions, set operations, sub-queries, correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any, All , view and its types. transaction control commands – Commit, Rollback, Savepoint

3: SDLC (Software Development Life Cycle)

Software Development Life Cycle (SDLC) is a process used by the software industry to design, develop and test high quality softwares. The SDLC aims to produce a high-quality software that meets or exceeds customer expectations, reaches completion within times and cost estimates.

  1. SDLC is the acronym of Software Development Life Cycle.

  2. It is also called as Software Development Process.

  3. SDLC is a framework defining tasks performed at each step in the software development process.

  4. ISO/IEC 12207 is an international standard for software life-cycle processes. It aims to be the standard that defines all the tasks required for developing and maintaining software.

4: Advance Java

  1. Introduction to Advance java and j2ee
  2. Collections
  3. Generics
  4. Dates, Numbers and Currencies
  5. File Navigation and IO
  6. JDBC
  7. RMI
  8. Socket programming
  9. Java script
  10. AJAX
  11. Servlet
  12. JSP
  13. EJB
  14. Struts 2
  15. Hibernate

5: Php with mysql

  1. Introduction To HTML
  2. Introduction to Style Sheet
  3. Introduction To PHP
  4. Strings Functions
  5. Expression Operand And Operators
  6. Control Flow Operations
  7. Loop Operations
  8. Functions
  9. OOP (Object Oriented Programming) Concepts
  10. File Handling
  11. Date Time Handling
  12. Exception Handling
  13. State Management in PHP
  14. Database Handling
  15. Live Project

6: Asp.Net

  1. .HTML, CSS & JavaScript
  2. 2.Overview of the ASP.NET
  3. 3.Framework
  4. 4.Setting up and Installing ASP.NET
  5. 5.C#
  6. 6.Coding Standards
  7. 7.Asp.Net Standard Controls
  8. 8.Asp.Net
  9. 9.Asp.Net Validation Controls + Javascript Validation
  10. 10.Designing Websites with master pages
  11. 11.Using the Rich Controls
  12. 12.Microsoft SQL Server 2008
  13. 13.SQL Server Basic
  14. 14.Overview of Data Access
  15. 15.Using the Grid View Control
  16. 16.Using the Details View and Form View Controls
  17. 17.Using Repeater and Data List Controls
  18. 18.Using Navigation Controls
  19. 19.Working with XML and Web Services
  20. 20.AJAX (Asynchronous JavaScript and XML)
  21. 21.FTP Management
  22. 22.Sending Emails & Deployment
  23. 23.Live Project
  24. 24.Asp.Net Standard Controls

OR

6: Mobile Application Development Android

  1.  Java concepts
  2.   Introduction to Android
  3.  Application Structure (in detail) 
  4.  Emulator & Intents 
  5.  Basic UI design, Styles & Themes 
  6.  Dialog boxes 
  7.  Images and media, Composite 
  8.  Menu, Linkify & Adapters 
  9.  Receivers and services
  10.  Preferences & Content Providers
  11.  Customized controls
  12.  Thread & Server Connection
  13.  Fragments
  14. Google Maps
  15. Location based Services
  16. Accessing Phone services
  17. Action bar

Project Work