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:
CONTENT AND OBJECTIVES:
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 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.
Using JDBC
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.
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.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi 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 CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
