|
Provided by: Serebra Learning Corporation JDBC and DatabasesJDBC |
 |
This course is the sixth in a series of seven on the Advanced Java Topics. This course teaches students how to add database functionality to a Java program using JDBC. The course covers connections cursors statements drivers and architectural issues. Recommended browser is Internet Explorer
|
|
||||||||
- K asked: hi sir, plz give material
- R asked: How much is this taning course?
This course is designed for programmers with an advanced knowledge of Javaa .
PrerequisitesFamiliarity with C++ or any other object-oriented programming language. The audience should also be familiar with the Internet and Internet terminology.
Topics IncludeAn Introduction to JDBC and Databases
- An Introduction to JDBC
- How JDBC Works
- The java.sql Package
- Overview of JDBC 2.0 Enhancements
- JDBC and Drivers
Database and SQL Basics
- Types of Databases
- Primeval Databases
- Relational Databases
- Object Databases
- Introduction to SQL
- SQL Data Types
- Basic Queries
- SQL Transactions and Access Rights
Lesson: JDBC Programming
- Introducing the Sample Applet
- Configuring the ODBC Data Source
- Connecting to the Database
- Creating Tables
- Retrieving Data
- Executing Arbitrary SQL Statements
- JDBC 2.0: ResultSet and Statement Enhancements
- Callable and Prepared Statements
- Callable Statements
- Optimizing Access with Prepared Statements
- Warnings and Exceptions
Writing a JDBC Driver
- About Drivers
- Before you Start
- Driver Classes and Interfaces (Unlocked)
- Native Drivers Connection Establishment
- Processing Statements and ResultSets
Design Considerations
- Patterns
- Structures
- Two-Tier Architecture
- Three-Tier Architecture
- Deployment
- Commercial Products
11 hrs
Minimum RequirementsMicrosoft Windows 95 98 or NT; 16 MB RAM (32MB or greater recommended); Pentium processor or equivalent; 800 x 600 resolution; 256 colors minimum (1024 x 768 resolution recommended); sound capabilities: highly recommended; Recommended browser is Internet Explorer.
MediaCDROM
Web Based Training
