Java JDBC and Servlets
Interactive Instructor Based Video Training Courses

Trainer

Outline

Specials

Buy Options

1. 4 Levels (not sold separately) including the following topics • Introduction to Relational Databases(RDBM) • RDBMSs and Java • Learning SQL • Database Structure • Creating & Maintaining Databases • Queries • JDBC Fundamentals & Environment • Multi-tier Models • JDBC Drivers and URLs • Classes and Interfaces • Handling Exceptions and Transactions • Stored Procedures • Database Meta Data • The CGI Model • The Servlet Model • HTML Components • HTTP GET and POST Methods • Servlet Packages • Accessing Servlets • Form Processing • Cookies • Session Management 2. JDBC & Servlet Coursware Book (see appendix for complete outline)

Course Description: As the need increases for Web Applications, so does the need for Web Application Developers. KeyStone’s Java™ training will provide you with a strong foundation in the three main areas of web application development: databases, SQL, HTML and Servlets.

About this Software: JDBC™ technology is an API that lets you access virtually any tabular data source from the JavaTM programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and now, with the new JDBC™ API, it also provides access to other tabular data sources, such as spreadsheets or flat files. The JDBC™ API allows developers to take advantage of the Java platform's "Write Once, Run AnywhereTM" capabilities for industrial strength, cross-platform applications that require access to enterprise data. With a JDBC™ technology-enabled driver, a developer can easily connect all corporate data even in a heterogeneous environment.

Competitive Advantages: 1. Our training is media-rich, interactive and engaging. Unlike many of our competitors, we incorporate talking heads, screen shots, PowerPoint presentations, and white board simulations to give our customers an engaging learning experience rather than a boring one. 2. We use Trainix™ instructors. Trainix has developed high impact courseware that is considered the gold standard in the industry. They only employ the highly experienced technical person who can break down complex technical details into simple examples and everyday language.

Trainer Information: Eric Rich Eric Rich has been employed with Trainix since 1997, and is formally trained in Java™, Unix/C++, as a Linux Professional and a Langevin Teaching Professional. Eric developed the Bitstorm ISP Network as the Web Administrator, and programmed the management and billing systems. He has also provided consulting and instructional services for AT&T, IBM, NASA and the Florida Institute of Technology. This training is a collaborative project by Trainix, Inc. and Baer Wolf.

	Java JDBC and Servlets: Level 1
	1.0 INTRODUCTION TO DATABASES 1.1 Introduction to Databases 1.2 What is an RDBMS? 1.3 Why are RDBMSs Used? 1.4 RDBMS Choices 1.5 Structure of a Relational Database 1.6 Tables 1.7 Related Data 1.8 Structured Query Language 1.9 SQL Language Types 1.10 Proprietary SQLs 1.11 IDEs with Database Support 1.12 RDBMSs and Java 2.0 LEARNING SQL 2.1 About MySQL? 2.2 Installing and Running MySQL 2.3 MySQL Syntax	2.4 Database Structure 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types 2.9 Column Attributes 2.10 Obtaining Database Information 2.11 Altering Table Structure 2.12 Saving Data 2.13 Dropping Tables 2.14 Inserting Data into Tables 2.15 Queries 2.16 SQL Operators 2.17 Ordering Data 2.18 Limiting Results 2.19 Query Summary 2.20 Updating Data 2.21 Selecting Data from Multiple Tables 2.22 Deleting Data

	Java JDBC and Servlets: Level 2
	1.0 JDBC FUNDAMENTALS 1.1 What is JDBC? 1.2 Multi-tier Models 1.3 JDBC Drivers and URLs 1.4 Classes and Interfaces 1.5 Java to SQL Data Type Mapping 1.6 JDBC Environment 1.7 Statements and Results 1.8 Installing and Loading the JDBC Driver 1.9 Making the Connection 1.10 Creating a Statement 1.11 Executing a Query 1.12 Freeing Resources 1.13 Debugging 1.14 Working with Result Sets 1.15 Updating a Database	2.0 ADVANCED JDBC 2.1 Handling Exceptions 2.2 Working with Dates 2.3 Inserting and Retrieving Dates 2.4 Performing Table Joins 2.5 Prepared Statements 2.6 Transactions 2.7 Stored Procedures 2.8 Scrollable Result Sets 2.9 Updatable Result Sets 2.10 Updatable Result Set Interaction 2.11 Database Meta Data 2.12 Result Set Meta Data

	Java JDBC and Servlets: Level 3
	1.0 INTRODUCTION TO HTML 1.1 What is a Markup Language? 1.2 How Does the Web Work? 1.3 Documentation 1.4 HTML Components 1.5 HTML Colors 1.6 Changing the Background Color 1.7 Adding Text and Structure	1.8 Fonts 1.9 Comments 1.10 Character Entities 1.11 Working with Links 1.12 Lists 1.13 Tables 1.14 Forms

	Java JDBC and Servlets: Level 4
	1.0 INTRODUCTION TO SERVLETS 1.1 What are Servlets? 1.2 The CGI Model 1.3 The Servlet Model 1.4 How are Servlets Efficient? 1.5 Servlet Containers 1.6 Support from IDEs 1.7 Request / Response Model 1.8 HTTP GET and POST Methods 1.9 Servlet Context 1.10 Servlet Packages 1.11 Servlet Containers 1.12 Creating a Servlet Context	1.13 HTTP Servlet Rules 1.14 A Basic Servlet 1.15 Accessing Servlets 2.0 WORKING WITH SERVLETS 2.1 HTTP Response Codes 2.2 Form Processing 2.3 Saving State 2.4 Cookies 2.5 Session Management 2.6 Sending Data 2.7 Writing to the Log

Note: Course outlines are subject to change.