Syllabus

MySQL
  • Learn both MySQL & Adv. MySQL
  • MySQL & Database Basics
  • Installation
    • Server
    • Workbench (client)
  • DDL - Data Definition Language
    • Tables - Create, Alter, Drop, Auto Increment
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Index - Why required, Create, Drop
  • DML - Data Manipulation Language
    • Insert, Update, Delete & Truncate
  • Transactions (T SQL)
    • Commit
    • Rollback
  • DQL - Data Query Language (Select)
  • Filters
    • Operators - <, <=, >, >=, =, !=
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT
    • Multi conditions filtering
    • DISTINCT
    • Limit, offset
  • Sorting
    • Ascending Order
    • Descending Order
    • Multi Column Sorting
  • Functions
    • Data, number, characters, null values etc.
    • Case
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT
    • Grouping Filters - HAVING
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued
    • Multi Valued
  • Views & Inline Views
  • Procedures
    • Programming basics - if..else, for loop
    • Procedures - create, drop
  • Functions
    • create, drop
  • Triggers
    • create, drop
  • Project

Web Designing
  • Overview
    • About Responsive Website Designing
    • VS Code Installation
  • HTML
    • Table Tags
    • Types of Lists
    • Forms
    • Head tag & Meta tag
    • Layout
    • Classes and ID
    • Div Tag
    • Paragraph Tag
    • Formatting Tags
    • Anchor Tag
    • Quotations Tags
    • Marquee Tag
    • Image Tag
  • HTML5 Elements
    • Section Tag
    • Article Tag
    • Source
    • Header
    • Video
    • Audio
    • Keygen
    • Canvas
  • HTML 5 Validations
  • Meta Tags
    • Meta Tags - Title, Description, tags etc.
    • Header Tags - H1, H2, H3, H4, H5 etc.
  • CSS & CSS3
    • Basics
    • Background Image & Colors
    • Selectors
    • Declaration & Types
    • Fonts & Text Properties
    • Text Shadow, Gradients etc.
    • Overflow & Display Properties etc.
    • Effects - Border Raidus, Box Shadow etc
    • Box Model - Border, Margin etc
    • Units in css
    • Positions - Static, Absolute, Relative, Fixed, Sticky etc
    • Transforms - 2d & 3d Effects
    • Transitions - Color Effects
    • Animations
    • Menu & Navigation Bar
    • Chrome's Inspect Element for Desktop & Mobile for Runtime CSS Manipulations
  • CSS Media Query
    • Overview
    • Creating CSS Media Query Files
    • Device Width wise CSS Programming
  • JavaScript
    • Basics
    • Variables, Operators, Data Types etc
    • Programming
      • If-Else
      • Switch case
      • while
      • Do while
      • For Loops etc.
    • Logic Building Sessions
    • Creating Functions
    • Inbuilt Functions
      • Date
      • String
      • Numeric
    • Arrays
      • 1-D & 2-D Arrays
      • Methods
    • Objects
    • Event Handling
      • On Click
      • On Keyup
      • On Change
      • On Keypress
      • On Keydown, etc.
    • Regular Expressions
    • HTML DOM (Working with Frontend)
      • getElementById
      • getElementByClassName
      • document.write etc.
    • Js Form Validation
    • Alert box, Prompt, Confirm etc
  • jQuery
    • Basics
    • Effects
    • DOM Parsing
    • Form Validations
    • Events
    • Creating Functions
    • Inbuilt Functions
      • redirect
      • html
      • text
      • find
      • siblings
      • parents, etc
    • Dynamic CSS Programming
    • Hide and show element etc
  • Bootstrap
    • Basics
    • Introduction to Responsive Website Designing
    • Grid system
    • Card
    • Table & Table Classes
    • Texts & Text Classes
    • Image & Image Classes
    • Button & Button Classes
    • Creating Dropdown
    • Creating Loader
    • Creating Progressbar
    • Breadcrums
    • Pagination
    • List
    • Panel
    • Media Object
    • Font Awesome & Glyphy Icons
    • Forms
    • Menu & Navigation Bar
    • Carousel
    • Tooltip
    • Pop Hover
    • Scroll Spy
    • Affix
    • Bootstrap Modals - (pop ups)
    • Creating Responsive Websites in Bootstrap
    • Project
  • Project

Core Java & JDBC
  • Introduction to Java
  • Installing JAVA Latest & Eclipse IDE
  • JVM Architecture
    • Classloader sub system
  • Java Basics
    • Variables
    • Datatypes
    • Static Variables
    • final Variables etc
  • Command line arguments
  • Creating Classes, Objects & Methods
  • Control Structures
    • If - Else if - Else
    • Do.. While
    • While
    • For Loops
    • Adv For Loops etc
  • Logic Building & Programming
    • Pattern Programs - 5 types
    • Prime Number
    • Fibonacci Sequence
    • Factorial
    • Recursion
    • Swap 2 Variables
  • Data Structures
    • Linear Search
    • Bubble Sort
  • Arrays
    • 1-D Array
    • 2-D Array
  • String Classes
    • String methods
      • length
      • substr
      • charat
      • instr
      • toString()
      • toCharArray
      • trim
      • equals, equalsignorecase
      • trim
      • uppercase etc.
    • String Buffer
    • String Builder
    • String Immutable concept
  • Wrapper Classes
    • Integer Class
    • Double Class
    • Long Class
  • DateTime API
    • Date methods
    • Calendar API
    • DataFormat
    • SimpleDateFormat
  • String Immutable Concept
  • Access Modifiers - Public, Private, Protected & Default
  • Packages
  • OOPS Concepts
    • Inheritance
    • this keyword
    • toString() method
    • Relationships
      • is-A relationship
      • has-A relationship
    • Polymorphism
      • method overloading
      • method overriding
      • final keyword
      • compile time & runtime polymorphism
    • Encapsulation
    • Abstraction
      • Interface
        • Extending interface
        • Functional interface
      • Abstract Class
    • instanceof operator
  • Nested & Anonymous Class
  • Exception Handling
    • Try..Catch...Finally Block
    • using internal exceptions
    • User defined expceptions
    • throw and throws keyowrd
  • Collection Framework & Generics :: java.util pkg
    • Arrays
    • Vectors
    • Enumeration
    • List
    • ArrayList
    • LinkedList
    • Using Generics
    • Set
    • SortedSet
    • HashSet
    • Map
    • HashMap
    • SortedMap
  • Using java.util.Collections Class
    • Collection Sort
    • Collection Shuffle
    • Comparator
    • Comparable
  • MySQL
    • Installation
    • CRUD Operations (create, read, insert, update, delete)
    • Groups
    • Joins
    • Views
    • Sorting
  • JDBC
    • Configuration
    • Creating Tables
    • CRUD Operations (select, create, update, insert, delete)
  • Integrating Collections & JDBC
  • Multi Threading
    • Basics
    • Thread Joins
    • Thread Synchronization
    • Runnable Interface
    • Executor Service - Fixed Thread Pool
  • File IO
    • IO Streams examples
    • Reader & Writer
    • Serialization & De-Serialization
    • transient
  • Lambda Experssions
  • Default Methods (Latest)
  • Streams (Latest)

J2EE (Advanced Java)
  • Environment Configuration
    • Setting Up Eclipse with Apache Tomcat
    • Creating HTML Forms
    • CSS Integration
    • JavaScript form Validation
    • J2EE Architecture Overview
    • Servlets & JSP APIs and Life Cycle
  • Creating Web Forms
    • Form desinging in HTML
    • Sample application in HTML
  • Servlet Programming
    • Introduction to Servlets
    • Creating GET & POST Forms
  • Request Dispatcher
  • Send Redirect
  • Difference between Request Dispatchers & Send Redirect
  • Building JSP Application
  • JSP Directives
  • Session
  • Cookies
  • JDBC Integration
    • Configuring MySQL Jar file
    • Updating Servlets with JDBC
    • Performing Insert, Update, Delete operations on Forms using JDBC
  • AJAX & JSON
    • Creating JSP Pages with AJAX forms.
    • Integration AJAX & Servlets
    • Display AJAX response on JSP Page
  • Project

Hibernate, REST Api & Spring Boot
  • Hibernate
    • Configuring Database
    • Understanding ORM framework
    • Hibernate Properties
    • Using JPA
    • Creating Tables, indexes, columns, primary keys, foreign keys using Hibernate
    • HQL
    • Criteria
    • 1 to 1 mapping
    • many to 1 mapping
    • many to many mapping
    • Cache
  • Spring
    • Setting Maven Dependencies in Eclipse
    • Configuring Spring Properties
    • IOC Container & Dependency Injection
    • Spring Components
      • Singleton, Prototype & Lazy Objects
    • Building Spring Stand Alone Project
      • Working with Class, Objects etc in XML
      • Using Property Arguments
      • Using Ref Arguments
    • Autowiring
      • By Name
      • By Type
      • Using Qualifier Tag
    • Collections
      • List
      • Set
      • Map
      • Properties
    • AOP
    • Spring JDBC
      • using JDBCTemplate
      • CRUD Operations
      • Select Operations
      • using RowMapper
  • SpringBoot Software Installations
    • STS
    • POSTMAN
  • Sring Boot & REST API
    • Creating Spring Boot Application
    • Setting MAVEN Dependencies
    • JPA / Hibernate Integration
    • Creating DAO, Service etc. Classes
    • Using Annotations & Classes
      • @RestController
      • @RequestMapping
      • @GetMapping
      • @PostMapping
      • Model Interface
      • @Repository
      • @Service
      • ResponseEntity
      • @ResponseBody
      • @RequestBody
    • Performing CRUD Operations
    • Testing with POSTMAN
  • Spring Boot MVC
    • Configuration
    • @Controller
    • @RequestMapping
    • Dynamic URLs & Dynamic Parameters
    • GET, POST, PUT, DELETE annotations
    • Using JSP Forms
    • Sessions
    • Routing
    • JSTL / TheampLeaf Integration
    • Spring Forms
    • Validation API
    • CRUD Implementation
    • AJAX With REST API
    • Project
  • Spring Boot Microservices
    • Introduction to Microservices
    • Microservice Architecture
    • Difference between Monolithic and Microservice Architecture
    • Building and deploying a Microservice
    • Actuators
  • Spring Security overview
  • Project

React.js
  • Pre-requisite: Web Designing
  • Introduction
  • Installing Node.js
  • VS Code Configuration
    • Creating React App
  • Folder Structure
  • JSX Syntax
  • Creating Components
  • Class & Functional Components
  • Using Components
  • Event Handling
    • On Click
    • On keyup
    • On change
    • On keypress
    • On keydown, etc.
  • Adding CSS
  • Adding Bootstrap
  • Properties
  • Router
  • Hooks
    • useState
    • useEffect
    • useParam
    • useLocation etc
  • Working with Forms
  • Rest API with React
  • React with Backend (php / Node.js)
  • CRUD Operations
  • Redux
  • AXIOS
  • Taiwind CSS
  • Project

Duration
  • Weekdays (MTTF, Wed Off) :
    Option 1 - 7.5 months - 1.5 to 2hrs/day
    Option 2 - 4.5 to 5 months - 2.5hrs/day (including 10 mins break)

  • Weekends(Sat & Sun):
    Option 1 - 7.5 to 8 months - 2 to 2.5hrs/day
    Option 2 - 5.5 to 6 months - 2.5 to 3hrs/day (including 10 mins break)

Fees
Show More