Exclusive
Web Development

Web Database Programming with Java
(Microsoft Training Course: F1018) - 3 days - £1700 exc VAT



> Target Audience
> Course outline
  1. Installation and Network
  2. HTML Revision
  3. Java Servlets
  4. JSP - Java Server Pages
  5. Tomcat Configuration
  6. Database Design and SQL
  7. JDBC
  8. Advanced Features
  9. JSTL - Java Standard Tag Libraries
  10. Custom Tag Libraries
  11. JavaServer Faces
  12. Technology Overview


Module 1: Installation and Network
  • TCP/IP Networking and DHCP
  • Firewalls and the DMZ
  • J2SE Installation
  • Tomcat Installation
  • Web Server Integration
top
Module 2: HTML Revision
  • HTML Forms
  • ContentType
  • POST and GET
  • URL Rewriting and Extra Path
  • Headers and Redirect
  • Caching and Refresh
  • JavaScript
top
Module 3: Java Servlets
  • Response and Request objects
  • Forwarding a Request
  • Sessions and cookies
  • ServletContext Attributes
  • Initialisation Parameters
  • Best Practice Software Design
  • Java Beans
top
Module 4: JSP - Java Server Pages
  • <%@ directives %>
  • <%! declarations %>
  • <%= expressions; %>
  • Implicit objects
  • <% scriptlets %>
  • <jsp: actions %>
  • <jsp: usebean %>
top
Module 5: Tomcat Configuration
  • Directory Structure
  • war files
  • Configuring web applications
  • User Authentication
  • Tomcat Configuration
  • Welcome Page
  • Error Pages
  • Management and Administration System
  • Filters
top
Module 6: Database Design and SQL
  • Installation of MySQL
  • Introduction to Database Design
  • Creating tables
  • SELECT, UPDATE and DELETE
  • Sophisticated Queries
  • Aggregated Queries
  • Correlated Queries
  • Performance Issues
top
Module 7: JDBC
  • JDBC Installation
  • ResultSets
  • MetaData
  • Prepared Statements
  • Stored Procedures
  • Scalar Functions
  • Datasource and Connection Pooling
  • RowSets and Persistence
  • JNDI Setup in Tomcat
top
Module 8: Advanced Features
  • Error handling
  • Security
  • Filters
  • Threading
  • JavaMail
  • Internationalisation
  • Listeners
top
Module 9: JSTL - Java Standard Tag Libraries
  • Core Tags
  • XML Tags
  • Internationalisation Tags
  • Database Tags
  • Expression Language
top
Module 10: Custom Tag Libraries
  • Tags
  • Body Tags
  • Iterated Tags
  • Attributes
  • Nested Tags
  • Tomcat Configuration
top
Module 11: JavaServer Faces
  • Forms
  • Tag Library
  • Database Beans
  • Validation
  • Navigation
  • Configuration
top
Module 12: Technology Overview
  • Ant
  • J2EE Application Servers
  • Log4j logging
  • Enterprise Java Beans
  • Apache Struts
  • Expresso Framework
  • Persistence
top
> Pre-Requisites
Before attending this course, students should have the following pre-requisites:
  • Good programming experience.
  • Basic understanding of object-oriented programming.
  • Familiarity with the Java programming language.
  • Basic experience of HTML and web page design
> Purpose