JDBC Servlets and JSP – Java Web Development Fundamentals

Course Curriculum

Chapter 1: Introduction

Lecture 1: Instructor and Course Introduction

Lecture 2: How to make the best of this course

Lecture 3: Full Stack Developer Learning Path

Lecture 4: Downloading the completed projects

Lecture 5: Slides used in the course

Chapter 2: Software Setup

Lecture 1: Update

Lecture 2: Installing Java

Lecture 3: Installing Eclipse

Lecture 4: Configuring JDK In Eclipse

Lecture 5: Installing Tomcat

Lecture 6: Configuring Tomcat in Eclipse

Lecture 7: Windows Only -Install Mysql

Lecture 8: Windows Only – Install Mysql Workbench

Lecture 9: MAC – Downloading MySql and MySql workbench

Lecture 10: MAC – Using MySql Workbench

Chapter 3: Web Application Basics

Lecture 1: Web Application Basics

Lecture 2: Static vs Dynamic Web Applications

Lecture 3: Server Side Programming

Chapter 4: Servlets Basics

Lecture 1: Introduction

Lecture 2: Servlet Life Cycle Methods and Phases

Lecture 3: Web Application Folder Structure

Lecture 4: Servlets Introduction

Lecture 5: Servlet Annotations

Lecture 6: Update

Lecture 7: Hello World Servlet Project Creation

Lecture 8: Code the Servlet

Lecture 9: Register the Servlet

Lecture 10: UPDATE

Lecture 11: Application Flow

Lecture 12: The Addition Use Case

Lecture 13: Create the Servlet

Lecture 14: Register the Servlet

Lecture 15: Addition Application Flow

Chapter 5: JDBC Basic Concepts

Lecture 1: Introduction

Lecture 2: JDBC Architecture Introduction

Lecture 3: JDBC API

Lecture 4: JDBC Drivers

Lecture 5: JDBC Client

Lecture 6: DriverManager

Lecture 7: JDBC Architecture Summary

Chapter 6: JDBC In Action

Lecture 1: Introduction

Lecture 2: Create the Account Table

Lecture 3: Steps to perform CRUD Operations

Lecture 4: JDBC Project Creation

Lecture 5: Configure the Driver Jar

Lecture 6: Troubleshooting

Lecture 7: Troubleshooting 2

Lecture 8: Troubleshooting 3

Lecture 9: Connect to the Database

Lecture 10: Connection String

Lecture 11: JDBC Statement

Lecture 12: Create an Account

Lecture 13: Update the balance

Lecture 14: Delete the Account

Lecture 15: JDBC Steps To Read Data

Lecture 16: JDBC ResultSet

Lecture 17: Reading the Accounts

Lecture 18: Navigating the ResultSet

Lecture 19: Clean up JDBC Resources

Lecture 20: The Service Provider Mechanism

Chapter 7: Building Dynamic Web Applications

Lecture 1: Introduction

Lecture 2: GET VS POST

Lecture 3: User Application Use Case

Lecture 4: Adding the mysql driver jar

Lecture 5: Create the User Table

Lecture 6: Create the User Servlet

Lecture 7: Implement the init and destroy methods

Lecture 8: Load the mysql jdbc driver class

Lecture 9: Implement the doPost method

Lecture 10: Create User Update Servlet

Lecture 11: Create the Read User Servlet

Lecture 12: Create Static HTML

Lecture 13: Create Dynamic HTML

Lecture 14: Read User Servlet Flow

Lecture 15: Delete User Assignment

Lecture 16: Delete User Assignment

Chapter 8: Init Parameters

Lecture 1: Servlet Init Params Introduction

Lecture 2: Configuring Init Params using Annotations

Lecture 3: Use annotated init params

Lecture 4: Annotated Init Params in action

Lecture 5: Configure using web xml

Lecture 6: Use init params from web xml

Chapter 9: Servlet Context

Lecture 1: Introduction

Lecture 2: Uses of ServletContext

Lecture 3: Context Parameters