Prepared Statements and Stored Procedures
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.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 9 hours
- Course by LearnQuest
-
Offered by
About
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.Modules
Course Introduction
-
1
Videos
1
Videos
- Course Introduction
Prepared Statement Processing
-
4
Videos
-
1
Readings
-
1
Discussion
-
1
Plugin
-
2
Lab
-
2
Assignment
2
Assignment
- Quiz
- Module 1 Exam
1
Discussions
- Prepared Statement Advantages
2
Labs
- Lab 1.1 Prepared Statements
- Lab 2.2 Meta Data
4
Videos
- Prepared Statements
- Lab 1.1 Walkthrough
- MetaData
- Lab 1.2 Walkthrough
1
Readings
- Prepared Statements
Escape Clauses and Stored Procedures
-
4
Videos
-
1
Readings
-
1
Discussion
-
1
Plugin
-
2
Lab
-
2
Assignment
2
Assignment
- Module Quiz
- Module 2 Exam
1
Discussions
- Stored Procedures Why?
2
Labs
- Lab 2.1 Escape Clauses
- Lab 2.2 Stored Procedures
4
Videos
- Escape Clauses
- Lab 2.1 Walkthrough
- Stored Procedures
- Lab 2.2 Walkthrough
1
Readings
- Escape Clauses
Auto Summary
Enhance your Java Database Connectivity (JDBC) skills with the "Prepared Statements and Stored Procedures" course, designed for IT and Computer Science enthusiasts. This foundational course, taught by Coursera, delves into the benefits of PreparedStatements and the use of Stored Procedures to simplify complex SQL logic. Over 540 minutes, you'll learn to query database metadata and manage varying SQL syntax across databases. Available through Starter and Professional subscriptions, this course is perfect for those looking to advance their database management capabilities.
Marnie Knue