JAVA FULL STACK

 CORE JAVA :.
Intro to Programming language
Variables & Datatypes
Operators & Methods
Decision statement & Looping Statement
Array & 2D Array
Object Oriented Fundamentals
OOPs
Encapsulation & Data Hiding
Is-A relationship Inheritance
Polymorphism
Abstraction
Has-A relationship
Object class
Strings
Exception & Exception Handling
Wrapper class
Collection Framework in Java
Java 8 Feature
Multithreading
Functional programming (Stream API)

1
  SQL :
Introduction To SQL :
What is SQL
Data
Database
DBMS
RDBMS
Difference between DBMS & RDBMS
Relational Model and Table
E.F. Codd Rules
Datatypes :
What is datatype & it's Types
Types of Datatypes
Constraints :
What is Constraint & it's Types
Types of constraint
Overview of SQL Statements :
Data Definition Language
Data Manipulation Language
Transaction Control Language
Data Control Language
Data Query Language

2
Data Query Language (DQL) :
Select
Projection
Selection
Joins
Operator :
Concatenation Operator (||)
Logical Operator (And, Or, Not)
Special Operator (In,Not In)
Special Operator (Between, Not Between)
Special Operator (Is, Is Not)
Special Operator (Like, Not Like)
Function :
What is Function & Types
Multi-Row Function
Single-Row Functions
Grouping :
Group By clause
Having clause
Sorting :
Order By clause

3
Subquery:
What is Subquery & Explain
When/why do we use Subquery Case?
Max & Min
Types of Subqueries
Subquery Operator
Nested Subquery
Joins :
Cartesian Join / Cross Join
Natural Join
Outer Join
Self-Join
Multiple conditions on joins
Co-Related Subquery :
What is Corelated Subquery?
Example on Corelated Subquery
Exists & not exists operators
Identifying nth max Value & min Value
Data Definition Language (DDL) :
Create

4
 Rename
Alter
Truncate
Drop
Data Manipulation Language :
Insert
Update
Delete
Transaction Control Language :
Commit
Rollback
Save point
Data Control Language :
Grant
Revoke
Normalization :
Functional Dependencies & It's types
Types of Functional Dependencies
Normalization
1st normal form

5
 2nd normal form
3rd normal form & BCNF
 WEB TECHNOLOGY :

HTML :
Introduction to HTML
HTML 5 Basics
Helper Elements to structure web page
Anchor and Hyperlinks
HTML Multimedia and its embedding
HTML Frame
Advance Concepts in HTML
HTML References
CSS :
CSS Selectors
CSS Units
Typography and Text Styling
Box Model
CSS Colours
CSS Backgrounds
CSS Layouts
6
 CSS Animations
Responsive Web Design
CSS Frameworks
CSS List
CSS Table
CSS Functions
Specificity
Z-Index
CSS Opacity
CSS Image Sprites
CSS Entities
Filter
JavaScript :
Introduction to JavaScript
JS File
Output methods
Variables
Tokens
Hoisting
Operators

7
 Statements
Data types
Typecasting
Primitive and Non-primitive data types
JSON
Copying in JS
This keyword
Prototype
Functions prototype methods
OOP's
ES6 Class
Synchronicity in JS
Promises
Browser Storage
DOM
DOM events
Event Propagation
JDBC :
Introduction to JDBC
What is the difference between file and database?

8
 What is JDBC API
Steps to connect to database
Create Statement using : Statement
Create Statement using : PreparedStatement
Execute Query using : execute method / execute-
update method/ execute-query method
Batch Execution
Create maven project to perform CRUD operation using
JDBC
Create Procedure in DB
Create function in DB
What is DB metadata
What is ResultSet metadata
Create Connection Pool Practical
Hibernate with JPA :
Introduction to Hibernate ORM frame work
Rules to create entity class
Prerequisite to perform CRUD operations
Perform CRUD operations in action
Create primary key (or) composite key in Hibernate
What is hibernate mapping?

9
 one-to-one mapping (uni-direction) / (bi directional)
mapping
one-to-many mapping (uni-direction) / (bi directional)
mapping
many-to-many (uni-direction) /(bi directional) mapping
Practical use of all hibernate annotations
Cascade Types
Generation types
Hibernate first level cache : Programming
Hibernate second level cache : Programming
Hibernate life cycle
Spring :
Spring Core :
Introduction to Spring Framework
Spring Container
IOC container and DI
Building Spring application with its components
Spring Core Container
Spring J2EE container
Spring post-construct and pre-destroy methods

10
 Creating maven project and having the spring
configuration file
Bean scope
How to get bean object in driver class
How to configure multiple bean in xml file
Multiple configuration files in application
Dependency Injection
Dependency Injection using Annotation
Reading values from properties file in component
class and inject to a variable: No XML
Restful Web services :
Introduction to web services
How does web service work?
How does web service share the data?
What is JSON and how to create JSON object
Jax API
JSON with java Collection
Spring Boot :
Build spring boot project: Practical
Controller class and Mapping annotations
Types of mapping annotations

11
 Trigger the end point
Pass value using Path variable: theory
Pass value using Path variable : Program
How to pass json object using request body:
Program
Pass value using Query String: Program
Pass object to a POST method
Pass value using header parameter
Pass value using cookies
Spring boot project with DB
How to use @RequestMapping annotation
Best practices to be followed while creating REST
URL's
Media Type : Produces and Consumes attributes
What and Why ResponseEntity
Status code
Creating simple example to trigger exception
Exception handling : In spring boot
Creating and handling custom exception : In spring
boot
Custom methods in Repository

12
 Custom query in Repository
Types of Query parameters
Creating Layers in spring boot
Demo Project on spring boot
Implementing Swagger in Spring boot
 Spring security
 Micro service

13