Muutke küpsiste eelistusi

OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) 2nd edition [Raamat]

3.95/5 (28 hinnangut Goodreads-ist)
  • Formaat: Book, 592 pages, kõrgus x laius x paksus: 231x185x31 mm, kaal: 955 g, 200 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jul-2014
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071820280
  • ISBN-13: 9780071820288
Teised raamatud teemal:
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) 2nd editionSuurem pilt
  • Formaat: Book, 592 pages, kõrgus x laius x paksus: 231x185x31 mm, kaal: 955 g, 200 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Jul-2014
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071820280
  • ISBN-13: 9780071820288
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071820288.html
Märksõnad:
"Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the test and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including: - Data retrieval using the SQL SELECT statement - Restricting and sorting data - Single-row functions - Using conversion functions and conditional expressions - Reporting aggregated data with the group functions - Displaying data from multiple tables with joins - Using subqueries to solve problems - Using the set operators - Manipulating data with DML statements - Using DDL statements to create and manage tables"--

Provides a review of exam objectives, including restricting and sorting data, subqueries, single-row functions, and set operators, and features practice exercises with answers and explanations and a score report performance assessment tool.

A Complete Study System for OCA Exam 1Z0-061

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:

  • Data retrieval using the SQL SELECT statement
  • Restricting and sorting data
  • Single-row functions
  • Using conversion functions and conditional expressions
  • Reporting aggregated data with the group functions
  • Displaying data from multiple tables with joins
  • Using subqueries to solve problems
  • Using the set operators
  • Manipulating data with DML statements
  • Using DDL statements to create and manage tables

Electronic content includes:

  • 150+ practice exam questions with detailed answers and explanations
  • Score report performance assessment tool
  • PDF copy of the book

Preface xvi
Introduction xx
1 Relational Database Design Using Oracle
1(54)
Position the Server Technologies
3(8)
The Oracle Server Architecture
3(2)
The Oracle WebLogic Server
5(2)
Oracle Enterprise Manager
7(1)
Cloud Computing
8(1)
Exercise 1-1 Investigate Your Database and Application Environment
9(1)
Development Tools and Languages
10(1)
Understand Relational Structures
11(15)
Real-World Scenarios
11(1)
Data Modeling
12(1)
Entities and Relations
12(8)
Exercise 1-2 Design an Entity-Relationship Diagram for the Geological Cores Scenario
20(2)
Rows and Tables
22(4)
Summarize the SQL Language
26(3)
SQL Standards
27(1)
SQL Commands
27(1)
A Set-Oriented Language
28(1)
Use the Client Tools
29(13)
SQL Plus
30(7)
SQL Developer
37(5)
Create the Demonstration Schemas
42(8)
Users and Schemas
42(1)
The HR and OE Schemas
43(3)
Demonstration Schema Creation
46(3)
Two-Minute Drill
49(1)
Q&A Self Test
50(5)
Lab Question
52(1)
Self Test Answers
53(1)
Lab Answer
54(1)
2 Data Retrieval Using the SQL SELECT Statement
55(54)
List the Capabilities of SQL SELECT Statements
56(8)
Introducing the SQL SELECT Statement
56(1)
The DESCRIBE Table Command
57(3)
Exercise 2-1 Describing the Human Resources Schema
60(2)
Capabilities of the SELECT Statement
62(2)
Execute a Basic SELECT Statement
64(34)
The Primitive SELECT Statement
64(5)
Syntax Rules
69(3)
Exercise 2-2 Answering Our First Questions with SQL
72(3)
SQL Expressions and Operators
75(12)
The NULL Concept
87(5)
Exercise 2-3 Experimenting with Expressions and the DUAL Table
92(4)
Two-Minute Drill
96(2)
Q&A Self Test
98(11)
Lab Question
100(2)
Self Test Answers
102(2)
Lab Answer
104(5)
3 Restricting and Sorting Data
109(66)
Limit the Rows Retrieved by a Query
110(33)
The WHERE clause
110(9)
Comparison Operators
119(12)
Exercise 3-1 Using the LIKE Operator
131(2)
Boolean Operators
133(6)
Precedence Rules
139(4)
Sort the Rows Retrieved by a Query
143(7)
The ORDER BY Clause
143(5)
Exercise 3-2 Sorting Data Using the ORDER BY Clause
148(2)
Ampersand Substitution
150(18)
Substitution Variables
150(7)
Define and Verify
157(6)
Exercise 3-3 Using Ampersand Substitution
163(3)
Two-Minute Drill
166(2)
Q&A Self Test
168(7)
Lab Question
170(1)
Self Test Answers
171(2)
Lab Answer
173(2)
4 Single-Row Functions
175(58)
Describe Various Types of Functions Available in SQL
176(7)
Defining a Function
176(4)
Types of Functions
180(3)
Use Character, Number, and Date Functions in SELECT Statements
183(44)
Using Character Case Conversion Functions
183(5)
Exercise 4-1 Using the Case Conversion Functions
188(1)
Using Character Manipulation Functions
189(13)
Exercise 4-2 Using the Character Manipulation Functions
202(1)
Using Numeric Functions
203(6)
Working with Dates
209(4)
Using Date Functions
213(3)
Exercise 4-3 Using the Date Functions
216(9)
Two-Minute Drill
225(2)
Q&A Self Test
227(6)
Lab Question
229(1)
Self Test Answers
230(1)
Lab Answer
231(2)
5 Using Conversion Functions and Conditional Expressions
233(44)
Describe Various Types of Conversion Functions Available in SQL
234(3)
Conversion Functions
234(3)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
237(13)
Using the Conversion Functions
238(7)
Exercise 5-1 Converting Dates into Characters Using the TO_CHAR Function
245(5)
Apply Conditional Expressions in a SELECT Statement
250(21)
Nested Functions
250(2)
General Functions
252(5)
Exercise 5-2 Using NULLIF and NVL2 for Simple Conditional Logic
257(3)
Conditional Functions
260(6)
Exercise 5-3 Using the DECODE Function
266(3)
Two-Minute Drill
269(2)
Q&A Self Test
271(6)
Lab Question
273(1)
Self Test Answers
274(1)
Lab Answer
275(2)
6 Reporting Aggregated Data Using the Group Functions
277(38)
Describe the Group Functions
278(5)
Definition of Group Functions
278(2)
Types and Syntax of Group Functions
280(3)
Identify the Available Group Functions
283(9)
Using the Group Functions
283(6)
Exercise 6-1 Using the Group Functions
289(1)
Nested Group Functions
290(2)
Group Data Using the GROUP BY Clause
292(7)
Creating Groups of Data
292(2)
The GROUP BY Clause
294(2)
Grouping by Multiple Columns
296(1)
Exercise 6-2 Grouping Data Based on Multiple Columns
297(2)
Include or Exclude Grouped Rows Using the HAVING Clause
299(10)
Restricting Group Results
300(1)
The HAVING Clause
301(3)
Exercise 6-3 Using the HAVING Clause
304(3)
Two-Minute Drill
307(2)
Q&A Self Test
309(6)
Lab Question
311(1)
Self Test Answers
312(2)
Lab Answer
314(1)
7 Displaying Data from Multiple Tables
315(50)
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
316(22)
Types of Joins
317(5)
Joining Tables Using ANSI SQL Syntax
322(1)
Qualifying Ambiguous Column Names
323(2)
The NATURAL JOIN Clause
325(2)
Exercise 7-1 Using the NATURAL JOIN
327(1)
The JOIN USING Clause
328(2)
The JOIN ON Clause
330(2)
Exercise 7-2 Using the NATURAL JOIN...ON Clause
332(1)
N-Way Joins and Additional Join Conditions
333(3)
Nonequijoins
336(2)
Join a Table to Itself Using a Self-Join
338(3)
Joining a Table to Itself Using the JOIN...ON Clause
338(2)
Exercise 7-3 Performing a Self-Join
340(1)
View Data That Does Not Meet a Join Condition by Using Outer Joins
341(8)
Inner versus Outer Joins
342(1)
Left Outer Joins
343(2)
Right Outer Joins
345(1)
Full Outer Joins
346(1)
Exercise 7-4 Performing an Outer-Join
347(2)
Generate a Cartesian Product of Two or More Tables
349(9)
Creating Cartesian Products Using Cross Joins
350(1)
Exercise 7-5 Performing a Cross-Join
351(5)
Two-Minute Drill
356(2)
Q&A Self Test
358(7)
Lab Question
361(1)
Self Test Answers
362(1)
Lab Answer
363(2)
8 Using Subqueries to Solve Problems
365(30)
Define Subqueries
366(3)
Exercise 8-1 Types of Subqueries
367(2)
Describe the Types of Problems That the Subqueries Can Solve
369(7)
Use of a Subquery Result Set for Comparison Purposes
369(2)
Star Transformation
371(1)
Generate a Table from Which to SELECT
372(1)
Generate Values for Projection
373(1)
Generate Rows to be Passed to a DML Statement
373(1)
Exercise 8-2 More Complex Subqueries
374(2)
List the Types of Subqueries
376(6)
Single- and Multiple-Row Subqueries
376(1)
Correlated Subqueries
377(2)
Exercise 8-3 Investigate the Different Types of Subqueries
379(3)
Write Single-Row and Multiple-Row Subqueries
382(6)
Exercise 8-4 Write a Query That Is Reliable and User Friendly
383(4)
Two-Minute Drill
387(1)
Q&A Self Test
388(7)
Lab Question
392(1)
Self Test Answers
393(1)
Lab Answer
394(1)
9 Using the Set Operators
395(28)
Describe the Set Operators
396(4)
Sets and Venn Diagrams
396(2)
Set Operator General Principles
398(1)
Exercise 9-1 Describe the Set Operators
399(1)
Use a Set Operator to Combine Multiple Queries into a Single Query
400(10)
The UNION ALL Operator
401(1)
The UNION Operator
401(2)
The INTERSECT Operator
403(1)
The MINUS Operator
403(2)
More Complex Examples
405(2)
Exercise 9-2 Using the Set Operators
407(3)
Control the Order of Rows Returned
410(7)
Exercise 9-3 Control the Order of Rows Returned
411(5)
Two-Minute Drill
416(1)
Q&A Self Test
417(6)
Lab Question
419(1)
Self Test Answers
420(1)
Lab Answer
421(2)
10 Manipulating Data
423(52)
Describe Each Data Manipulation Language (DML) Statement
424(9)
INSERT
425(1)
UPDATE
426(1)
DELETE
427(1)
MERGE
428(1)
TRUNCATE
429(1)
DML Statement Failures
429(4)
Insert Rows into a Table
433(8)
Exercise 10-1 Use the INSERT Command
439(2)
Update Rows in a Table
441(5)
Exercise 10-2 Use the UPDATE Command
444(2)
Delete Rows from a Table
446(5)
Removing Rows with DELETE
446(1)
Exercise 10-3 Use the DELETE Command
447(2)
Removing Rows with TRUNCATE
449(1)
MERGE
450(1)
Control Transactions
451(14)
Database Transactions
451(4)
The Transaction Control Statements
455(1)
Exercise 10-4 Use the COMMIT and ROLLBACK Commands
456(7)
Two-Minute Drill
463(2)
Q&A Self Test
465(10)
Lab Question
469(2)
Self Test Answers
471(2)
Lab Answer
473(2)
11 Using DDL Statements to Create and Manage Tables
475(38)
Categorize the Main Database Objects
476(6)
Object Types
476(2)
Users and Schemas
478(1)
Naming Schema Objects
479(2)
Object Namespaces
481(1)
Exercise 11-1 Determine What Objects Are Accessible to Your Session
482(1)
Review the Table Structure
482(2)
Exercise 11-2 Investigate Table Structures
483(1)
List the Data Types That Are Available for Columns
484(4)
Exercise 11-3 Investigate the Data Types in the HR schema
488(1)
Create a Simple Table
488(8)
Creating Tables with Column Specifications
489(1)
Creating Tables from Subqueries
490(2)
Altering Table Definitions After Creation
492(1)
Dropping and Truncating Tables
493(1)
Exercise 11-4 Create Tables
494(2)
Explain How Constraints Are Created at the Time of Table Creation
496(11)
The Types of Constraints
497(3)
Defining Constraints
500(4)
Exercise 11-5 Work with Constraints
504(2)
Two-Minute Drill
506(1)
Q&A Self Test
507(6)
Lab Question
509(1)
Self Test Answers
510(1)
Lab Answer
511(2)
A About the CD-ROM
513(4)
System Requirements
514(1)
Total Tester Premium Practice Exam Software
514(1)
Installing and Running Total Tester Premium Practice Exam Software
514(1)
Electronic Book
515(1)
Technical Support
515(2)
Total Seminars Technical Support
515(1)
McGraw-Hill Content Support
515(2)
Glossary 517(16)
Index 533
Roopesh Ramklass  is an Oracle Certified Master with expertise in middleware and database architecture. He has worked for Oracle Global Support, Advanced Customer Services, and Oracle University. He is actively involved in the Oracle community, speaking at Oracle conferences, serving as an executive of the Toronto Oracle Users Group, and participating in the Oracle ACE program. Roopesh is the author of several Oracle technology books and blogs and is passionate about serving others through education.