Syllabus
- 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)
- 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
- Triggers
- Project
- 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
- Arrays
- 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
- Introduction to Java
- Installing JAVA Latest & Eclipse IDE
- JVM Architecture
- 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
- 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
- MySQL Installation
- CRUD Operations (Create, Read, Insert, Update, Delete)
JDBC
- Java MySQL Integration using JDBC Driver
- Configuring JDBC Driver
- JDBC Classes:
- Connection, ResultSet, Prepared Statement etc. Classes
- CRUD Operations
- Handling Exceptions
- Collection integration with List & Set
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
- Functional Interface
- Looping Through Collections
- Method Invocation
Streams API (Latest)
- Operations: filter(), map(), sorted(), distinct(), forEach(), collect(), reduce(), min(), max() etc.
- Environment Configuration
- Installing Apache Tomcat
- Setting Up Eclipse with Apache Tomcat
- J2EE Architecture Overview
- Creating Web-app application
- Servlets & JSP APIs and Life Cycle
- Creating Web Forms
- Form designing in HTML
- Sample application in HTML
- Servlet Programming
- Introduction to Servlets
- Creating GET & POST Forms & interacting using servlet
- Using Servlets POST & GET Methods and their variables
-
JSP
- Creating JSP Pages
- Scriplet Programming for JSP Programming
- Scriplet tags
- Invoking (Importing) Java Classes & Methods
- Integrating HTML & JSP
- JSP Directives
- Working with HTML forms & Servlets in JSP
- Include, Headers, Footers etc.
-
Routing
- Servlet Routing with JSP
- Send Redirect
- Request Dispatcher & Data Transport
- Difference between Request Dispatchers and Send Redirect
- Login Application
- Login Page
- Routing JSP pages in multiple Directories
- Routing using Request Dispatcher & Send Direct
- Logoff Page
- User Session Management
- Sessions (Server side session management)
- Cookies (Client side session management)
- Implementing Security using Sessions and Send Redirect in Login Application
- MySQL JDBC Integration
- (note – MySQL and JDBC already covered in Core Java)
- Configuring MySQL Jar file in Web Application
- Integrating MySQL & JDBC with Servlets
- Advanced Login Application
- Creating users with roles in database
- Creating programs with JDBC integration to work with database and user authentication
- Authentication - user login authentication using JDBC
- Authorization - Role based page access management using Sessions
-
SOCKET Programming
- Basics
- Network communication using Socket Programming
- AJAX & JSON Project with Google GSON API
- Understanding Difference between regular and Ajax forms
- Creating JSP Pages with AJAX forms.
- Integration AJAX & Servlets
- Looping Through Collections and MySQL integration
- Convert collection results in JSON format
- Consuming JSON response to show results on JSP Pages
- Hibernate ORM Framework
- Configuring Hibernate and MySQL
- 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 & Qualifiers
- By Name
- By Type
- Using Qualifier Tag
- Collections
- AOP
- using @Aspect
- Before, After and Around advices/li>
- Spring JDBC
- using JDBCTemplate
- CRUD Operations
- Select Operations
- using RowMapper
SpringBoot Software Installations
Sring Boot & REST API
- Creating Spring Boot Application
- Setting MAVEN Dependencies
- Creating DAO, Service etc. Classes
- Using Annotations & Classes
- @RestController
- @GetMapping
- @PostMapping
- @PutMapping
- @DeleteMapping
- @ResponseStatus
- @RequestBody
- @ResponseBody
- HttpStatus Codes
- ResponseEntity
- Performing CRUD Operations
- Testing with POSTMAN
JPA / Hibernate Integration
- Integrating Hibernate / JPA with RESTful Services
- @Repository Layer
- @Service Layer
Spring Boot MVC
- Introduction to Spring MVC
- Boot packaging options, JAR or WAR
- Spring Boot Annotations & Usage:
- @Controller
- @RequestMapping
- @GetMapping,
- @PostMapping etc
- @PathVariable
- @RequestBody
- @RequestParam
- @Qualifier
- @Bean
- @Component
- Creating Dynamic URLS
- Creating JSP forms and JSTL integration
- JSP Routing using Spring Boot
- JPA / Hibernate Integration
- Integrating Spring JDBC Template with Spring Boot
- Server Side Validation
- Session Management
- Ajax JSON Integration with Spring Boot
- Project
Spring Boot Microservices
- Introduction to Microservices
- Microservice Architecture
- Monolithic vs Microservice projects
- Advantages Of Microservices
- Hikari Pooling in spring boot
- APIGATEWAY
- EUREKA SERVER
- RestTemplate
Spring Security
- Introduction to Spring Security
- Core concepts and architecture
- Authentication and Authorization fundamentals
- Spring Security integration with Spring Boot and auto-configuration
- Understanding UserDetailsService and UserDetails
- Securing Web Applications:
- JWT Authentication
Project
- 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
- Pre-requisite: React. Duration 3 weeks to 1 month
- Introduction
- What is Next.js?
- Next.js vs React
- What is SSR in Next.js?
- Core Features
- Pre-Rendering (SSG vs SSR overview)
- Installation & Project Setup
- Install Node.js
- Install Next.js
- Starting Next.js Server
- Folder Structure
- Routing
- Data Fetching & Rendering
- Functions & APIs
- NextRequest
- NextResponse
- API Routes
- Metadata & SEO
- generateMetadata()
- generateImageMetadata
- Image Imports & Optimization
-
Database Integration With MongDB & Perform CRUD Operations
- Styling Support
- Project
- Option 1 - 7.5 to 8 months (full course)
- Option 2 - 5 to 6 months (full course, early completion) - Take MySQL / Web Designing / React in Parallel one at a time either on same day or on weekends to complete the course earlier. Please contact institute for more info.
- more info