Muutke küpsiste eelistusi

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 2nd Revised edition [Raamat]

4.60/5 (20 hinnangut Goodreads-ist)
  • Formaat: Book, 832 pages, kõrgus x laius x paksus: 234x201x34 mm, kaal: 962 g, 125 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 18-Sep-2017
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 1259585492
  • ISBN-13: 9781259585494
Teised raamatud teemal:
  • Raamat
  • Hind: 72,19 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 2nd Revised editionSuurem pilt
  • Formaat: Book, 832 pages, kõrgus x laius x paksus: 234x201x34 mm, kaal: 962 g, 125 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 18-Sep-2017
  • Kirjastus: McGraw-Hill Education
  • ISBN-10: 1259585492
  • ISBN-13: 9781259585494
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781259585494.html
Märksõnad:

This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12c

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.

This study system covers all of the objectives for the Oracle Database 12c SQL Expert Exam in full detail and features up-to-date coverage of advanced SQL features related to Oracle Database 12c. An “exam readiness checklist” at the front of the book and “inside the exam” and “two minute drills” sections at the end of each chapter reinforce key skills. You will acquire in-depth knowledge of SQL programming and relational database concepts and will be prepared to sit for the Oracle Certified Expert exam.

  • Each chapter includes examples, practice questions, and summaries
  • CD-ROM contains two interactive practice tests and a searchable PDF version of the book
  • Sample questions throughout match the format and difficulty of the live exam
Acknowledgments xxi
Preface xxv
Introduction xxxi
Exam Readiness Checklist xxxiii
1 Oracle and Structured Query Language (SQL) 1(40)
The Exam: An Overview
2(14)
What to Do and What to Expect
4(3)
Oracle SQL vs. ANSI SQL
7(1)
Oracle SQL vs. Oracle SQLPlus
7(1)
SQL Fundamentals I vs. SQL Certified Associate
7(6)
Confirm Appropriate Materials for Study
13(3)
Identify the Connection Between an ERD and a Relational Database
16(9)
Entity-Relationship Diagrams and Data Modeling
17(3)
Relational Databases
20(2)
Many-to-Many Relationships
22(1)
Database Normalization
23(2)
Explain the Relationship Between a Database and SQL
25(3)
Describe the Purpose of DDL
28(1)
Describe the Purpose of DML
29(1)
Transaction Control Language
30(1)
Build a SELECT Statement to Retrieve Data from an Oracle Database Table
30(2)
Certification Summary
32(1)
Two-Minute Drill
33(2)
Q&A Self Test
35(3)
Self Test Answers
38(3)
2 Using DDL Statements to Create and Manage Tables 41(64)
Categorize the Main Database Objects
42(4)
What Are Database Objects?
42(2)
Schemas
44(2)
Create a Simple Table
46(8)
Naming a Table or Other Object
48(5)
The SQL Statement CREATE TABLE
53(1)
Review the Table Structure
54(2)
List the Data Types That Are Available for Columns
56(7)
Character
57(1)
Numeric
58(1)
Date
59(2)
Large Objects
61(2)
Explain How Constraints Are Created at the Time of Table Creation
63(17)
Creating CONSTRAINTS in the CREATE TABLE Statement
64(4)
The Types of CONSTRAINTS
68(12)
Drop Columns and Set Column UNUSED
80(6)
Dropping Columns
80(4)
UNUSED
84(2)
Create and Use External Tables
86(5)
Benefits
86(1)
Creating External Tables
87(4)
Certification Summary
91(3)
Two-Minute Drill
94(3)
Q&A Self Test
97(5)
Self Test Answers
102(3)
3 Manipulating Data 105(42)
Truncate Data
106(3)
Recursively Truncate Child Tables
107(2)
Insert Rows into a Table
109(8)
Default Column List
110(3)
Enumerated Column List
113(4)
Update Rows in a Table
117(4)
Expressions
118(1)
Constraints
119(1)
The WHERE Clause
120(1)
Delete Rows from a Table
121(1)
Control Transactions
122(11)
COMMIT
123(4)
ROLLBACK
127(2)
SAVEPOINT
129(3)
ROLLBACK Revisited
132(1)
Certification Summary
133(2)
Two-Minute Drill
135(3)
Q&A Self Test
138(5)
Self Test Answers
143(4)
4 Restricting and Sorting Data 147(54)
Sort the Rows That Are Retrieved by a Query
148(9)
Reference by Name
149(4)
Expressions
153(3)
Reference by Position
156(1)
Combinations
156(1)
ORDER BY and NULL
157(1)
Limit the Rows That Are Retrieved by a Query
157(16)
The WHERE Clause
158(6)
Boolean Logic
164(5)
Additional WHERE Clause Features
169(3)
Additional Concepts
172(1)
Use Ampersand Substitution to Restrict and Sort Output at Run Time
173(9)
&
174(3)
DEFINE and UNDEFINE Commands
177(1)
The SET and SHOW Commands
177(1)
ACCEPT and PROMPT
178(4)
Use the SQL Row Limiting Clause
182(4)
FETCH
183(1)
WITH TIES
184(2)
OFFSET
186(1)
Certification Summary
186(3)
Two-Minute Drill
189(3)
Q&A Self Test
192(5)
Self Test Answers
197(4)
5 Using Single-Row Functions to Customize Output 201(44)
Use Various Types of Functions That Are Available in SQL
202(3)
Character Functions
204(1)
Number Functions
204(1)
Date Functions
204(1)
Other Functions
205(1)
Use Character, Number, Date, and Analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) Functions in SELECT Statements
205(30)
The DUAL Table
206(1)
Character Functions
206(9)
Numerical Functions
215(2)
Date Functions
217(6)
Analytical Functions
223(11)
Nesting Functions
234(1)
Certification Summary
235(2)
Two-Minute Drill
237(1)
Q&A Self Test
238(3)
Self Test Answers
241(4)
6 Using Conversion Functions and Conditional Expressions 245(34)
Describe Various Types of Conversion Functions
246(3)
Explicit and Implicit Conversion
247(2)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
249(15)
Conversion Functions
250(10)
Additional Conversion Functions
260(4)
Apply General Functions and Conditional Expressions in a SELECT Statement
264(5)
CASE
265(1)
DECODE
266(1)
NVL
267(1)
NULLIF
268(1)
Certification Summary
269(2)
Two-Minute Drill
271(1)
Q&A Self Test
272(4)
Self Test Answers
276(3)
7 Reporting Aggregated Data Using the Group Functions 279(40)
Describe the Use of Group Functions
280(13)
COUNT
283(2)
SUM
285(1)
MIN, MAX
286(1)
AVG
287(1)
MEDIAN
288(1)
RANK
289(2)
DENSE_RANK
291(1)
FIRST, LAST
292(1)
Others
293(1)
Group Data by Using the GROUP BY Clause
293(10)
Multiple Columns
298(1)
ORDER BY Revisited
299(1)
Nesting Functions
300(3)
Include or Exclude Grouped Rows by Using the HAVING Clause
303(2)
Certification Summary
305(2)
Two-Minute Drill
307(2)
Q&A Self Test
309(6)
Self Test Answers
315(4)
8 Displaying Data from Multiple Tables 319(32)
Describe the Different Types of Joins and Their Features
320(1)
Types of Joins
320(1)
Use SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-Equijoins
321(12)
Inner Joins
322(3)
Using Table Aliases
325(2)
Natural Joins
327(2)
USING
329(1)
Multitable Joins
330(1)
Non-Equijoins
331(2)
Join a Table to Itself by Using a Self-Join
333(2)
Self-Referencing Foreign Keys
334(1)
Self-Join Syntax
334(1)
View Data That Generally Does Not Meet a Join Condition by Using Outer Joins
335(4)
LEFT OUTER JOIN
336(1)
RIGHT OUTER JOIN
336(1)
FULL OUTER JOIN
337(1)
For the Record: Oracle Outer Join Syntax: (+)
338(1)
Certification Summary
339(1)
Two-Minute Drill
340(2)
Q&A Self Test
342(6)
Self Test Answers
348(3)
9 Using Subqueries to Solve Queries 351(38)
Define Subqueries
352(2)
Describe the Types of Problems Subqueries Can Solve
354(2)
Describe the Types of Subqueries
356(1)
Query Data Using Correlated Subqueries
357(2)
Update and Delete Rows Using Correlated Subqueries
359(4)
UPDATE with a Correlated Subquery
360(2)
DELETE with a Correlated Subquery
362(1)
Use the EXISTS and NOT EXISTS Operators
363(1)
Use the WITH Clause
364(1)
Write Single-Row and Multiple-Row Subqueries
365(8)
Single-Row Subqueries
365(4)
Multiple-Row Subqueries
369(4)
Certification Summary
373(1)
Two-Minute Drill
374(3)
Q&A Self Test
377(8)
Self Test Answers
385(4)
10 Managing Schema Objects 389(60)
Describe How Schema Objects Work
390(2)
Tables
390(1)
Constraints
390(1)
Views
391(1)
Indexes
391(1)
Sequences
392(1)
Create Simple and Complex Views with Visible/Invisible Columns
392(15)
Creating Views
393(4)
Updatable Views
397(3)
Inline Views
400(2)
ALTER VIEW
402(1)
Visible/Invisible Columns
403(4)
Create, Maintain, and Use Sequences
407(5)
Creating and Dropping Sequences
408(1)
Using Sequences
409(3)
Create and Maintain Indexes Including Invisible Indexes and Multiple Indexes on the Same Columns
412(12)
The Oracle Database Optimizer
414(1)
Implicit Index Creation
414(2)
Single Column
416(2)
Composite
418(2)
Unique
420(1)
Dropping
420(1)
Visible and Invisible Indexes
421(2)
Index Alternatives on the Same Column Set
423(1)
Perform Flashback Operations
424(11)
Overview
424(1)
Recover Dropped Tables
425(4)
Recovering Data Within Existing Tables over Time
429(2)
Marking Time
431(4)
Certification Summary
435(2)
Two-Minute Drill
437(3)
Q&A Self Test
440(6)
Self Test Answers
446(3)
11 Using the Set Operators 449(24)
Describe Set Operators
450(2)
Use a Set Operator to Combine Multiple Queries into a Single Query
452(7)
UNION
452(4)
UNION ALL
456(1)
INTERSECT
456(1)
MINUS
457(1)
Combinations
458(1)
Control the Order of Rows Returned
459(3)
ORDER BY-By Position
459(2)
ORDER BY-By Reference
461(1)
Certification Summary
462(1)
Two-Minute Drill
463(1)
Q&A Self Test
464(6)
Self Test Answers
470(3)
12 Managing Objects with Data Dictionary Views 473(24)
Query Various Data Dictionary Views
474(15)
Structure
475(2)
Dynamic Performance Views
477(2)
Reading Comments
479(1)
Adding Comments
480(1)
DICTIONARY
481(1)
Identifying a User's Owned Objects
482(2)
Inspecting Tables and Columns
484(1)
Compiling Views
485(1)
Checking Privileges
486(1)
Inspecting Constraints
487(1)
Finding Columns
488(1)
Certification Summary
489(1)
Two-Minute Drill
490(2)
Q&A Self Test
492(3)
Self Test Answers
495(2)
13 Manipulating Large Data Sets 497(32)
Describe the Features of Multitable INSERTS
498(16)
Use the Following Types of Multitable INSERTS: Unconditional and Conditional
502(12)
Merge Rows into a Table
514(4)
Certification Summary
518(1)
Two-Minute Drill
519(2)
Q&A Self Test
521(5)
Self Test Answers
526(3)
14 Controlling User Access 529(36)
Differentiate System Privileges from Object Privileges
530(12)
System Privileges
531(2)
Prerequisites
533(2)
GRANT and REVOKE
535(3)
ANY
538(1)
ADMIN OPTION
539(1)
ALL PRIVILEGES
540(1)
PUBLIC
541(1)
Grant Privileges on Tables and on a User
542(10)
Schema Prefixes
544(1)
WITH GRANT OPTION
545(1)
REVOKE
546(1)
ALL PRIVILEGES
546(1)
Dependent Privileges
547(1)
View Privileges in the Data Dictionary
547(2)
Grant Roles
549(3)
Distinguish Between Privileges and Roles
552(2)
Certification Summary
554(1)
Two-Minute Drill
555(2)
Q&A Self Test
557(5)
Self Test Answers
562(3)
A About the CD-ROM 565(4)
System Requirements
566(1)
Installing and Running Total Tester Premium Practice Exam Software
566(1)
Total Tester Premium Practice Exam Software
566(1)
Secured Book PDF
567(1)
Technical Support
567(2)
Glossary 569(18)
Index 587
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide