OCA Oracle Database SQL exam guide : (Exam 1Z0-071)
(2017)
By:
O'Hearn, Steve
Nonfiction
Book
Call Numbers:
TEST/005.7565/ORACLE/OHEARN,S
Availability
Details
PUBLISHED
New York : McGraw-Hill Education, [2017]
©2017
©2017
DESCRIPTION
xxxv, 609 pages : illustrations ; 24 cm + 1 CD-ROM
ISBN/ISSN
9781259585494, 1259585492, 9781259585500, 1259585506, 9781259585487, 1259585484
LANGUAGE
English
NOTES
Accompanying CD-ROM includes 140 practice exam questions and a secured PDF copy of the book
Oracle and structured query language (SQL) -- Using DDL statements to create and manage tables -- Manipulating data -- Restricting and sorting data -- Using single-row functions to customize output -- Using conversion functions and conditional expressions -- Reporting aggregated data using the group functions -- Displaying data from multiple tables -- Using subqueries to solve queries -- Managing schema objects -- Using the set operators -- Managing objects with data dictionary views -- Manipulating large data sets -- Controlling user access -- About the CD-ROM