Oracle PL/SQL Fundamentals with Case Study (OCI)

SQL 和 PL/SQL 已将自己确立为跨许多不同行业使用的事实上的数据访问语言，可在数据库中使用。

这意味着 SQL 和 PL/SQL 不再只是由开发人员使用，而是来自许多不同并行技术领域的人员需要存储、操作和访问大量数据——使用切片和骰子概念对其进行分析以获取有意义的业务信息从而使业务具有竞争优势。

由于这个原因，SQL 和 PL/SQL 无处可去。它的受欢迎程度稳定，并且在并排比较时仍然使 NoSQL 数据库相形见绌。

PLSQL 的优点是

PL/SQL 允许一次将整个语句块发送到数据库。这减少了网络流量并为应用程序提供了高性能。

PL/SQL 为程序员提供了高生产力，因为它可以查询、转换和更新数据库中的数据。

用 PL/SQL 编写的应用程序是完全可移植的。

通过本课程，您可以了解如何供应最新的 Oracle Cloud Autonomous Database 19c，

Oracle 云基础设施一如既往的免费层，利用它来学习 SQL（本课程未详细介绍）和详细介绍的 PL/SQL。

本课程涵盖的 PL/SQL 主题是

学习和实践的不同 Oracle DB 环境。

如何访问 Oracle 云免费层。

关于所有新的 Oracle 自治云数据库的概述。

在 OCI 上供应 Oracle 自治数据库

访问 Oracle Cloud Autonomous DB for SQL – Web 和客户端版本 – SQL Developer。

什么是 PLSQL？

Oracle PLSQL 编程方法

命名约定和格式。

变量声明和嵌套块的范围

使用 PLSQL 与 Oracle DB 交互

PLSQL 中的游标。

PLSQL 中的控制语句

处理 PLSQL 中的异常

子程序和复合数据类型

数据库触发器。

SQL 和 PLSQL 中的案例研究

以文档格式提供商业案例和问题陈述，供学习者使用并提供解决方案。

详细的解决方案演示以验证您的解决方案。

Build Oracle PL/SQL expertise using Oracle Cloud Autonomous DB (OCI). Built-in case study to make understanding better

Published 05/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 43 lectures (4h 29m) | Size: 2.82 GB

What you’ll learn

• Oracle PL/SQL Programming
• Provisioning Oracle Cloud Autonomous Database with Oracle Cloud Infrastructure(OCI)
• Connecting to Cloud Autonomous Database using SQL Developer client.
• Case study to make understanding of PL/SQL better

Requirements

• Basic understanding of Oracle SQL statements.
• Oracle Database Access through SQL OR Request / provision Autonomous Oracle Cloud Autonomous Database in OCI free tier

Description

The big question is – is SQL & PLSQL still relevant and should you learn it? Well, the answer is: Yes.

SQL & PL/SQL has established itself as the de-facto data access language used across many different industries, that’s available in the database.

This means that SQL & PL/SQL is no longer just used by developers, but folks from many different parallel technical fields that need to store, manipulate, and access large volumes of data – analyse it with slice and dice concept to derive meaningful business information so as to have the business in competitive edge.

For this reason, SQL and PL/SQL isn’t going anywhere. Its stable in popularity and still dwarfs NoSQL databases on a side by side comparison.

The advantage of PLSQL is

• PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.
• PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.
• Applications written in PL/SQL are fully portable.

With this course, you can learn how to provision the latest Oracle Cloud Autonomous Database 19c which is provided on

Oracle cloud infrastructure as always free tier , utilize it to learn SQL (not covered in detail in this course ) and PL/SQL, which is covered in details.

The PL/SQL topics covered in this course are

• Different Oracle DB environment to Learn & Practice.
• How to get access to Oracle Cloud Free tier.
• An Overview about all new Oracle Autonomous Cloud Database.
• Provisioning Oracle Autonomous Database on OCI
• Accessing the Oracle Cloud Autonomous DB for SQL – web and client version – SQL Developer.
• What is PLSQL?
• Oracle PLSQL programming approach
• Naming conventions and formatting.
• Scope of variable declaration & nested block
• Using PLSQL to interact with Oracle DB
• Cursors in PLSQL.
• Control Statement in PLSQL
• Handling Exceptions in PLSQL
• Subprograms & Composite data type
• Database triggers.
• Case study in SQL & PLSQL
• Business case & problem statement provided in document format for the learner to work upon & provided solution.
• Solutions presentation in detail to validate your solution.

Happy Learning!!

Who this course is for

• IT Analyst
• IT Developer looking for career in Oracle PLSQL
• Students in IT / Engineering / Management
• Any one who have knowledge on SQL and wish to learn PLSQL