Advanced JDBC

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

JDBC is a Java-based data access technology (Java Standard Edition platform) from Oracle Corporation. This technology is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the JVM host environment.

At the end of the training, participants will be able to:

Pre-requisite

All attendees should be familiar with basic Java programming.

Duarion

5  days

Course Outline

  1. Re-Introducing JDBC
  2. Review of JDBC architecture
  3. Review of JDBC driver types
  4. Discussion of evolution of JDBC from version 1.0 through 2.0 and 3.0
  5. Principles of Agile and Scrum
  6. Database concepts review
  7. Relational database terminology
  8. SELECT, INSERT, UPDATE, and DELETE statements
  9. Transactions, logging, isolation, and concurrency
  10. Key JDBC classes and the java.sql package
  11. DriverManager and DataSource
  12. Connection
  13. Statement, PreparedStatement, and CallableStatement
  14. Extra features supported by the javax.sql package
  15. Rowsets
  16. Application development activities using the basic JDBC concepts
  17. Building an interface for selecting records
  18. Building a data-drilldown example
  19. Building interfaces for inserting, updating, and deleting records
  20. Connecting to databases
  21. Selecting and installing a database driver
  22. Connecting to the database via a network address
  23. Connecting to the database based on information supplied by JNDI (the Java Naming and Directory Interface)
  24. Using the java.sql.DataSource class
  25. Increasing performance with connection pooling
  26. Opening and closing the connection
  27. Handling ClassNotFoundException and SQLException
  28. Working with a database connection
  29. Controlling transaction behavior
  30. Using getWarning and clearWarnings to retrieve, respond to, and clear warnings
  31. Creating statements, prepared statements, and callable statements
  32. Retrieving and using database metadata
  33. Ad-Hoc SQL queries with Statement and PreparedStatement
  34. Creating a Statement object
  35. Executing a SQL statement
  36. Using executeQuery() for statements that return a ResultSet
  37. Using executeUpdate() for statements that change the database and don’t return a ResultSet
  38. Receiving a ResultSet as the result of a query
  39. Iterating through and retrieving results
  40. Moving the cursor within the ResultSet
  41. Establishing when you are at the beginning or end of the ResultSet
  42. Creating a PreparedStatement object
  43. Setting PreparedStatement parameters
  44. Executing the PreparedStatement
  45. Additional techniques for working with ResultSets
  46. Navigating the cursor forward, backward, and arbitrarily within a ResultSet
  47. Using updateable ResultSets
  48. Batch updating of ResultSets
  49. More in-depth
  50. Obtaining ResultSetMetaData
  51. What you can/can’t find out via ResultSetMetaData
  52. Obtaining column data types, names, labels, and display sizes
  53. Obtaining the column count
  54. Additional useful applications for the ResultSetMetaData
  55. JDBC transactions
  56. Understanding ACID (atomicity, consistency, isolation, and durability)
  57. Turning the committing of transactions on or off
  58. Committing and rolling back transactions
  59. Overview of distributed transactions in Java EE
  60. JDBC design patterns
  61. Overview of client tier, presentation tier, business tier, and resource tier patterns
  62. The data access object pattern
  63. The value object pattern
  64. The model-view-controller pattern
  65. Conclusion

Reviews