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.
CONTENT AND OBJECTIVES:
Describe the 2-tier and 3-tier method of working with JDBC.
Code and test a number of SQL statements including joins, unions, and subqueries.
Querying and Modifying Data
Code a number of queries with significant filtering and multiple tables.
JDBC: Java Database Connectivity
Examine the assumptions and featureset underlying JDBC.
Setup a database and establish a connection.
Become knowledgeable with multi-tier models and develop designs for different multi-tiered applications.
Setup 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.
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.
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.