When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Prepared Statements and Stored Procedures

This course is part of Java Database Connectivity Specialization

Instructor: LearnQuest Network

2,233 already enrolled

Included with

Learn more

2 modules

Gain insight into a topic and learn the fundamentals.

10 reviews

Beginner level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

2 modules

Gain insight into a topic and learn the fundamentals.

10 reviews

Beginner level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

91%

of learners achieved a positive career outcome

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Java Database Connectivity Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 2 modules in this course

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.

Module details

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

What's included

5 videos1 reading2 assignments1 discussion prompt2 ungraded labs1 plugin

5 videosTotal 21 minutes

Course Introduction1 minute
Prepared Statements5 minutes
Lab 1.1 Walkthrough 9 minutes
MetaData3 minutes
Lab 1.2 Walkthrough 5 minutes

1 readingTotal 10 minutes

Prepared Statements 10 minutes

2 assignmentsTotal 90 minutes

Quiz30 minutes
Module 1 Exam60 minutes

1 discussion promptTotal 10 minutes

Prepared Statement Advantages10 minutes

2 ungraded labsTotal 120 minutes

Lab 1.1 Prepared Statements60 minutes
Lab 2.2 Meta Data60 minutes

1 pluginTotal 15 minutes

Module 1 Activity15 minutes

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

What's included

4 videos1 reading2 assignments1 discussion prompt2 ungraded labs1 plugin

4 videosTotal 16 minutes

Escape Clauses3 minutes
Lab 2.1 Walkthrough3 minutes
Stored Procedures5 minutes
Lab 2.2 Walkthrough5 minutes

1 readingTotal 10 minutes

Escape Clauses10 minutes

2 assignmentsTotal 90 minutes

Module Quiz30 minutes
Module 2 Exam60 minutes

1 discussion promptTotal 10 minutes

Stored Procedures Why?10 minutes

2 ungraded labsTotal 120 minutes

Lab 2.1 Escape Clauses60 minutes
Lab 2.2 Stored Procedures60 minutes

1 pluginTotal 15 minutes

Module 2 Activi15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

LearnQuest Network

LearnQuest

207 Courses993,906 learners

Offered by

LearnQuest

Learner reviews

5 stars
80%
4 stars
0%
3 stars
0%
2 stars
10%
1 star
10%

Showing 3 of 10

Reviewed on Feb 23, 2023

It's pretty intermediate to advanced stuff here. Uses Java & embedded SQL statements - yes, it does walk you through but you need to know what you are doing beforehand.

View more reviews