Syllabus

Full Stack Java Developer Course

SQL

Oracle 18/21c Installation
Basics
- Oracle Basics
- Database models
- ER Model Overview
- Data types
- Understanding Test Database
- Basics Queries
- Arithmetic and String functions
- DML Operations - Insert, Update and Delete
- FETCH command - Top N, Top % Rows
Writing Queries
Filters
- DISTINCT
- BETWEEN
- IN
- LIKE
- NOT
- NULL
- AND, OR, NOT etc
- Using Complex Data Filtering Techniques
Sorting
- Ascending Order
- Descending Order
- Complex Sorting
Functions
- String Functions - lower case, uppercase, substring, instring, trim etc.
- Number Functions
- Date Manipulation
- Null Value Functions - NVL, NVL2, NULLIF, COALESCE
- Conditional Expressions - Case and Decode
Groups
- Basics
- Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
- Grouping Filters - HAVING
- Rollups & Cubes
Analytic (Window) Functions
- Over() with summary functions
- Partition By Queries
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
Joins
- Cartesian Product
- Equi and Non-Equi Joins
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Self Join
- Complex Queries - Joins & Groups Integration
SET Operators
- Union
- Union All
- Intersect
- Minus
Subquery
- Single Valued Row Sub Query
- Multi Valued Sub Query
Views
Inline Views
ROWID & ROWNUM
TOP N Analysis or Complex Inline View
DDL
- Tables - Create, Alter, Drop
- Indexes - Types, Create, Drop
- Constraints - Not Null, Primary Key, Unique Key, Foreign Key
- Sequence
- Synonyms
Foreign Keys
DML operations - Insert, Update & Delete
- Insert, Update, Delete & Truncate
- Common Operations
- Creating Tables using queries
- Bulk Data Inserts using Queries
Transactions ( T SQL)
- Commit
- Rollback
- Savepoint
DCL - Grant & Revoke
Project

Web Designing (Frontend)

Overview
- About Responsive Website Designing
- VS Code Installation
HTML & HTML 5
- Table
- Types of Lists
- Forms
- Head tag & Meta tag
- Layout
- Classes and ID
- Div Tags
- Section Tags
- HTML 5 new element
- HTML 5 Validations
On-page SEO Techniques
- 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
SASS OR SCSS
- Introduction
- Installation
- Variables
- Nesting
- Import
- Mixin
- Extends
- Functions
CSS Media Query
- Overview
- Creating CSS Media Query Files
- Device Width wise CSS Programming
JavaScript
- Basics
- Variables, Operators, Data Types etc
- Control Structures - If-Else, while, Do while, For Loops
- Logic Building Sessions
- Creating Functions
- Inbuilt Functions - Dates, Strings, Numerics etc
- Arrays
- Objects
- Events
- Regular Expressions
- HTML DOM
- Alert box etc
jQuery
- Basics
- Effects
- DOM Parsing
- Form Validations
- Events
- functions
- Creating Images
- Dynamic CSS Programming
- Hide and show element etc
Bootstrap
- Basics
- Grid system
- Tables
- Images & Buttons
- Font Awesome & Glyphy Icons
- Pagination
- Forms
- Menu & Navigation Bar
- Carousel Plugin
- Bootstrap Modals - (pop ups)
- Creating Responsive Websites in Bootstrap
Project

Core Java & JDBC

Introduction to Java
Installing Java 17
Installing 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
  - uses-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
- Setup & Configuration
- Using Professional Tool - MySQL Workbench
- Creating Database
- Creating Tables
- CRUD Operations
JDBC
- Configuration
- Creating Tables
- CRUD Operations
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 (Latest)
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 Programming
- Scriplet Programming in JSP
- Servlets and JSP Communication
- Creating Application using JSP
- JSP Directives
- JSP Includes
Session
Cookies
JDBC Integration
- Configuring MySQL Jar file
- Updating Servlets with JDBC
- Performing Insert, Update, Delete operations on Forms using JDBC
File Upload/download
JSTL - JSP Tag Library
- Core Tags
- Function Tags
- Formatting Tags
- Expression Language
- Using JSTL in JSP pages
AJAX & JSON
- Creating JSP Pages with AJAX forms.
- Integration AJAX & Servlets
- Display AJAX response on JSP Page
Project

Hibernate & Spring Boot MVC

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 Constructor 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

Duration

Pkg1 - Java Developer - 3.5 to 4 months
Pkg2 - Full Stack Java Developer - 6 months
Individual courses / Customized training available
Upcoming Batches
Get Fees

Fees

Live Online:
Java Developer - ~~₹20000~~ - ₹17000 (Limited Period)
Java Full Stack Developer - ~~₹33000~~ - ₹28000 (Limited Period)
Individual courses / customized training available
Classroom - Get Fees
Upcoming Batches

Addon Courses

React.js
Angular