distance-learning
center
Professional Distance-learning |
IT Training Services |
INPR2081 |
Java: Database Access with JDBC
|
DURATION: 3 days |
FEE: $1,495
PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
- Webmaster
- Programmer
- System Designer
- System Analyst
- IT Professional
|
|
|
|
DATES:
|
HANDS-ON TRAINING:- Database: Introduction
- Describe the 2-tier and 3-tier method of working with JDBC.
- SQL
- Code and test a number of SQL statements including joins, unions, and subqueries.
- Querying Data
- Code a number of queries with significant filtering and multiple tables.
- JDBC: Java Database Connectivity
- Examine the assumptions and featureset underlying JDBC.
- Set up a database and establish a connection.
- Become knowledgeable with multi-tier models and develop designs for different multi-tiered applications.
- Using JDBC
- Set up and install a new JDBC driver on the client systems.
- Create a remote JDBC driver on a server.
- Code two different techniques for establishing a connection to the test server.
- Use a PreparedStatement object for sending SQL statements to the database; this special type of statement is derived from the Statement class.
- JDBC: Advanced Techniques
- Acquire proficiency in handling exceptions.
- Handle errors which include: 1- A bad connection. 2- Invalid SQL statements. 3- Truncated values. 4. Returning no values.
- Compare dates and perform date arithmetic.
- Perform table joins; code an outer and a full inner join.
- A stored procedure is a group of SQL statements that form a logical unit and perform a specific task; they are used to encapsulate a set of operations or queries which execute on a database server: 1- Invoke a stored procedure that returns a resultset. 2- Process the resultset.
- Special Features
- Return the count of the number of rows affected by the operation.
- Create parameterized statements, fill in the values, and invoke a parameterized SQL statement.
- Work with large objects; retrieve a LOB and display the results.
|
|
|
|
|
|
|
|
|
|
|
|
|
Web-based Training |
|
Blended Learning |
|
|
|
|
|
|
|
|
|
|
↓ |
|
|
|
|
|
|
|
|
|
Synchronous Instruction |
|
Asynchronous Instruction |
|
|
|
|
|
|
|
|
|
|
|
Value Added Service
Common Questions
Website
|
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.