Java Database Integration with JDBC [repost]

Whether you're building a web- or desktop-based application with Java SE or Java EE, many Java applications need to integrate data from a relational database. This course describes how to read and manage data from relational databases such as MySQL and SQL Server using the Java Database Connectivity (JDBC) API. Author David Gassner explains how to choose a JDBC driver and connect to one or more databases. He also provides detailed instructions on reading, selecting, and updating data; calling stored procedures; managing data via JavaBean classes or with prepared statements; and working with metadata.

Topics include:
Importing a MySQL database
Connecting to databases
Handling JDBC exceptions
Looping through result sets
Limiting the number of fetched rows
Filtering data with prepared statements
Calling stored procedures
Inserting, updating, and deleting rows with prepared statements
Using a persistent database connection
Committing and rolling back transactions

Introduction 5m 23s
Welcome 53s
What you should know before starting this course 1m 20s
Using the exercise files 3m 10s

1. Installing Software 12m 2s
Testing your Java development environment 5m 14s
Importing a MySQL database 5m 1s
Creating a database user in MySQL 1m 47s

2. Getting Started with JDBC 32m 47s
What is JDBC? 4m 26s
Choosing a JDBC driver 6m 46s
Connecting to a MySQL database server 8m 7s
Connecting to a HyperSQL database file 6m 23s
Executing a static SQL statement 7m 5s

3. Managing Database Resources 17m 42s
Connecting to multiple databases 6m 24s
Handling JDBC exceptions 7m 7s
Closing database resources in Java 7 4m 11s

4. Reading Data 47m 25s
Looping through result sets 8m 23s
Moving the cursor in scrollable result sets 5m 51s
Limiting the number of fetched rows 6m 57s
Filtering data with prepared statements 6m 58s
Calling stored procedures 5m 48s
Handling multiple values from stored procedures 5m 54s
Using generic getter methods in Java SE 7 7m 34s

5. Managing Data 45m 23s
Managing data entities with JavaBean classes 5m 0s
Retrieving a single row as a JavaBean object 6m 5s
Inserting rows with prepared statements 8m 2s
Updating rows with prepared statements 5m 4s
Deleting rows with prepared statements 4m 9s
Managing data with updatable result sets 6m 6s
Using a persistent database connection 6m 43s
Committing and rolling back transactions 4m 14s

6. Using Metadata 9m 35s
Getting the DatabaseMetaData object 3m 40s
Getting column and data type information 5m 55s

Conclusion 50s
Next steps 50s