|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-sql-and-plsql-courses-by-practical-examples-atp/
课程评论：没有评论
课程名称：Oracle SQL和PL/SQL云数据库实践案例 课程概述：本课程旨在帮助学生通过实践项目快速上手编码，无需具备深厚的理论基础。从一开始就深入实际问题，确保学员能自信而迅速地为真实项目提供解决方案。课程强调动手实践，每个主题都配有详细的视频讲解和需要学生自主完成的任务。 课程内容包括： - 在Oracle云中创建自主管理的事务处理数据库并配置连接。 - 学习如何创建ER图和不同类型的数据库对象、数据类型等。 - 掌握数据操作语言（DML）操作：选择（SELECT）、插入（INSERT）、更新（UPDATE）和删除（DELETE）等。 - 学习数据定义语言（DDL）操作：创建表（CREATE TABLE）、索引（INDEX）、序列（SEQUENCE）、触发器（TRIGGER）。 - 创建附加架构和加载数据。 - 学习内置函数、连接（JOIN）操作、子查询等内容。 掌握基础知识后，课程将引导学员学习PL/SQL主题，包括： - 使用循环（for和while）和条件语句（if-else）为程序增加复杂性和功能性。 - 处理复合数据类型、显式游标和异常管理。 - 创建存储过程和函数。 课程提供工作文件和代码示例，学员将与讲师并肩完成各个概念的学习。最后，我们将开发几个现实项目的解决方案。完成课程后，学员将获得数据库管理员（DBA）和Oracle PL/SQL开发者职位所需的知识和技能，准备迎接各种挑战！
You don't have to be a know-it-all to dive into coding for real-life projects. This course throws you right into the action, tackling problems from the very start. Before you know it, you'll be crafting solutions for real-world projects with confidence and speed.No boring theory! The course is designed with an emphasis on hands-on experience. Every topic has a detailed explanation video and tasks you have to perform by yourself. At first, we will learn some general SQL and Database topics: Create an Autonomous Transaction Processing Database in the Oracle Cloud and configure a connection. Learn how to create ERD diagrams.Learn about different types of Database Objects, Data Types, etc. Learn how to perform DML operations: SELECT/INSERT/UPDATE/DELETELearn DDL operations: CREATE TABLE/INDEX/SEQUENCE/TRIGGERCreate additional schemas and load data.Learn Built-in Functions, JOIN operations, Subqueries, etc. With these basics mastered, the course will take you through program flow control by teaching you PL/SQL topics:How to use for loops, while loops, and conditional if-else statements to add complexity and functionality to your programs.Working with Composite Data Types.Working with explicit cursors.Handling Exceptions.Creating Procedures and Functions. Complete with working files and code samples, you'll be able to work alongside the author as you work through each concept.Finally, we will develop several solutions for real-world projects. With this experience under your belt, you'll be infused with the confidence to seize any opportunity that comes your way, no matter how challenging it may seem.Students completing the course will have the knowledge and skills required for a DBA and Oracle PL/SQL developer positions. Get ready to thrive!
