Curso de Oracle Database SQL (1Z0-071)

MODULO I 

• Introducción to SQL Plus
• Oracle And Structured Query Language (SQL)
• Identify The Connection Between ERD And A Relational Database
• Práctica Módulo

MODULO II

• Explain The Relationship Between A Database And SQL
• Describe The Purpose Of DDL
• Describe The Purpose Of DML
• Práctica Módulo

MODULO III

• Build A Select Statement To Retrieve Data From An Oracle Database Table
• Restricting And Sorting Data
• Use The Order By Clause To Sort Sql Query Results
• Limit The Rows That Are Retrieved By A Query
• Use Ampersand Substitution To Restrict And Sort Output At Runtime
• Práctica Módulo

MODULO IV

• Use SQL Row Limiting Clause
• Using Single-Row Functions To Customize Output
• Use Various Types Of Functions Available In SQL
• Use Character, Number, Date And Analytical Functions In Select Statements
• Using Conversion Functions And Conditional Expressions
• Types Of Conversion Functions That Are Available In SQL
• Use The To_Char, To_Number, And To_Date Conversion Functions
• Práctica Módulo

MODULO V

• Apply General Functions And Conditional Expressions In A Select Statement
• Reporting Aggregated Data Using The Group Functions
• Use Of Group Functions
• Group Data By Using The Group By Clause
• Include Or Exclude Grouped Rows By Using The Having Clause
• Displaying Data From Multiple Tables
• Different Types Of Joins And Their Features In Oracle
• Práctica Módulo

MODULO VI

• Join A Table To Itself By Using A Self-Join
• View Data That Generally Does Not Meet A Join Condition By Using Outer Joins
• Práctica Módulo

MODULO VII

• Using Subqueries To Solve Queries
• Define Subqueries
• Describe The Types Of Problems Subqueries Can Solve
• Describe The Types Of Subqueries
• Query Data Using Correlated Subqueries
• Update And Delete Rows Using Correlated Subqueries
• Use Single-Row And Multiple-Row Subqueries
• Práctica Módulo

MODULO VIII

• Using The Set Operators
• Describe Set Operators
• Managing Schema Objects
• Describe How Schema Objects Work
• Create Simple And Complex Views With Visible/Invisible Columns
• Práctica Módulo

MODULO IX

• Use The Exists And Not Exists Operators
• Use The With Clause
• Create, Maintain And Use Sequences
• Create And Maintain Indexes Including Invisible Indexes And Multiple Indexes On The Same Columns
• Perform Flashback Operations
• Manipulating Large Data Sets
• Describe The Features Of Multitable Inserts
• Merge Rows In A Table
• Práctica Módulo

MODULO X

• Batería De Preguntas Demo Examen (1Z0-071)

Los alumnos deberán acreditar el certificado ORACLE DATABASE SQL CERTIFIED ASSOCIATE o aprobar el cuestionario de acceso.