Full Stack Java Course In Pune

1. Introduction to Java
2. Features of Java
3. Java development setup
4. Understanding Hello World program in detail
5. Identifier
6. Variable
7. Datatypes
8. Operators
9. Accept input from User
10. Control Statements
11. JVM architecture
12. Class and Object
13. Class Components Core Java 8

14. Oops Concept
a. Instance variables, static variables, local variables
b. Instance methods, static method
c. Constructor
d. Instance Block, Static block
e. Static, non-static nested and local Inner classes

15. Java 8 Features
a. functional interface
b. default methods
c. static methods
d. ambda expression
e. optional class
f. method reference
g. Stream API

16. Object class and java.lang package
17. Array
18.String Handling
19. Multithreading
20. Collection Framework
21. File Handling
22. Annotations
23. Enum

24. Reflection API basics
d. Polymorphism [Method overloading & overriding]
e. Abstraction [abstract class and interface]
a. Access Specifiers
b. Encapsulation
c. Inheritance

1. Java Database Connectivity [JDBC]
2. Servlets
3. JSP
4. MVC Design pattern

1. Maven
2. GIT
3. Mockito and JUnit
4. Lombook
5. IntelliJ Idea
6. Mapstruct library

1. Introduction to Hibernate
2. Hibernate Configuration
3. Entity Mapping
4. Working with Persistent Objects
5. Hibernate Query Language (HQL)
6. Criteria API
7. Native SQL Queries
8. Hibernate Caching
9. Hibernate Associations
10. Hibernate Inheritance Mapping
11. Transactions and Concurrency Control
12. Advanced Topics
13. Integrating Hibernate with Spring
14. Hibernate and Java Persistence API (JPA)

1. Spring Core
2. Spring AOP
3. Spring MVC
4. Spring JDBC
5. Spring Data JPA
6. Spring REST
7. Spring Boot

1. Web Programming Introduction
2. Introduction

3. Headers
a. The architecture of a website
b. Different technologies in making the website
c. Web Development Introduction
a. History of HTML
b. Syntax of HTML
a. Different types of tags used inside HTML headers

4. Different Types of Tags
a. Basic Tags
b. Formatting Tags
c. Grouping Tags
d. List Tags
e. Table Tags
f. Form Tags
g. Other HTML Tags

5. Semantic HTML Elements
a. Different semantic HTML elements and it’s use case

1. Introduction
a. Introduction of CSS
b. Benefits, History of CSS

2. Syntax
a. Syntax
b. Different ways to add CSS

3. Selectors and Specificity
a. Types of selectors
b. CSS specificity

4. Types of CSS properties
a. Background
b. Border
c. Padding
d. Text Fonts
e. List
f. Display and Positioning
g. Other types of CSS Property

5. Box Model
a. Introduction to Box Model

1. Introduction
a. What is Bootstrap Framework
b. Why Bootstrap
c. Advantages of Bootstrap Framework
d. What is Responsive web page
e. How to remove Responsiveness
f. Features of Bootstrap
g. Mobile-First Strategy
h. Environment Set up
i. Implementing Bootstrap in Applications

2. Bootstrap Grid
a. Bootstrap Grid and implementation of
Bootstrap Grid
b. What is Container & Offset Column
c. Reordering Columns
d. Advantages of Bootstrap Grid
e. Display responsive Images & change class
properties
f. Customize Bootstrap’s components & jQuery
plug-in
g. Bootstrap Typography & its use
h. Bootstrap Tables, Form Layout & Bootstrap
Button
i. Muted and Warning Text Messages
j. Carets Classes / Hide or show the text in
Bootstrap
k. Bootstrap Components / Plugins

1.Intro to Javascript :
a. Prerequisite of JavaScript
b. Introduction and history of JavaScript
c. How to include/add JavaScript in HTML

2. Syntax, Variables, Values, Data Types:
a. Syntax review
b. Variable declaration
c. Data types supported in JavaScript
d. Key Difference between Var, Let, and Const

3. Expressions and Operators:
a. What are Operators in JavaScript
b. Different types of Operators in JavaScript

4. Control structures :
a. Flow control and conditionals
b. Loops and iteration
c. Jumps

5. Error handling :
a. Throwing errors
b. Error handling

6. Data types with methods supported :
a. String
b. Numbers
c. Arrays
d. Functions

7. JSON :
a. What is JSON and syntax of JSON

8. Regular Expressions :
a. Creating regular expressions for matching
patterns
9. Objects :
a. Creating object
b. Properties
c. Methods
d. Build-in JavaScript objects

10. ES6 Features.

11. Iterators and generators
a. Working with Iterators
b. Working with Generators

12. Prototype-based Object Oriented Programming
a. Defining Constructors
b. Prototypes
c. Inheritance

13. JavaScript in the Web browser
a. Embedding JavaScript in HTML
b. Execution of JavaScript code

14. Browser Object Model
a. Introduction to the browser object model
b. Different use cases of a browser object model

15. Document Object Model
a. Document structure/DOM tree
b. HTML elements and attributes
c. Creating, changing, and deleting nodes

16. Handling Events
a. Types of events
b. How to control events

17. Ajax*
a. JavaScript and HTTP communication
b. Synchronous and asynchronous request

18. JavaScript Async
a. JavaScript Callback
b. Promises
c. Async/Await
a. Cookies
b. Web Storage
c. IndexedD

1. Introduction to React
a. What is React?
b. Why React?
c. React version history
d. React 16 vs React 15

e. Just React – Hello World
f. Using create-react-app
g. Anatomy of react project
h. Running the app
i. Debugging first react app

2. Templating using JSX
a. Working with React. createElement
b. Expressions
c. Using logical operators
d. Specifying attributes
e. Specifying children
f. Fragments

3. About Components
a. Significance of component architecture
b. Types of components
c. Functional
d. Class based
e. Pure
f. Component Composition

4. Working with state and props
a. What is state and its significance
b. Read state and set state
c. Passing data to component using props
d. Supplying default values to props using
defaultProps

5. Hooks
a. What are hooks
b. Why do you need hooks
c. Different types of hooks

6. Routing with react router
a. Setting up react router
b. Different components of react router

7. Rendering lists
a. Using react key prop
b. Using map function to iterate on arrays to generate elements

8. Event handling in React
a. Understanding React event system
b. Understanding Synthetic event
c. Passing arguments to event handlers

9. Understanding component lifecycle and handling errors
a. Understand the lifecycle methods
b. Handle errors using error boundaries

10. Context
a. Introduction to Context and its use case

11. Code-Splitting
a. Introduction to Code Splitting

12. Redux
a. What is redux and to use it redux
b. Install and setup redux

13. Immutable.js
a. What is Immutable.js?
b. Immutable collections
c. Lists
d. Maps
e. Sets

14. React Redux
a. What is React Redux and why to use it
b. React Redux Implementation

15. Redux middleware
a. Why redux middleware
b. Different types of middleware and their implementation

16. Webpack
a. What is webpack
b. Working with webpack configuration file

17. Babel
a. What is webpack
b. ReactJS Using Babel

• SQL Introduction

• SQL Comments

• Data Types

• Syntax

• Operators

• Create, Drop, Backup Database

• Create, Drop, Rename, Alter, Truncate Table

• Constraints

  •  Primary Key
  •  Foreign Key
  •  Unique
  •  Not Null
  •  Default
  •  Check
  •  Index
  •  Auto Increment

• SELECT

• SELECT Distinct

• WHERE

• AND Operator

• OR Operator

• NOT Operator

• IN Operator

• BETWEEN

• LIKE Operator

• Wildcards

• ORDER BY

• Aggregate Functions

  • MIN, MAX
  • COUNT
  • SUM
  • AVG

• GROUP BY

• HAVING Clause

• SELECT TOP Limit

• Offset

• NULL Values

• INSERT INTO

• UPDATE

• DELETE

• JOINS

  •  Inner Join
  •  Left Join
  •  Right Join
  •  Full Join
  •  Self Join

• UNION

• Aliases

• SELECT INTO

• INSERT INTO SELECT

• Indexes

  • Clustered Index
  • Non-Clustered Index
  • CREATE INDEX index_name ON table_name(column_name);
  •  

  CREATE TABLE table_name ( id INT PRIMARY KEY, name VARCHAR(100), age INT, INDEX (name) -- Regular index on 'name' column );

  SHOW INDEX FROM table_name;

  DROP INDEX index_name ON table_name;

• Transactions

  • COMMIT
  • ROLLBACK
  • SAVEPOINT

• EXISTS

• ANY, ALL

• Views

  • Materialized Views

• Dates

• Null Functions

• Stored Procedure

• CASE

• Temporary Tables

• Triggers

Specific to DBA role

• Common Table Expressions (CTE)
• Window Functions
  • ROW_NUMBER()
  • RANK()
  • DENSE_RANK()
  • NTILE()
• Cursors
• Partitioning
  • Horizontal Partitioning
  • Vertical Partitioning
• Error Handling
  • TRY...CATCH
• Full-Text Search
• Normalization
  • 1NF, 2NF, 3NF, BCNF
• Denormalization
• User-Defined Functions (UDF)
  • Scalar Functions
  • Table-Valued Functions
• SQL Injection
• SQL Performance Tuning
  • Query Optimization
  • Execution Plans
  • Index Tuning

### **1. Introduction to Version Control (10 minutes)**

- **What is Version Control?**
- Definition and importance
- Brief history of version control systems (VCS)
- Overview of Git as a distributed version control system (DVCS)
- **Why Git?**
- Advantages of using Git
- Git in the context of software development and collaboration

---

### **2. Setting Up Git (15 minutes)**

- **Installation**
- How to install Git (Windows, macOS, Linux)
- Verifying the installation (`git --version`)
- **Configuration**
- Setting up username and email

3. Basic Git Commands

4. Branching and Merging

5.Remote Repositories

6.Hands-On Practice

7. Wrap-Up and Q&A

What is AWS?: Understanding AWS as a cloud service provider and its role in web development.
Regions and

Availability Zones: Knowing how AWS organizes its data centers and the importance of choosing the right region.

AWS Management Console: Navigating the AWS web interface to manage services.
AWS CLI (Command Line Interface): Basic commands and usage to interact with AWS services.