Prepared Statements and Stored Procedures (Coursera)

Offered by LearnQuest,
Prepared Statements and Stored Procedures (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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

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

Related Courses

Introduction to Java (Coursera) Coursera
LearnQuest

Introduction to Java (Coursera)

This Course is the first of a series of courses that make up the Core Java Specialization. The Core Java Specialization, in turn, is part of a series of programming specializations, derived from LearnQuest's private Java Bootcamps, designed to provide the skill set necessary to be hired as an IT developer using Java in many corporate environments. This course includes hands-on practice and will give you a solid knowledge of the Java language. After completing this course, you will be able to identify Java’s benefits, program in basic Java syntax using Java data types, and incorporate branches and loops.

Jul 6th 2026
3 Weeks
Laboratório de Programação Orientada a Objetos - Parte 1 (Coursera) Coursera
Universidade de São Paulo, Brasil

Laboratório de Programação Orientada a Objetos - Parte 1 (Coursera)

Este curso apresenta os conceitos mais importantes em torno do paradigma de desenvolvimento mais comum da indústria de software hoje: a Programação Orientação a Objetos (POO). Oferecido pelo Departamento de Ciência da Computação do Instituto de Matemática e Estatística da USP, o curso é voltado para quem já conhece os conceitos básicos de POO e quer se aprofundar no assunto, tornando-se um excelente programador. Ele funciona bem como uma sequência natural aos 2 cursos anteriores do Prof. Fabio Kon do IME-USP no coursera: Introdução à Ciência da Computação com Python.

Dec 14th 2026
5-12 Weeks
Java EE Spring prêt à l'emploi (FUN) FUN
Université Lille

Java EE Spring prêt à l'emploi (FUN)

Concevoir et implémenter la partie informatique d'une application web est une des activités les plus courantes pour de nombreux développeurs. Le langage de programmation Java, utilisé par plus de 8 millions de développeurs dans le monde, est l'un des principaux langages pour cette tâche. Ce cours vous présentera les concepts principaux de la programmation d'applications web ainsi que leur mise en oeuvre concrète.

Sep 6th 2021
5-12 Weeks
Complete Course of JDBC API Implementation (Skillshare) Skillshare
Skillshare

Complete Course of JDBC API Implementation (Skillshare)

JDBC API tutorial will help developer to make JAVA application to access Oracle 11g Database. This course is divided into two parts , BASIC and ADVANCE. This course is the Basic where we are going to learn all about JDBC API in detail. Here, we will show you demonstration, execution, examples and practice projects for HOMEWORK for hands-on experience.

Self Paced
Self-Paced
Design Principles: an Introduction (Coursera) Coursera
University of California, San Diego

Design Principles: an Introduction (Coursera)

What makes an interface intuitive? How can I tell whether one design works better than another? This course will teach you fundamental principles of design and how to effectively evaluate your work with users. You'll learn fundamental principles of visual design so that you can effectively organize and present information with your interfaces. You'll learn principles of perception and cognition that inform effective interaction design. And you'll learn how to perform and analyze controlled experiments online. In many cases, we'll use Web design as the anchoring domain.

Dec 14th 2026
3 Weeks
面向对象技术高级课程 (The Advanced Object-Oriented Technology) (Coursera) Coursera
Peking University

面向对象技术高级课程 (The Advanced Object-Oriented Technology) (Coursera)

如果将软件开发人员看作行走江湖的武侠,那么各种软件开发技术就是武侠赖以傍身的武术秘籍。有的秘籍以易学灵巧见长,练习者很快掌握,并有立竿见影的功效,但失之厚重持久;有的秘籍初学乍练顿显困难,虽冥思苦解仍不得要领,需坚持不断的内功修炼方成正果,却是成为武林大侠必备的至宝。本课程有些类似于后者。

Dec 7th 2026
13-24 Weeks
VLSI CAD Part I: Logic (Coursera) Coursera
University of Illinois at Urbana-Champaign

VLSI CAD Part I: Logic (Coursera)

A modern VLSI chip has a zillion parts -- logic, control, memory, interconnect, etc. How do we design these complex chips? Answer: CAD software tools. Learn how to build thesA modern VLSI chip is a remarkably complex beast: billions of transistors, millions of logic gates deployed for computation and control, big blocks of memory, embedded blocks of pre-designed functions designed by third parties (called “intellectual property” or IP blocks). How do people manage to design these complicated chips? Answer: a sequence of computer aided design (CAD) tools takes an abstract description of the chip, and refines it step-wise to a final design.

Dec 14th 2026
5-12 Weeks
Introduction à la programmation orientée objet (en C++) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Introduction à la programmation orientée objet (en C++) (Coursera)

Ce cours introduit la programmation orientée objet (encapsulation, abstration, héritage, polymorphisme) en l'illustrant en langage C++. Il présuppose connues les bases de la programmation (variables, types, boucles, fonctions, ...). Il est conçu comme la suite du cours « Initiation à la programmation (en C++) ».

Dec 7th 2026
5-12 Weeks