Java Database Connectivity

You are here : Home / Courses / Java Database Connectivity

Java Database Connectivity course will introduce you to JDBC 3.0 API that will teach you of how to establish the connection to database server, and then various SQL operations using JDBC API.

This course also covers JDBC architecture, transaction management and Connection Pooling using JNDI.

Topics Covered
→ JDBC using MySQL Server

Price: $700 CAD
Prerequisite: Core Java
Duration: 8 Weeks
Schedule:  To enroll to this course, Please send us an email to contact@sanrus.ca

1) Introduction
  1. JDBC Overview
  2. Installing MySQL DB Server
  3. Creating database
  4. Creating tables
2) JDBC Drivers
  1. Type 1 : JDBC-ODBC driver
  2. Type 2 : Native API, part-Java driver
  3. Type 3 : Pure Java driver for database middleware
  4. Type 4: Pure Java driver for direct-to-database
3) JDBC Architecture
4) Connection Management
  1. Using DriverManager with MySQL JDBC Driver
5) Database Access
  1. java.sql.Connection
  2. java.sql.Statement
  3. java.sql.PreparedStatement
  4. java.sql.ResultSet
6) JDBC Data Types and Metadata
7) JDBC Exceptions and Warnings
8) JDBC Connection Pooling
9) Distributed Transaction Management and Save points