LearnKey Training

Database Specialist
Using JDBC 2.0
Database Specialist Using JDBC 2.0


Database Specialist Using JDBC 2.0

2 Sessions –
6 Hours of Interactive Training
JDBC 2.0 is a Java application programming interface that allows database developers to send SQL statements to virtually any relational database. In the Database Specialist Using JDBC 2.0 course from LearnKey, expert instructor Wayne Snyder uses examples, sample programs and clear step-by-step instruction to teach you database application design with Java. At the conclusion of this course, you will be able to write platform independent applications to access Oracle, Sybase, Informix, Microsoft SQL Server, and DB2 databases.

Benefits
  • Increase your earning potential with technical mastery and proficiency.
  • Enhance employment opportunities with in-demand database knowledge.
  • LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
    • About The Author
    Wayne Snyder is recognized worldwide as a SQL Server expert and Microsoft Most Valued Professional (MVP), with over 25 years of experience in project management, database administration, software design, performance measurement and capacity planning. He is a sought out consultant, trainer, writer and speaker, and produces a series of web-based seminars on SQL Server 2005. Wayne has edited many SQL Server books, contributes monthly to SQL Server Magazine and is a Managing Consultant for Mariner, a Business Intelligence Company.
    Session 1

    Section A: Introduction to JDBC
    · JDBC API
    · Relationship Databases
    · Relation and Joins
    · SQL
    · DDL
    · Insert and Delete
    · Update and Select
    · Architecture

    Section B: Getting Started
    · JDBC API
    · Installation
    · JDBC Drivers
    · Loading a Driver
    · Command Line and For
    · Establishing a Connection
    · The URL
    · Connection Interface

    Section C: Executing SQL Statements
    · Statement Interface
    · executeQuery
    · Use getXXX Methods
    · executeUpdate
    · Execute
    · Transactions
    · Use Transactions

    Section D: Prepared Statements and SPs
    · Prepared Statements
    · Parameters
    · Executing Statements
    · Stored Procedures

    		Session 2

    Section A: MetaData
    · Overview
    · DatabaseMetaData
    · getProcedures
    · getTables
    · Tables and Schemas
    · ResultSetMetaData
    · ResultSet Code

    Section B: SQL Exceptions
    · Overview
    · SQL Exception Methods
    · Exception Code
    · Run Code

    Section C: Result Sets
    · Scrollable Result Sets
    · ResultSet Type Constant
    · createStatement
    · Update Result Set
    · Insert/Delete Rows
    · Use Insert/Delete
    · UpdateXXX Methods

    Section D: Batch Update
    · Overview
    · Batch Methods
    · createStatement Batch
    · BatchUpdateException

    Section E: Building an Application
    · Code Elements
    · Layout Code
    · Buttons
    · Scroll & getString Methods
    · Main Method
    · Compile