::Java Database Connectivity - Sanrus Training Centre ::

Loading...

Java Database Connectivity

You are here : Home / Courses / Java Database Connectivity


Overview
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:
Sunday Batch:- 2PM to 5PM
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
Support Services:
  1. → 3 Mock Interviews
  2. → Attend 3 sessions (3 hr/session) after the course is completed.
Price: $200 CAD

*Support Services are optional to all the courses.