Web App Development

Duration: 468 hours + Project Works

Eligibility: Pass in CPSPF with 60% marks/ Pass with 80% in FTP (Java/Python/C & C++)

Program Structure

Module 1: Databases + MySQL (72hrs)

  • Introduction to Relational Databases
  • Relational Design Theory
  • Normalization Forms
  • UML (Unified Modeling Language)
  • MySQL Foundation and Practice
  • Indexes
  • Transactions
  • Constraints and Triggers
  • Views
  • Authorizations
  • Recursion in SQL
  • Semi-Structured Data
    12.1. XML (eXtensible Markup Language)
    12.2. JSON (JavaScript Object Notation)
    12.3. XPATH
    12.4. Xquery (XML Query)
  • Practice of Designing DataBase for various applications
  • Module Assessment Test

Module 2: No SQL Databases (MongoDB) (72hrs)

  • Introduction to NoSQL Databases
  • Difference between RDBMS and NoSQL Databases
  • Pros and Cons of NoSQL Databases
  • Types of NoSQL Databases
  • Mongo Structure
  • Document Store
  • Features of MongoDB
  • Replication
  • Memory Management
  • Schema Designing and Modeling
  • Installing and working with Mongo
  • CRUD Operations in Mongo
  • Indexing and Aggregation
  • Module Assessment Test

Module 3: Computer Networking (144hrs)

  • Computer Networks
  • Protocols
  • Packets Switching
  • Circuit Switching
  • Layered Architecture
  • Physical Media
  • Encapsulation
  • Networks under attack
  • Application Layer
  • Web and HTTP
  • HTTP Message Format
  • Web Caching
  • SMTP, POP3 etc.
  • Transport Layer
  • Network Layer
  • Link Layer
  • Wireless and Mobile Networks
  • Security in Computer Networks
  • Network Management
  • Assessment Test

Module 4: Web App Development (PHP + HTML + CSS + JavaScript) (180 hours + 4 days Project)

  • PHP Development
  • Editors
  • Elements
  • Tags
  • Headings
  • Paragraphs
  • Styles
  • Formatting
  • HTML CSS
  • HTML Links
  • HTML Images
  • Tables
  • Blocks
  • Classes
  • Iframes
  • Forms
  • HTMLS
  • JS Operators
  • JS Functions
  • JS Data Types
  • JS Objects
  • JS Conditional Statements
  • JS Bitwise
  • JS Regex
  • Final Project: Web Application
  • Module Assessment Test