OCA Oracle database : SQL exam guide (exam 1Z0-071)
Steve O'Hearn
- New York : McGraw-Hill Education, c2017.
- xxxv, 609 p. : ill. ; 23 cm + 1 x CD.
Includes index.
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
This comprehensive study guide from Oracle Press enables readers to prepare for the SQL Database Expert Exam with total confidence. Ideal both as a study guide and on-the-job reference, Oracle Database 12c SQL Certified Expert Exam Guide features examples, practice questions, and chapter summaries. Between the book and accompanying CD-ROM, you will have access to more than 150 questions that match the topics, format, and complexity of the real test.
9781259585494
2017031338
Database management--Examinations--Study guides SQL (Computer program language)--Examinations--Study guides Electronic data processing personnel--Certification