This is the second course in Java Database Connectivity (JDBC) and builds upon the core principals and techniques in the JDBC 1 course. It utilizes PreparedStatements, highlighting their advantages over JDBC Statements. It will also introduce utilizing Stored Procedures on the database server itself to encapsulate complex SQL and PLSQL logic. The Course also introduces the idea of querying the database meta data such as table structures and how to cope with different SQL syntax for different Jdbc complaint databases via the JDBC escape syntax.

Enroll in course

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course 2 of 4 in the Java Database Connectivity Specialization.

Syllabus

WEEK 1

Prepared Statements and Meta Data

In this module the student will learn how PreparedStatement objects, unlike a JDBC Statement object, it is given a SQL statement when it is created and is sent to the DBMS right away, where it is compiled. It will also introduce the concept of Meta data enabling the programmer to gain an understanding of the database Schema the JDBC code is interacting with

WEEK 2

Escape Clauses and Stored Procedures

In this module the student will learn about Stored Procedures to encapsulate a set of operations or queries that cna be executed on a database server. The student will also learn about the techniques on dealing with the differences in the way different DBMS vendors implement SQL. This is called escape syntax. which signals that the JDBC driver, provided by a particular JDBC vendor can converts it into code that its particular database can understand

Java Database Connectivity Specialization

Java Database Connectivity

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing

Coursera

LearnQuest

Marnie Knue