|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/java-database-connectivity-prepared-statements
课程评论：没有评论
课程名称：预编译语句与存储过程 课程概述：本课程是Java数据库连接（JDBC）系列的第二部分，承接了JDBC 1课程的核心原则和技术。课程将重点介绍预编译语句（PreparedStatements），并强调其相较于JDBC语句的优势。同时，课程还将介绍如何在数据库服务器上使用存储过程（Stored Procedures）来封装复杂的SQL和PLSQL逻辑。此外，课程还引入了查询数据库元数据的概念，例如表结构，以及如何通过JDBC转义语法应对不同JDBC兼容数据库的SQL语法差异。 课程大纲： 第一部分：预编译语句与元数据 描述：在本模块中，学生将学习到预编译语句对象与JDBC语句对象的不同，预编译语句在创建时就给定SQL语句，并立即发送至数据库管理系统（DBMS）进行编译。还将介绍元数据的概念，使程序员能够了解JDBC代码所交互的数据库模式。 第二部分：转义语句与存储过程 描述：在本模块中，学生将学习存储过程，以封装一组在数据库服务器上可以执行的操作或查询。学生还将学习应对不同数据库管理系统（DBMS）供应商的SQL实现差异的技术，这被称为转义语法，它表明特定JDBC供应商提供的JDBC驱动程序能够将其转换为特定数据库可以理解的代码。
Part: 1
Title:Prepared Statements and Meta Data
Description: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
Part: 2
Title:Escape Clauses and Stored Procedures
Description: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
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.
