OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

✍ Scribed by O'Hearn, Steve

• Publisher: McGraw-Hill Education;Oracle Press
• Year: 2017
• Tongue: English
• Series: Oracle
• Category: Library

✦ Table of Contents

Chapter 1: Oracle and Structured Query Language (SQL)Chapter 2: Using DDL Statements to Create and Manage TablesChapter 3: Manipulating DataChapter 4: Restricting and Sorting DataChapter 5: Using Single-Row Functions to Customize OutputChapter 6: Using Conversion Functions and Conditional ExpressionsChapter 7: Reporting Aggregated Data Using the Group FunctionsChapter 8: Displaying Data from Multiple TablesChapter 9: Using Subqueries to Solve QueriesChapter 10: Managing Schema ObjectsChapter 11: Using the Set OperatorsChapter 12: Managing Objects with Data Dictionary ViewsChapter 13: Manipulating Large Data SetsChapter 14: Controlling User AccessAppendix A: About the CDGlossary

✦ Subjects

Database management--Examinations;Electronic data processing personnel--Certification;Examinations;ORACLE;SQL (Computer program language)--Examinations;Study guides;Oracle (Computer file) -- Examinations -- Study guides;Oracle (Computer file);Database management -- Examinations -- Study guides;SQL (Computer program language) -- Examinations -- Study guides;Electronic data processing personnel -- Certification;Database management -- Examinations