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

LearnQuest

Prepared Statements and Stored Procedures

LearnQuest via Coursera

Overview

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.

Syllabus

  • 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
  • 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

Taught by

Marnie Knue

Reviews

Start your review of Prepared Statements and Stored Procedures

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.