Globale inhoud:

Java Database Connectivity (JDBC) for Application Developers is a two day hands-on workshop that explores JDBC application development using a combination of lecture and labs. Each lesson has performance-driven objectives that ensure students will learn technologies and hands-on skills core to fundamental Java programming nothing more, nothing less. All lessons have clear objectives, are fundamental to learning core Java programming practices, and are reinforced by hands-on code labs and solid practical examples. Progressive labs are designed in such a way that students get a firm grasp on fundamental skills while they work toward building a complete Java application. A separate Java Work Book accompanies this course to guide students through hands-on exercises and projects. Formal written exercises, tutorials and code solutions ensure hands-on work is clear, concise and useful, both during class and afterwards. All labs are take-home, and all solution code is presented in an easy to use self study format for future use and review. At completion you will be able to write JDBC applications that access a database, retrieve and manipulate data of intermediate to advanced level complexity.

Invulling:

Consisting of approximately 50% lab and 50% technical lecture, this workshop includes many carefully interspersed hands-on, practical lab exercises. Presented in a progressive building block fashion, these labs detail the development and deployment of an application from start to finish. At the end of each lab and lesson, developers will be tested with a set of review questions to ensure that he/she fully understands the topic, illustrations and labs.

Specifieke inhoud:

Module 1 - JDBC Fundamentals

• Introducing JDBC
• JDBC Drivers
• Database Concepts

Module 2 - Getting Started With JDBC

• Making Simple Data Connections
• Handling SQL Exceptions and Warnings
• Retrieving Data from The Database
• Updating Data in the Database
• Using Prepared Statements

Module 3 - Intermediate JDBC

• Transactions
• Batch Updates
• Scrollable Resultsets
• Rowsets
• Stored Procedures

Module 4 - Advanced JDBC

• Database Metadata
• Server-Side JDBC

Opmerkingen