Java Database Connection: JDBC and MySQL

Course Description

The course starts with an overview of the JDBC API. Then you learn how to set up your development environment with the appropriate MySQL database drivers. Next the course shows you how to submit a SQL query and process the result set. Also, you learn how to perform SQL insert, updates and deletes.

The course moves on to advanced topics such as Prepared Statements to handle SQL paramaters. You also learn how to call stored procedures using various parameter types (IN, INOUT, OUT and ResultSet). Next, the course shows you how to process large data types such as BLOBs and CLOBs. Finally, the course wraps up with a section on reading database connection information from a configuration file.

Skills

  • MySQL
  • JDBC

Course Topics

Progress

  • Installing MySQl & Workbench
  • Install & setup JDBC
  • Submitting SQL Queries
  • Inserting data int he DB
  • Updating data in the DB
  • Deleting data in the DB
  • Prepared statements
  • Stored procedures
  • ...

Progress

Course progress

In Portfolios