|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-certified-associate-1z0-071-exam-simulation/
课程评论：没有评论
课程名称：Oracle DB SQL认证助理（1Z0-071）考试模拟 课程概述： 本课程为一次以选择题形式进行的模拟考试，时长120分钟，考试费用为245美元，共有78道题目，及格分数为63%。该考试已针对11g Release 2版本11.2.0.1.0及更高版本到19c进行了验证。建议培训课程为Khaled Alkhudari创建的《Oracle数据库12c SQL认证助理1Z0-071》。已有2名学生通过该模拟考成功获得1Z0-071认证。 考试话题涵盖： - 关系数据库概念：理论与物理方面的介绍，SQL选择语句中的条款与ERD组件的关系，数据库与SQL的关系。 - 使用SQL SELECT语句检索数据：列别名的使用，字符连接操作符及DISTINCT关键字的使用，算术表达式及NULL值的处理等。 - 限制和排序数据：运算符优先级规则，限制SQL语句返回的行，使用替代变量与排序数据。 - 使用单行函数自定义输出：字符串操作、日期与数字的算术操作等。 - 使用转换函数与条件表达式：NVL、NULLIF、COALESCE函数，数据类型转换等。 - 使用组函数汇总数据：限制汇总结果，创建数据组等。 - 从多个表中显示数据：自连接和各种类型的连接。 - 使用子查询解决查询：单行与多行子查询，更新和删除相关子查询的行。 - 使用SET运算符：匹配SELECT语句，使用ORDER BY子句等。 - 使用DML语句管理表：数据库事务管理，插入、更新和删除操作。 - 管理索引、同义词和序列。 - 使用DDL管理表及其关系。 - 管理视图、用户访问控制及数据字典视图管理。 此课程为准备1Z0-071考试的理想选择，帮助考生全面了解Oracle数据库的SQL相关知识和技能。
Format: Multiple ChoiceDuration: 120 minutesExam Price: $245Number of Questions:78Passing Score: 63%Validation: This exam was validated against 11g Release 2 version 11.2.0.1.0 and up to 19cSuggested Training Course: "Oracle Database 12c SQL Certified Associate 1Z0-071" created by Khaled Alkhudari.The practice test questions have already helped 2 students to pass the 1Z0-071 exam.************************ WALL OF FAME for 1Z0-071 ************************2023:1. Paweł Pigłowski [8-March-2023]2021:1. Bhuwneshwar Kumar [10-July-2021]Exam topics:Relational Database concepts• Explaining the theoretical and physical aspects of a relational database• Relating clauses in SQL Select Statement to Components of an ERD• Explaining the relationship between a database and SQLRetrieving Data using the SQL SELECT Statement• Using Column aliases• Using The SQL SELECT statement• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword• Using Arithmetic expressions and NULL values in the SELECT statementRestricting and Sorting Data• Applying Rules of precedence for operators in an expression• Limiting Rows Returned in a SQL Statement• Using Substitution Variables• Using the DEFINE and VERIFY commands• Sorting DataUsing Single-Row Functions to Customize Output• Manipulating strings with character functions in SQL SELECT and WHERE clauses• Performing arithmetic with date data• Manipulating numbers with the ROUND, TRUNC and MOD functions• Manipulating dates with the date functionUsing Conversion Functions and Conditional Expressions• Applying the NVL, NULLIF, and COALESCE functions to data• Understanding implicit and explicit data type conversion• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions• Nesting multiple functionsReporting Aggregated Data Using Group Functions• Restricting Group Results• Creating Groups of Data• Using Group FunctionsDisplaying Data from Multiple Tables• Using Self-joins• Using Various Types of Joins• Using Non equijoins• Using OUTER joins• Understanding and Using Cartesian ProductsUsing Subqueries to Solve Queries• Using Single Row Subqueries• Using Multiple Row Subqueries• Update and delete rows using correlated subqueriesUsing SET Operators• Matching the SELECT statements• Using the ORDER BY clause in set operations• Using The INTERSECT operator• Using The MINUS operator• Using The UNION and UNION ALL operatorsManaging Tables using DML statements• Managing Database Transactions• Controlling transactions• Perform Insert, Update and Delete operations• Performing multi table Inserts• Performing Merge statementsManaging Indexes Synonyms and Sequences• Managing Indexes• Managing Synonyms• Managing SequencesUse DDL to manage tables and their relationships• Describing and Working with Tables• Describing and Working with Columns and Data Types• Creating tables• Dropping columns and setting column UNUSED• Truncating tables• Creating and using Temporary Tables• Creating and using external tables• Managing ConstraintsManaging Views• Managing ViewsControlling User Access• Differentiating system privileges from object privileges• Granting privileges on tables• Distinguishing between granting privileges and rolesManaging Objects with Data Dictionary Views• Using data dictionary views
