|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-certified-associate-practice-exam-1z0-071/
课程评论：没有评论
课程名称：Oracle认证助理实践考试 1z0-071 2025 课程概述： 本课程为Oracle数据库12c SQL认证考试1Z0-071的实践准备，考试形式为选择题，时长为120分钟，及格分数为65%。课程涵盖了关系数据库的理论和物理概念，并详细讲解了SQL查询语句的组成及其与实体关系图(ERD)的关系。 课程内容包括： 1. **数据库与SQL的关系**：学习如何限制和排序数据，应用运算符的优先级规则，使用替换变量，以及使用DEFINE和VERIFY命令。 2. **数据的排序与转换**：掌握使用转换函数和条件表达式，包括NVL、NULLIF和COALESCE函数，理解隐式与显式数据类型转换，以及TO_CHAR、TO_NUMBER和TO_DATE函数的使用。 3. **多表数据显示**：学习自连接、各种类型的连接（包括外连接和非等值连接）、笛卡尔积的使用及SET操作符的匹配。 4. **索引、同义词和序列管理**：理解索引、同义词和序列的管理及其在数据库中的应用。 5. **DML语句的管理**：控制数据库事务，执行插入、更新、删除操作，以及多表插入和合并语句的使用。 6. **表与约束管理**：学习创建和使用表、列和数据类型，以及如何管理约束和用户访问控制。 7. **时区数据管理**：处理当前日期和时间戳，并使用INTERVAL数据类型。 该课程旨在帮助学员深入理解Oracle数据库的SQL操作，为参加认证考试做好充分准备。通过掌握各种核心概念与技能，学员将能够自信地应对考试挑战。
Exam Title: Oracle Database 12c SQLExam Number: 1Z0-071Format: Multiple ChoiceDuration: 120 minutesPassing Score: 65%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 SQLRestricting and Sorting DataApplying Rules of precedence for operators in an expressionLimiting Rows Returned in a SQL StatementUsing Substitution VariablesUsing the DEFINE and VERIFY commands.Sorting DataUsing Conversion Functions and Conditional ExpressionsApplying the NVL, NULLIF, and COALESCE functions to data.Understanding implicit and explicit data type conversionUsing the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNesting multiple functionsDisplaying Data from Multiple TablesUsing Self-joinsUsing Various Types of JoinsUsing Non equijoinsUsing OUTER joinsUnderstanding and Using Cartesian ProductsUsing SET OperatorsMatching the SELECT statements.Using the ORDER BY clause in set operationsUsing The INTERSECT operator.Using The MINUS operatorUsing The UNION and UNION ALL operatorsManaging Indexes Synonyms and SequencesManaging IndexesManaging SynonymsManaging SequencesManaging ViewsManaging ViewsManaging Objects with Data Dictionary ViewsUsing data dictionary viewsRetrieving Data using the SQL SELECT StatementUsing Column aliasesUsing The SQL SELECT statement.Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keywordUsing Arithmetic expressions and NULL values in the SELECT statement.Using Single-Row Functions to Customize OutputManipulating strings with character functions in SQL SELECT and WHERE clauses.Performing arithmetic with date dataManipulating numbers with the ROUND, TRUNC and MOD functionsManipulating dates with the date functionReporting Aggregated Data Using Group FunctionsRestricting Group ResultsCreating Groups of DataUsing Group FunctionsUsing Subqueries to Solve QueriesUsing Single Row SubqueriesUsing Multiple Row SubqueriesUpdate and delete rows using correlated subqueries.Managing Tables using DML statementsManaging Database TransactionsControlling transactionsPerform Insert, Update and Delete operationsPerforming multi table InsertsPerforming Merge statementsUse DDL to manage tables and their relationships.Describing 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 ConstraintsControlling User AccessDifferentiating system privileges from object privilegesGranting privileges on tablesDistinguishing between granting privileges and rolesManaging Data in Different Time ZonesWorking with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMPWorking with INTERVAL data types
