|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-sql-certified-associate-exam-1z0-071/
课程评论：没有评论
**课程名称：Oracle Database SQL 认证助理考试 (1Z0-071) - 2025** **课程概述：** 本课程是针对所有希望测试其 Oracle 数据库 SQL 知识的学习者而设计的。Oracle Database SQL 1Z0-071 考试旨在评估学习者在理解和运用基础 SQL 概念方面的理论知识和实践技能，这些技能是进行任何数据库项目所必需的。 **考试涵盖的主题：** * **关系数据库概念：** 解释关系数据库的理论和物理方面，将 SQL SELECT 语句中的子句与 ERD 组件联系起来，并解释数据库与 SQL 之间的关系。 * **使用 SQL SELECT 语句检索数据：** 包括使用列别名、连接运算符、文字字符字符串、替代引号运算符、DISTINCT 关键字、算术表达式和 NULL 值。 * **限制和排序数据：** 应用运算符优先级规则，限制返回的行数，使用替换变量，以及使用 DEFINE 和 VERIFY 命令进行排序。 * **使用单行函数自定义输出：** 使用字符函数操作字符串，使用日期函数处理日期数据，使用 ROUND, TRUNC, MOD 函数处理数字，以及使用转换函数和条件表达式（包括 NVL, NULLIF, COALESCE）和数据类型转换。 * **使用组函数报告聚合数据：** 创建数据组，显示数据，限制组结果，并使用组函数。 * **显示来自多个表的数据：** 使用自连接、各种类型的连接（包括非等值连接和外连接），以及理解和使用笛卡尔积。 * **使用子查询解决查询：** 包括单行子查询、多行子查询，以及使用相关子查询更新和删除行。 * **使用集合运算符：** 匹配 SELECT 语句，在集合操作中使用 ORDER BY 子句，并使用 INTERSECT, MINUS, UNION 和 UNION ALL 运算符。 * **使用 DML 语句管理表：** 管理数据库事务，进行插入、更新和删除操作，执行多表插入和 MERGE 语句。 * **管理索引、同义词和序列：** 管理索引、同义词和序列。 * **使用 DDL 管理表及其关系：** 描述和使用表、列和数据类型，创建表，删除列并设置列 UNUSED，截断表，创建和使用临时表和外部表，管理约束，管理视图，以及控制用户访问（区分系统权限和对象权限，授予表权限，区分授予权限和角色）。 * **使用数据字典视图管理对象：** 使用数据字典视图管理对象。 * **处理不同时区的数据：** 处理 CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP 以及 INTERVAL 数据类型。
Welcome to the definitive test for Oracle Database SQL - 1Z0-071, for everybody that wants to test their knowledge on Oracle database SQL.The Oracle Database SQL - 1Z0-071 test exam is designed to assesses people theoretical understanding of and the practical skills to demonstrate understanding of fundamental SQL concepts needed to undertake any database project.Topics Covered in the Exam Test:Relational Database conceptsExplaining the theoretical and physical aspects of a relational databaseRelating clauses in SQL Select Statement to Components of an ERDExplaining the relationship between a database and SQLRetrieving Data using the SQL SELECT StatementUsing Column aliasesUsing The SQL SELECT statementUsing concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keywordUsing Arithmetic expressions and NULL values in the SELECT statementRestricting and Sorting DataApplying Rules of precedence for operators in an expressionLimiting Rows Returned in a SQL StatementUsing Substitution VariablesUsing the DEFINE and VERIFY commandsSorting DataUsing Single-Row Functions to Customize OutputManipulating strings with character functions in SQL SELECT and WHERE clausesPerforming arithmetic with date dataManipulating numbers with the ROUND, TRUNC and MOD functionsManipulating dates with the date functionUsing Conversion Functions and Conditional ExpressionsApplying the NVL, NULLIF, and COALESCE functions to dataUnderstanding implicit and explicit data type conversionUsing the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNesting multiple functionsReporting Aggregated Data Using Group FunctionsRestricting Group ResultsCreating Groups of DataUsing Group FunctionsDisplaying Data from Multiple TablesUsing Self-joinsUsing Various Types of JoinsUsing Non equijoinsUsing OUTER joinsUnderstanding and Using Cartesian ProductsUsing Subqueries to Solve QueriesUsing Single Row SubqueriesUsing Multiple Row SubqueriesUpdate and delete rows using correlated subqueriesUsing SET OperatorsMatching the SELECT statementsUsing the ORDER BY clause in set operationsUsing The INTERSECT operatorUsing The MINUS operatorUsing The UNION and UNION ALL operatorsManaging Tables using DML statementsManaging Database TransactionsControlling transactionsPerform Insert, Update and Delete operationsPerforming multi table InsertsPerforming Merge statementsManaging Indexes Synonyms and SequencesManaging IndexesManaging SynonymsManaging SequencesUse DDL to manage tables and their relationshipsDescribing and Working with TablesDescribing and Working with Columns and Data TypesCreating tablesDropping columns and setting column UNUSEDTruncating tablesCreating and using Temporary TablesCreating and using external tablesManaging ConstraintsManaging ViewsManaging ViewsControlling User AccessDifferentiating system privileges from object privilegesGranting privileges on tablesDistinguishing between granting privileges and rolesManaging Objects with Data Dictionary ViewsUsing data dictionary viewsManaging Data in Different Time ZonesWorking with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMPWorking with INTERVAL data types
