|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/1z0-071-learn-oracle-sql-database-using-developer/
课程评论：没有评论
Coursera 1Z0-071 Oracle SQL 认证入门课程：数据库 本课程是 Oracle Database SQL 1Z0-071 认证的基础。课程全面讲解 SELECT 语句，并涵盖用户访问控制等附加要求。课程分为 6 个部分，每部分大约需要半天时间完成。 **课程亮点：** * **适合零基础学员：** 课程设计循序渐进，即使是 Oracle 新手也能轻松理解。 * **深度讲解：** 讲师深入浅出地解释概念，并提供非常有帮助的练习。 * **考试导向：** 课程内容紧贴 1Z0-071 考试要求，帮助学员顺利通过认证。 * **免费工具安装：** 课程包含免费安装 Oracle Express Edition 和 Oracle SQL Developer 的指导。 **课程内容概要：** * **第一部分：** 安装 Oracle 数据库和 SQL Developer，讲解 SELECT 语句的六个核心子句（SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY），并介绍数据类型、字符串、日期和数字函数。 * **第二部分：** 深入学习 SELECT 语句，掌握表之间的 JOIN 操作，巩固对 SELECT 语句六个核心子句的理解。 * **第三部分：** 学习查找、删除和更新数据，理解事务（隐式与显式），以及各种约束（主键、外键等）。 * **第四部分：** 创建视图（Views），使用 UNION、INTERSECT、MERGE 等集合运算符合并表，并学习使用 OVER 子句的分析函数。 * **第五部分：** 在 SELECT 查询中添加汇总信息，学习子查询（在 FROM, SELECT, WHERE, WITH 子句中使用），以及用于处理层级数据的 Oracle SQL 自连接。 * **第六部分：** 学习 TIME ZONE 和 INTERVAL 等数据类型和函数，了解 SEQUENCE 和 INDEX 的概念及其在数据字典中的体现，最后学习创建用户、分配权限和角色，完成考试的最后要求。 **学完您将能够：** * 熟练处理数字、字符串和日期。 * 创建数据库和表，插入数据。 * 进行数据分析。 * 全面掌握 Oracle SQL 的核心概念和应用。 **学员评价：** * “课程设计得很好，即使没有 Oracle 知识的人也能理解。学习效果很好，非常感谢！” - Prashant * “很棒的课程！讲师讲解得非常透彻，而且很容易理解。练习也非常有帮助。如果你想精通 Oracle SQL，这门课就是为你准备的。” - Shubho * “非常感谢 Phillip 的这门精彩课程！这门课加上其他学习材料，帮助我上周六通过了 1Z0-071 考试。” - Henry
This course is the foundation for the Oracle Database SQL 1Z0-071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle.What do people like you say about this course?Prashant says: "Course has been designed in way that a person with no knowledge of Oracle can understand it. Good learning and thanks a lot for making such nice course."Shubho says: "Awesome course. The instructor explains the concepts very thorougly and in a easy-to-grasp way. Also, the practice exercises are super helpful. If you want to master Oracle SQL, this is the course for you."Henry says: "I want to thank Phillip for this formidable course. This course along with other materials helped me to pass the 1Z0-071 Exam last Saturday."Session 1We'll install for free Oracle Express Edition and Oracle SQL Developer. Then we'll take a look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.Then we'll start creating tables, but find that we can't get very far without understanding data types. We'll then look at string, date and number types and functions, together with looking at functions converting between them.Session 2We'll revisit the SELECT statement and go into more detail. We'll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.Session 3In session 3, we'll looking for missing data, and find out how to delete and update data. We'll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.Session 4We'll start off by saving our queries in views. Then we'll combine tables, not by adding additional columns using JOINS, but adding additional rows such Oracle SQL set operators such as UNION, INTERSECT and MERGE. Then we'll look at analytical functions using the OVER clause.Session 5Session 5 starts off by adding totals to our SELECT queries. We'll then look at subqueries, and how you can add them into the FROM, SELECT and WHERE clauses, and also into the WITH clause. Finally, we'll look at Oracle SQL self-joins, which are useful when you have hierarchies.Session 6Session 6 starts off with two additional data types, TIME ZONE and INTERVAL data types and functions. We'll then have a look at SEQUENCEs and INDEXes, together with how these are shown in the Data Dictionary. We'll then create new users, and assign privileges and roles to them, and we'll finish with the last few requirements for the exam.No prior knowledge is required - we'll even install Oracle Database and Oracle SQL Developer on your computer for free!Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in Oracle SQL.
