|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-plsql/
课程评论：没有评论
课程名称：精通 PL/SQL 课程概述：是否对“游标”、“函数”、“过程”和“触发器”等术语感到困惑？如果你在寻找一个以轻松有趣的方式教授 PL/SQL 基础知识的课程，那么这个课程将非常适合你。该课程已被 CourseMarks 选为前 2% 的课程之一。 随着全球对数据库专家的需求不断增长，本课程旨在填补这一空白。专为初学者设计的 PL/SQL 课程，将带领你踏上一段精彩的学习之旅，使你从初学者成长为 PL/SQL 的专家。在课程中，你将学习如何使用 Oracle 这一全球使用最广泛的数据库软件，通过 PL/SQL 语句实现业务逻辑，涵盖游标、过程、函数和触发器等概念。所有概念通过大量示例进行讲解，使学习过程既有趣又刺激。课程的主要优势在于通过实践示例进行详细解释，帮助学习者轻松掌握内容。 课程内容概述： 第1部分：PL/SQL 基础 - PL/SQL 简介 - PL/SQL 架构 - PL/SQL 语言元素 - PL/SQL 块结构 第2部分：变量和常量 - PL/SQL 中的变量 - PL/SQL 的选择语句 - PL/SQL 中的常量 - 变量属性 第3部分：条件、循环和顺序语句 - 条件语句 - 简单循环 - While 循环 - For 循环 - 顺序控制 - 赋值及其解决方案 第4部分：异常处理 - 异常的类型 - 处理预定义和非预定义的 Oracle 服务器错误 - 显式异常 - 错误捕获函数 - 在声明部分引发的异常 - 异常传播 - 异常重新抛出 - 具体演示 - 赋值及其解决方案 第5部分：游标处理 - 游标概念 - 隐式游标 - 显式游标 - 游标 For 循环 - 带参数的游标 - 游标赋值及其解决方案 第6部分：子程序、函数和过程 - 子程序及其类型 - 局部函数 - 存储函数 - 具体演示 - 局部过程 - 存储过程 - 赋值及其解决方案 第7部分：触发器 - 触发器概念 - 触发器的用途和应用 - 触发器的类型 - 语句和行级触发器 - 触发器的语法 - 旧关键字和新关键字 - 引发应用错误 - 赋值及其解决方案 课程特点： - 超过 9 小时的视频内容 - 超过 70 个视频时段 - 足够的阅读材料以帮助理解概念 - 每个部分后的测验以检查学习进度 - 每个部分都有作业，实践学习 - 优秀的数据库管理系统（DBMS）准备课程 - 成为 PL/SQL 专家的绝佳方法，为求职和面试做好准备。
Do words like Cursor, Function, Procedure and Trigger sound confusing to you? Have you been looking for a course that teaches you all the basics of PL/SQL in a fun relaxed manner? If so then you are going to find this course absolutely perfect for you.This course has been selected in the list of Top 2% courses by CourseMarksThere is a growing demand for database experts all over the world. And this course is intended to fill this gap. This course on PL/SQL has been specially designed to better equip the learners for their academic and professional career.This course is aimed at beginners, and it will guide you on a wonderful journey to transform you from naïve to expert of PL/SQL. In this course, you'll learn the PL/SQL using Oracle, i.e., the most widely used Database Software in the world.In this course you will learn how to use PL/SQL statements to implement business logic with the use of Cursors, Procedures, Functions and Triggers. All these concepts are covered through lot of examples to make the learning fun and exciting. The main strength of the course is explanation with the practical examples so that learners can grasp the contents easily.Overview of Course Contents:Section-1: Basics of PL/SQL· Introduction to PL/SQL· Architecture of PL/SQL· PL/SQL Language Elements· Structure of PL/SQL BlockSection-2: Variables and Constants· Variables in PL/SQL· Select into Statement of PL/SQL· Constants in PL/SQL· Variable AttributesSection-3: Conditional, Looping and Sequential Statements· Conditional Statements· Simple Loop· While Loop· For Loop· Sequential Control· Assignments and Its SolutionSection-4: Exception Handling· Major strengths of this course is as follows:· Types of Exceptions· Handling of Predefined and Non-Predefined Oracle Server Errors· Explicit Exceptions· Error Trapping Functions· Exceptions raised in Declare Section· Propagation of Exceptions· Re-raising of Exceptions· Demonstrations· Assignment and Its SolutionSection-5: Cursor Handling· Concept of Cursor· Implicit Cursor· Explicit Cursor· Demonstrations· Cursor For Loop· Cursor with Parameters· Cursor Assignments and Its SolutionsSection-6: Sub-Programs, Functions and Procedures· Sub Programs & Its Types· Local Functions· Stored Functions· Demonstrations· Local Procedures· Stored Procedures· Assignments & Its SolutionsSection 7: Trigger· Concept of Trigger· Uses and Applications of Trigger· Types of Trigger· Before Statement & Row Level Trigger· After Statement & Row Level Trigger· Syntax of Trigger· Old and New Keywords· Raising Application Errors· Assignments & Its SolutionsStrengths of Course· More than 9 Hours of Video Contents· More than 70 Video Sessions· Enough Reading Material to Brain Map the Concepts· Quizzes after each section to check your progress· Every Section has Assignments to have learning by doing pedagogy· Excellent course to prepare for DBMS · Excellent way to become expert of PL/SQL before placement and Interviews
