NETg JDBC Application Development Curriculum

Course Title

JDBC Application Development Part 1: Introduction and Architecture

Course Overview

This first course in the series provides the foundation for the rest of the course series. It introduces learners to the JDBC API and explains how it is used to access any database from Java. It also covers the basics of working with relational database systems, how to use JDBC to design multi-tier database applications, and an overview of the major steps in the JDBC program.

Learn To:

  • Identify the features and components of RDBMSs.
  • Identify the features of SQL.
  • Identify how to create and manipulate database tables, and the concepts of database querying and transaction control.
  • Identify the features of the JDBC API.
  • Identify the architecture of JDBC and advantages and limitations of two-tier and multitier JDBC applications.
  • Identify the basic JDBC programming concepts used to establish a database connection.
  • Identify the methods used for updating and querying a database, and processing the result set.

Audience

The target audiences for this course are System Administrators, Database Administrators, Application Developers, System Analysts, Software Engineers, and Programmer/Analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Total Learning Time

6 - 8 hours
2 - 3 hours Unit 1: RDBMS: Concepts
2 - 3 hours Unit 2: JDBC: Concepts
2 - 3 hours Unit 3: DBC: Programming

Course Title

JDBC Application Development Part 2: Creating Database Programs

Course Overview

This second course in the series teaches how to use the JDBC API to create database programs. It provides more detailed information about types of JDBC drivers and how to use them with Java programs. It also covers basic features of using data definition language and data manipulation language commands to create and query tables and databases.

Learn To:

  • Identify the types of JDBC drivers and how to use them with the Java programs.
  • Identify the installation of an RDBMS.
  • Create database programs using DDL and DML commands in JDBC and accessing data using JDBC.

Audience

The target audiences for this course are System Administrators, Database Administrators, Application Developers, System Analysts, Software Engineers, and Programmer/Analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Total Learning Time

6 - 8 hours
3 - 4 hours Unit 1: JDBC Drivers
3 - 4 hours Unit 2: JDBC and Database Commands

Course Title

JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ

Course Overview

This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.

Learn To:

  • Identify the advanced features for creating JDBC programs.
  • Identify PreparedStatement objects, stored procedures, transactions, concurrency control, and metadata.
  • Identify the method used to map an object-oriented design to a relational database.
  • Identify SQLJ.
  • Identify the method used to cerate database queries, manipulate data, and call stored procedures.

Audience

The targeted audience for this course are system administrators, database administrators, programmers/analysts, software engineers, application developers, and system analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Total Learning Time

6 - 8 hours
2 - 3 hours Unit 1: Advanced JDBC Features
2 - 3 hours Unit 2: OOAD
2 - 3 hours Unit 3: SQLJ

Course Title

JDBC Application Development Part 4: The 2.0 Core and Optional APIs

Course Overview

This final course in the series teaches how to use the new features in the JDBC 2.0 core API. It also covers using the optional API, which includes the ability to connect to a database with datasource objects that work with JNDI, and using rowsets.

Learn To:

  • Identify new features in JDBC 2.0 Core API and JDBC 2.0 Optional Package API.
  • Identify the rowset implementations, CachedRowSets, and RowSetReader and RowSetWriter.
  • Identify how to use rowsets with EJB.

Audience

The targeted audience for this course are system administrators, database administrators, programmers/analysts, software engineers, application developers, and system analysts. Learners should be able to design applications using object-oriented analysis and design, develop applications using the Java programming language, and use SQL to retrieve and manipulate data in a relational database.

Total Learning Time

6 - 8 hours
3 - 4 hours Unit 1: JDBC 2.0 API
3 - 4 hours Unit 2: Rowset

Regular price: $695.95padSale price: $595.95pad

Click here for Secure Yahoo Order: NETg JDBC Application Development Curriculum

Get Train in Java 
Java Software Training

Best Regards, 
Java Programming Hints and Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.