java-web-pages-and-database-management

5.5K+ Learners

Group Enrollment with Friends or Colleagues |Get a quote

Course Overview

Familiarize yourself with the back-end technologies by implementing knowledge of SQL, Java Servlets, and relational database ORM with Hibernate. Learn to connect databases with JDBC and work with RESTful web services.

Take the First Step to Your Goals

Lifetime access to self-paced e learning content

Training Options

Self Paced Learning

num_of_days days of access to high-quality, self-paced learning content designed by industry experts

$799

Corporate Training

Flexible pricing & billing options
Private cohorts available
Training progress dashboards
Skills assessment & benchmarking
Platform integration capabilities
Dedicated customer success manager

Course Curriculum

Course Content

Section 01: Java Certification Course
Preview
- Lesson 01 - Introduction to Java EE
  20:32Preview
  - 1.001 Introduction to Java EE
    20:32
- Lesson 02 - Java Servlet I
  01:13:52Preview
  - 2.001 Servlets API, Interfaces, and Methods
    10:55
  - 2.002 Servlet Lifecycle
    00:36
  - 2.003 Configure and Deploy Servlet
    19:14
  - 2.004 ServletRequest, ServletResponse
    03:05
  - 2.005 ServletConfig, ServletContext
    16:51
  - 2.006 Servlet Scopes, Attributes, and Collaboration
    23:11
- Lesson 03 - Java Servlet II
  01:09:22Preview
  - 3.001 Session Management
    34:20
  - 3.002 Listeners in Java EE
    17:10
  - 3.003 Filters in Java EE
    17:52
- Lesson 04 - Java Server Pages
  01:15:53Preview
  - 4.001 JSP Lifecycle
    09:24
  - 4.002 Creating and Working With JSP Elements
    17:30
  - 4.003 Working with JSP Standard Action
    20:04
  - 4.004 JSTL and Custom Tag Libraries
    28:55
- Lesson 05 - Introduction to Hibernate
  01:00:24
  - 5.001 Introduction to Hibernate
    16:33
  - 5.002 Hibernate CRUD Operation
    43:51
- Lesson 06 - Hibernate Queries and Relationship
  49:10
  - 6.001 Hibernate Queries and Relationships
    17:11
  - 6.002 Mapping Relationship with Hibernate
    31:59
- Lesson 07 - Introduction to Spring
  49:07Preview
  - 7.001 Introduction to Spring
    15:42
  - 7.002 Dependency Injection, SpringBean Lifecycle, Wiring and Scope
    33:25
- Lesson 08 - Spring AOP
  36:15
  - 8.001 Introduction to Spring AOP (Aspect-Oriented Programming)
    12:30
  - 8.002 Configuring AOP in Java Application using AspectJ Approach
    23:45
- Lesson 09 - Spring JDBC and Spring Hibernate
  30:46
  - 9.001 Spring JDBC Implementation in an Application
    16:28
  - 9.002 Spring Hibernate Template
    09:40
  - 9.003 Spring JDBC Transaction Management
    04:38
- Lesson 10 - Spring MVC
  32:39Preview
  - 10.001 Spring MVC Architecture, Components, and Framework
    09:57
  - 10.002 Spring MVC Program
    22:42
- Lesson 11 - SOA and Web Services
  31:34
  - 11.001 Basics of SOA Architecture and Web Services
    18:08
  - 11.002 Creating SOAP based and RESTful Web Services
    13:26

Section 02: SQL Training
Preview
- Lesson 01 - Rational Databases
  42:00Preview
  - 1.1 What are Databases
    07:24
  - 1.2 What's the Role of Databases in Application Programming?
    07:56
  - 1.3 Tables and Relations
    14:40
  - 1.4 Primary and Foreign Keys and Other Constraints
    12:00
- Lesson 02 - SQL Querying
  20:13Preview
  - 2.1 What is Querying
    02:40
  - 2.2 The ANSI SQL Standard
    03:59
  - 2.3 DML, DDL and More
    05:07
  - 2.4 Common Query Tools
    08:27
- Lesson 03 - Your First Queries
  32:55
  - 3.1 The SELECT Statement
    06:17
  - 3.2 Limiting Output Columns
    04:57
  - 3.3 Formatting and Sorting Output
    15:22
  - 3.4 Column Aliases
    06:19
- Lesson 04 - Filtering Your Results
  31:50Preview
  - 4.1 The WHERE Clause
    04:57
  - 4.2 Creating a Filter Condition
    07:19
  - 4.3 Applying Multiple Filter Conditions
    08:13
  - 4.4 More Filter Options
    11:21
- Lesson 05 - Consolidating Your Data
  32:55Preview
  - 5.1 Counting Records
    05:14
  - 5.2 Common Aggregate Functions SUM, AVG, MIN, MAX
    08:06
  - 5.3 Dos and Donts When Consolidating
    08:38
  - 5.4 Unions and Other Multiset Consolidations
    10:57
- Lesson 06 - Grouping Your Data
  21:44
  - 6.1 The GROUP BY Clause
    09:59
  - 6.2 The HAVING Clause
    05:36
  - 6.3 Dos and Don'ts When Grouping
    06:09
- Lesson 07 - Joining Tables
  01:03:57Preview
  - 7.1 Table Aliases
    06:54
  - 7.2 Inner Joins
    14:58
  - 7.3 Outer Joins
    14:08
  - 7.4 Self Joins
    08:00
  - 7.5 Complex Multi Table Joins
    19:57
- Lesson 08 - Subqueries
  33:46Preview
  - 8.1 Filtering Using Subqueries
    14:09
  - 8.2 The EXISTS Clause
    06:49
  - 8.3 Subqueries as Alternative to Joins
    07:09
  - 8.4 Derived Tables
    05:39
- Lesson 09 - Manipulating Your Data
  40:02Preview
  - 9.1 The INSERT Statement
    20:46
  - 9.2 The UPDATE Statement
    12:50
  - 9.3 The DELETE Statement
    06:26
- Lesson 10 - Transaction Control
  14:03Preview
  - 10.1 What are Transactions
    05:24
  - 10.2 Initiating a Transaction
    04:17
  - 10.3 The COMMIT and ROLLBACK Commands
    04:22
- Lesson 11 - Creating Database Objects and Adding Business Logic
  46:00
  - 11.1 Creating Tables
    16:39
  - 11.2 Creating and Using Views
    09:15
  - 11.3 Developing and Calling Stored Procedures
    10:41
  - 11.4 Implementing Triggers
    09:25

Section 03: Live Virtual Class Curriculum
Preview
- Lesson 01: Developing Dynamic Web Pages Using Servlets
  - Section Introduction
  - Web Technology
  - Assisted Practice: Difference between GET and POST
  - Overview of Servlets
  - Servlet Architecture
  - Assisted Practice: Configuring a servlet with eclipse
  - Generic Servlets
  - Assisted Practice: Generic Servlets
  - Servlet - Classes and Interfaces
  - Assisted Practice: Servlet - Classes and Interfaces
  - Servlet Filters
  - Assisted Practice: Servlet Filters
  - Session Tracking
  - Assisted Practice: Session Tracking Using Cookies
  - Session Tracking Using URL Rewrite
  - Assisted Practice: Session Tracking Using URL Rewrite
  - Session tracking Using Hidden form fields
  - Assisted Practice: Session Tracking Using Hidden Form Fields
  - Session Tracking Using HTTP Session
  - Assisted Practice: Session Tracking Using HTTP Session
  - Session Login and Logout
  - Assisted Practice: Session Login and Logout
  - Validation of User login
- Lesson 02: Creating Your Database Using JDBC
  - Section Introduction
  - Overview of JDBC
  - Assisted Practice: Set Up JDBC Environment
  - Unassisted Practice: Set Up JDBC Environment
  - JDBC Connections, Statements, and Result Sets
  - Assisted Practice: JDBC Connections, Statements, and Result Sets
  - Stored Procedures with Exceptions
  - Assisted Practice: Stored Procedures with Exceptions
  - Create, Select, and Drop a Database
  - Assisted Practice: Create, Select, and Drop a Database
  - Unassisted Practice: Create, Select, and Drop a Database
  - Insertion, Updation, and Deletion of Database Records
  - Assisted Practice: Insertion, Updation, and Deletion of Database Records
  - Retrieving the Product Details Using the Product ID
- Lesson 03: Creating a Hibernate Framework
  - 3.01 Section Introduction
  - 3.02 Hibernate Overview
  - 3.03 Assisted Practice: Configuration of Hibernate
  - 3.04 Assisted Practice: Hibernate Configuration Using XML in Eclipse
  - 3.05 Assisted Practice: Hibernate Configuration Using Annotations in Eclipse
  - 3.06 Hibernate logging by Log4j
  - 3.07 Assisted Practice: Hibernate Logging by Log4j
  - 3.08 Hibernate Mapping
  - 3.09 Collection Mapping in Hibernate
  - 3.10 Assisted Practice: Collection Mapping in Hibernate
  - 3.11 Hibernate mapping using XML file
  - 3.12 Hibernate mapping using Annotations
  - 3.13 Bidirectional Mapping
  - 3.14 Hibernate Lazy Collection
  - 3.15 Assisted Practice: Hibernate Lazy Collection
  - 3.16 Component Mapping
  - 3.17 Assisted Practice: Component Mapping
  - 3.18 Integration of Hibernate with Spring
  - 3.19 Assisted Practice: Integration of Hibernate with Spring
  - Adding a New Product in the Database
- Lesson 04: Developing Dynamic Web Pages Using JSP
  - Section Introduction
  - An overview of JSP
  - Assisted Practice: Creating a Simple JSP Page
  - Scripting Elements or JSP Tags
  - JSP Implicit Objects
  - Assisted Practice: JSP Implicit Objects
  - JSP Directives
  - Assisted Practice: JSP Directives
  - JSP Action Tags
  - Assisted Practice: JSP Action Tags
  - JSTL
  - Session Handling
  - Assisted Practice: Session Handling
  - Product Details Portal

Why Join this Program

Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts