|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/1z0-171-oracle-database-23ai-sql-associate/
课程评论：没有评论
Coursera 课程《1Z0-171：Oracle Database 23ai SQL Associate》是一个为备考 Oracle Database SQL 1Z0-171 认证打下基础的课程。本课程将详细讲解 SELECT 语句，并涵盖用户访问控制的附加要求。 课程内容包括： * **安装和准备：** 免费安装 Oracle Express Edition 和 Oracle SQL Developer。 * **SELECT 语句核心：** 深入学习 SELECT 语句的六个主要子句：SELECT, FROM, WHERE, GROUP BY, HAVING 和 ORDER BY。 * **数据类型和函数：** 掌握字符串、日期和数字数据类型及其函数，以及它们之间的转换。 * **表操作：** 创建表，并学习如何使用 JOIN 连接多个表。 * **数据管理：** 查找缺失数据，学习删除和更新数据，理解隐式和显式事务的区别，以及主键和外键等约束。 * **高级查询技巧：** 使用视图保存查询，运用 UNION、INTERSECT 和 MERGE 等集合运算符合并表，添加聚合函数，并学习如何在 SELECT、FROM、WHERE 和 WITH 子句中使用子查询。还将介绍用于处理层次结构的 Oracle SQL 自连接。 * **其他重要概念：** 学习 TIME ZONE 和 INTERVAL 数据类型及其函数，理解 SEQUENCE 和 INDEX 的作用，并通过数据字典查看它们。 * **用户和权限管理：** 创建新用户，分配权限和角色，并满足考试的其他要求。 本课程无需任何先验知识，将从零开始指导学员安装必要的软件。完成课程后，学员将能够熟练地操作数字、字符串和日期，创建数据库和表，插入数据，进行数据分析，并对 Oracle SQL 的应用有深刻的理解。 **请注意：** 本课程与 Oracle 公司无任何隶属、认可或赞助关系。
This course is the foundation for the Oracle Database SQL 1Z0-171 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access.Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle.We'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.We'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.We'll then 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.We'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.We'll add 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. We'll also look at Oracle SQL self-joins, which are useful when you have hierarchies.Finally, 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.
