Java Database Access Using JDBC
Live Instructor-Led Classroom Training
Java has become the language of choice for many enterprise application developers. Because Sun Microsystems recognizes the importance of data access and manipulation to business applications, they developed the Java Database Connectivity (JDBC) API to allow for secure, robust, and portable enterprise-level data access. Similar to Microsoft's Open Database Connectivity (ODBC), JDBC is an open API that enables cross-vendor data access. However, JDBC is much more Object-Oriented in nature, as it was developed specifically for use with Java. The new JDBC 3.0 contains powerful enhancements over the previous versions of the API. For instance, it allows developers to access data from flat files, as well as from databases. In addition, version 3.0 introduces robust mechanisms for doing batch updates, creating transaction savepoints, and implementing distributed transactions.
This 3-day hands-on class will introduce developers to all these topics, as well as addressing more advanced topics, such as transactional programming and performance, JavaBeans, and design patterns. The class includes many hands-on exercises, and students will come away with the ability to successfully access, update, and manipulate data in both client- and server-side Java applications. Furthermore, they will have learned the information necessary to making important design decisions concerning performance trade-offs.
Who Should Attend
The workshop material is aimed at developers who will be writing data-centric applications using the Java Platform.
Students should have strong Java programming experience and should be familiar with the basics of relational databases and SQL.
- Connect to databases and execute SQL commands.
- Manipulate data result sets.
- Map Java data types to their JDBC counterparts and vice versa.
- Use transactions to support business logic.
- Discover database objects and their properties at runtime using database metadata.
- Improve applications with common design patterns.
- Optimize data access performance.
- Interact with Enterprise JavaBeans (EJBs).
A leader in live technical training since 1978
For many years New Instruction, LLC had been known as an innovative provider of training, consulting and software development services, and clients have often asked us to share our software quality methodologies with them. Those requests led to the development of our longest running workshop, "Testing and Quality Assurance Techniques", now in it's 11th edition.
Drop Us a Line
615 Valley Road
Montclair, NJ 07043