· Explain the JDBC API architecture
· Load a JDBC driver and establish a connection to a database
· Manipulate tables and perform queries in a database using JDBC
· Store and execute SQL statements, and use prepared statements and stored procedure
· Extract meta data from a database or a database management system
· Create and use scrollable and updatable result sets
Description
Building Database Client Applications Using JDBC 2.0 is a 15-hour course that teaches students how to build database client applications using JDBC 2.0. Students will learn how to apply the JDBC API to connect to relational databases; issue SQL statements and queries; and use transactions, prepared statements, stored procedures and metadata to create and manipulate database information. Students will apply the knowledge they learn in class by building a graphical client application.
Audience :
Application developers, programmers, enterprise developers, Web developers, and database developers.
Topics :
Introduction to JDBC
o JDBC - The Basics
o Relational Databases
o Structured Query Language
o System Architecture
Using JDBC Drivers
o JDBC Drivers
o Establishing a Connection
Executing SQL Statements
o The Statement Interface
o Transactions Using SQL Statements
Prepared Statements and Stored Procedures
o Prepared Statements
o Stored Procedures
Metadata
o Introduction to Metadata
o DatabaseMetaData
o ResultSetMetaData
SQLException
o Introduction to SQLException
o try and catch Blocks
o SQLException Methods
Scrollable and Updatable Result Sets
o Scrollable Result Sets
o Updatable Result Sets
Batch Updates
o Introduction to Batch Updates
o Parameterized Batch Updates
o BatchUpdateException
Recommended Knowledge :
Students must have completed Java Programming Fundamentals or have an equivalent knowledge of Java programming before taking this course. It is also recommended that students complete the Database Design Methodology course or have a basic knowledge of the purpose and function of databases.
Recommended Course(s) :
Category :
Training Materials :
CIW Official Curriculum
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
This course is a credit towards CIW Enterprise Developer Certification
