OCA Oracle database : SQL exam guide (exam 1Z0-071)
By: O'Hearn, Steve
Material type: BookPublisher: New York : McGraw-Hill Education, c2017.Description: xxxv, 609 p. : ill. ; 23 cm + 1 x CD.ISBN: 9781259585494Subject(s): Database management -- Examinations -- Study guides | SQL (Computer program language) -- Examinations -- Study guides | Electronic data processing personnel -- CertificationDDC classification: 005.7565 OH OC Online resources: Location MapItem type | Home library | Call number | Status | Notes | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|
REGULAR | University of Wollongong in Dubai Main Collection | 005.7565 OH OC (Browse shelf) | Available | Nov2018 | T0061164 |
, Shelving location: Main Collection Close shelf browser
005.7565 JE MI Microsoft Access 2010 in depth / | 005.7565 LO OR Oracle Database 11g : | 005.7565 MC OR Oracle database 11g PL/SQL programming / | 005.7565 OH OC OCA Oracle database : | 005.7565 OL FI FileMaker Web publishing : | 005.7565 SU DE Developing databases with Access / | 005.7565 TR FI FileMaker Pro design & scripting for dummies / |
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.