MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Building Database Client Applications Using JDBC 2.0

Admission

Application developers, programmers, enterprise developers, Web developers, and database developers.


Building Database Client Applications Using JDBC 2.0
Exam # Duration Language Level Type Classroom Code Fees
-- 15 English Professional Course Classroom Cs164 0 LE
Description :

Building Database Client Applications Using JDBC 2.0 is a 15-hour course that teaches students how to build database client applications using JDBC 2.0. Students will learn how to apply the JDBC API to connect to relational databases; issue SQL statements and queries; and use transactions, prepared statements, stored procedures and metadata to create and manipulate database information. Students will apply the knowledge they learn in class by building a graphical client application.



Objectives :
  • Explain the JDBC API architecture
  • Load a JDBC driver and establish a connection to a database
  • Manipulate tables and perform queries in a database using JDBC
  • Store and execute SQL statements, and use prepared statements and stored procedure
  • Extract meta data from a database or a database management system
  • Create and use scrollable and updatable result sets


Topics :

Introduction to JDBC

  • JDBC - The Basics
  • Relational Databases
  • Structured Query Language
  • System Architecture

Using JDBC Drivers

  • JDBC Drivers
  • Establishing a Connection

Executing SQL Statements

  • The Statement Interface
  • Transactions Using SQL Statements

Prepared Statements and Stored Procedures

  • Prepared Statements
  • Stored Procedures

Metadata

  • Introduction to Metadata
  • DatabaseMetaData
  • ResultSetMetaData

SQLException

  • Introduction to SQLException
  • try and catch Blocks
  • SQLException Methods

Scrollable and Updatable Result Sets

  • Scrollable Result Sets
  • Updatable Result Sets

Batch Updates

  • Introduction to Batch Updates
  • Parameterized Batch Updates
  • BatchUpdateException




Recommended Knowledge :

Students must have completed Java Programming Fundamentals or have an equivalent knowledge of Java programming before taking this course. It is also recommended that students complete the Database Design Methodology course or have a basic knowledge of the purpose and function of databases.

Recommended Course(s) :
§ Database Design Methodology
§ Java Programming Fundamentals
§ Programming Concepts

 


Training Materials :

CIW Official Curriculum


Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
 

 


Credential :

This course is a credit towards CIW Enterprise Developer Certification

Category :
Programming


The Instructor: