Intelligentedu Best New Free Computer IT Training Tutorial Resources

Here is a complete set of Slides, Lab Exervises, Code, and Tutorials covering JDBC (Java Database Connectivity).

Here is the Java Code and the practice database, and here are the exercises: JDBC Lab 1 Exercises and JDBC Lab 2 Exercises.


JDBC Slides Set 1: Introduction to Java Database Connectivity
Provides background on JDBC to help with the lab exercises
(39 slides, 445kb, ppt format)

1. What is JDBC?
2. The JDBC-ODBC Bridge
3. Four Kinds of JDBC Drivers
4. JDBC Pseudocode
5. simpJDBC.java
6. Meta Data
7. Books.mdb as an ODBC Data Source
8. Table in Books.mdb
9. More Information


JDBC Slides Set 2: Advanced Java Database Connectivity
Looks at some of the advanced parts of JDBC to help with the lab exercises
(43 slides, 345kb, ppt format)

1. SQL Statements
2. Executing DDL and DML
3. PreparedStatement Objects
4. Database Metadata
5. More Information


MySQL Tutorial  covers the following topics:
 - Starting and Stopping MySQL Server
 - Connecting to MySQL
 - Creating User Accounts
 - Using MySQL
 - MySQL Administration
 - Accessing MySQL using Java
 - mysqljdbc.jar

Tutorial for MS Access covers the following topics:
 - Creating Databases and Executing SQL
 - Creating ODBC Data Source
 - Accessing Database Using Java

Popularity: 17% [?]