Prepared Statements and Stored Procedures
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Prepared Statements and Stored Procedures
This course is part of Java Database Connectivity Specialization
Instructor: LearnQuest Network
2,237 already enrolled
Included with
Details to know
4 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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.
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 videos•Total 21 minutes
- Course Introduction•1 minute
- Prepared Statements•5 minutes
- Lab 1.1 Walkthrough •9 minutes
- MetaData•3 minutes
- Lab 1.2 Walkthrough •5 minutes
1 reading•Total 10 minutes
- Prepared Statements •10 minutes
2 assignments•Total 90 minutes
- Module 1 Exam•60 minutes
- Quiz•30 minutes
1 discussion prompt•Total 10 minutes
- Prepared Statement Advantages•10 minutes
2 ungraded labs•Total 120 minutes
- Lab 1.1 Prepared Statements•60 minutes
- Lab 2.2 Meta Data•60 minutes
1 plugin•Total 15 minutes
- Module 1 Activity•15 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 videos•Total 16 minutes
- Escape Clauses•3 minutes
- Lab 2.1 Walkthrough•3 minutes
- Stored Procedures•5 minutes
- Lab 2.2 Walkthrough•5 minutes
1 reading•Total 10 minutes
- Escape Clauses•10 minutes
2 assignments•Total 90 minutes
- Module 2 Exam•60 minutes
- Module Quiz•30 minutes
1 discussion prompt•Total 10 minutes
- Stored Procedures Why?•10 minutes
2 ungraded labs•Total 120 minutes
- Lab 2.1 Escape Clauses•60 minutes
- Lab 2.2 Stored Procedures•60 minutes
1 plugin•Total 15 minutes
- Module 2 Activi•15 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
Offered by
Explore more from Software Development
- Status: Free TrialL
LearnQuest
Course
Guided Project
Guided Project
- Status: Free Trial
Course
Why people choose Coursera for their career
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.
Frequently asked questions
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.
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.
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
Financial aid available,