Principles of web development and J2EE
-
Source code
-
Introduction to client-server architecture (6:24)
-
Introduction to JSP, servlet and servlet containers (2:05)
-
General structure of the Java web project (6:30)
-
HTTP servlets in details (6:58)
-
web.xml deployment descriptor and deploying the application to servlet container (6:55)
-
Using HTTP post methods in JSP and servlet (5:53)
-
HTTP Methods
-
HttpServletResponse object and accessing it with scriptlets (5:43)
-
Request, session and application scopes (5:51)
-
Demonstration of session scope (1:59)
-
Request forwarding and request redirection (5:37)
-
JSP actions (get/set property) to access objects in every scope easily (5:42)
-
getBean()/setBean() scriptlets and getAttribute()/setAttribute methods in action (3:13)
WORKING WITH DATABASES
-
Executing DB script and downloading source code
-
Introduction to database design principles - Database normalization (11:41)
-
Database Design Basics
-
select, insert, delete, update queries (17:36)
-
Database connections, JDBC basics and DB connection pools (4:09)
-
Database transactions - All or nothing principle (3:08)
-
ACID properties of database transactions (9:15)
-
DB table relations - One to many, many to many with example scenario (12:00)
-
Joining tables - Inner join, outer join with examples (16:57)
CODING OUR QA PLATFORM
-
Understanding the flow that we will code (6:05)
-
Get DB connection with JDBC - Use case: User management module (8:44)
-
Great performance improvement with DB connection pools (2:40)
-
Statement and PreparedStatement - Use case: User Management Module (17:23)
-
Select queries, count queries and ResultSet object with examples (10:33)
-
Initializing DB connection pools on application bootstrapping (17:51)
-
Database Connection Pools
-
Showing the results of DB operations to the user (12:17)
-
Developing complete email validation system (14:36)
-
Developing complete login system (13:08)
Design Patterns and Applying Them to QA Project
-
Definition and importance of design patterns (8:43)
-
Design Patterns
-
Template pattern and Data Access Object (DAO) pattern (11:32)
-
DAO pattern and template pattern
-
Coding DAO pattern, template pattern, dynamic SQL values and row mappers (12:36)
-
Code walkthrough 1 - Search for a member in member DAO (9:23)
-
Code walkthrough 2 - Insert a member in member DAO (3:42)
-
Combining DAO and service layers (11:17)
-
Combining service layer and view layer (6:29)
-
Code walkthrough 3 - Integrated view layer, service layer, DAO layer (17:33)
-
Code walkthrough 4 - Question voting system (17:10)
MAKE THE PROJECT WEB 2.0
ADVANCED TOPICS
