This course is part of the Java Database Connectivity Specialization

Offered By

Java Database Connectivity SpecializationLearnQuest

About 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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 4 in the

Java Database Connectivity Specialization

Beginner Level

JDBC 1

Approx. 8 hours to complete

English

Skills you will gain

Java Database Connectivity (JDBC)
Stored Procedure (SPROC)
Java Programming
PreparedStatement
Junit

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 2 of 4 in the

Java Database Connectivity Specialization

Beginner Level

JDBC 1

Approx. 8 hours to complete

English

Instructor

Marnie Knue

460 Learners

1 Course

Offered by

LearnQuest

LearnQuest is the preferred training partner to the world’s leading companies, organizations, and government agencies. Our team boasts 20+ years of experience designing, developing and delivering a full suite industry-leading technology education classes and training solutions across the globe. Our trainers, equipped with expert industry experience and an unparalleled commitment to quality, facilitate classes that are offered in various delivery formats so our clients can obtain the training they need when and where they need it.

Syllabus - What you will learn from this course

Week1

Week 1

4 hours to complete

Prepared Statements and Meta Data

4 hours to complete

5 videos (Total 21 min), 1 reading, 2 quizzes

Week2

Week 2

4 hours to complete

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

4 hours to complete

4 videos (Total 16 min), 1 reading, 2 quizzes

About the Java Database Connectivity Specialization

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.
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.

More questions? Visit the Learner Help Center.

Prepared Statements and Stored Procedures

About this Course

Skills you will gain