|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-plsql-fundamentals-with-case-study-oci/
课程评论：没有评论
课程名称：Oracle PL/SQL 基础与案例研究（OCI） 课程概述： 本课程探讨了SQL与PL/SQL在现代数据访问中的重要性，强调学习这些技能的必要性。 SQL与PL/SQL已经成为多个行业的标准数据访问语言，不再仅仅是开发者的工具，而是各类技术领域的专业人士都需要掌握的技能。学生将学习如何使用SQL和PL/SQL来存储、操作和访问大数据量，从中提取有意义的商业信息，以帮助企业保持竞争力。 PL/SQL有许多优势，包括能够同时向数据库发送整个语句块，减少网络流量并提升应用性能。此外，PL/SQL也提高了程序员的生产力，能够对数据库中的数据进行查询、转换和更新。通过本课程，学员将深入了解如何在Oracle云基础设施上提供最新的Oracle Cloud Autonomous Database 19c，利用这个平台学习SQL（尽管本课程不详细覆盖）和PL/SQL的相关知识。 课程内容包括： - 学习和实践不同Oracle数据库环境 - 如何访问Oracle云免费的服务 - 概述新的Oracle自主云数据库 - 在OCI上提供Oracle自主数据库 - 通过网络和客户端版本访问Oracle Cloud自主数据库 - PL/SQL的定义与编程方式 - 命名规范和格式 - 变量声明范围与嵌套块 - 使用PL/SQL与Oracle数据库的交互 - PL/SQL中的游标 - PL/SQL中的控制语句 - PL/SQL中的异常处理 - 子程序与复合数据类型 - 数据库触发器 - SQL与PL/SQL的案例研究，包含商业案例和问题陈述供学员工作，以及提供解决方案的详细展示。 欢迎学习！
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 OCIAccessing 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 DBCursors in PLSQL.Control Statement in PLSQLHandling Exceptions in PLSQLSubprograms & Composite data typeDatabase 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!!
