|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practice-test-oracle-certified-associate-1z0-071/
课程评论：没有评论
课程名称：Oracle数据库SQL实践测试1Z0-071 课程概述：本课程旨在帮助学员通过Oracle官方认证考试——Oracle数据库SQL（考试编号：1Z0-071）。考试形式为选择题，时长120分钟，共78道题目，及格分数为63%。考试内容基于Oracle 11g Release 2版本11.2.0.1.0以及19c进行验证。所有试题由拥有超过19年SQL IT经验的Oracle认证专业人士准备，并经过严格审核。课程涵盖Oracle公司规定的以下大纲内容： 1. 关系数据库概念 - 理论与物理方面的关系数据库解释 - 关系SQL选择语句中的子句与ERD组件的关系 2. 数据限制与排序 - 运用表达式中的操作符优先级规则 - 限制SQL语句返回的行 - 使用替换变量及DEFINE和VERIFY命令 - 数据排序与转换函数的应用 3. 数据展示及表连接 - 使用自连接及各种类型的连接（非等值连接、外连接、笛卡尔乘积） - 应用集合运算符（如INTERSECT、MINUS、UNION及UNION ALL） 4. 索引、同义词和序列管理 - 管理索引、同义词、序列和视图 - 使用数据字典视图管理对象 5. SQL查询及数据操作 - 使用SQL SELECT语句进行数据检索，使用列别名、字符串连接操作符等 - 进行数据汇总及分组查询，运用组函数与子查询 6. DML和DDL操作 - 管理数据库事务，执行插入、更新和删除操作 - 了解如何创建、删除和管理表及其关系 - 管理约束和用户访问权限 7. 不同时间区数据管理 - 使用CURRENT_DATE、CURRENT_TIMESTAMP和LOCALTIMESTAMP，处理INTERVAL数据类型 此课程旨在让学员熟练掌握Oracle数据库SQL的核心知识，为参加认证考试做好充分准备。
Oracle official guidelines>>Exam Title: Oracle Database SQLExam Number: 1Z0-071Format: Multiple ChoiceDuration: 120 minutesNumber of Questions: 78Passing Score: 63%Validated Against: This exam is validated against 11g Release 2 version 11.2.0.1.0 and up to 19c>>Note: Questions are prepared by an Oracle Certified Professional (OCP) having 19+ years IT experience in SQL. All questions are verified/tested thoroughly. Questions covers below syllabus as prescribed by Oracle Corp.>>ORACLE UNIVERSITY COURSE (1Z0-071)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
