Muutke küpsiste eelistusi

DB2 10.1 Fundamentals: Certification Study Guide [Pehme köide]

  • Formaat: Paperback / softback, 536 pages, kõrgus x laius x paksus: 229x178x28 mm, kaal: 826 g
  • Ilmumisaeg: 15-Aug-2014
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473491
  • ISBN-13: 9781583473498
Teised raamatud teemal:
DB2 10.1 Fundamentals: Certification Study GuideSuurem pilt
  • Formaat: Paperback / softback, 536 pages, kõrgus x laius x paksus: 229x178x28 mm, kaal: 826 g
  • Ilmumisaeg: 15-Aug-2014
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473491
  • ISBN-13: 9781583473498
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781583473498.html
Märksõnad:

Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects, working with data using SQL and XQuery, working with DB2 tables, views, and indexes—and more. The book concludes with an extensive set of 150 practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Written by a DB2 authority who has helped IBM develop 21 DB2 certification exams, this is the ultimate resource for those who plan to earn their IBM Certified Database Associate certification.

About the Author iv
Acknowledgments v
Foreword xii
Introduction xiii
About This Book
xiv
Audience
xvi
Conventions Used
xvii
Example 1
xvii
Example 2
xvii
1 IBM DB2 Certification 1(34)
DB2 10 and 10.1 Certification Roles
2(12)
IBM Certified Database Associate—DB2 10.1 Fundamentals
2(2)
IBM Certified Database Administrator—DB2 10.1 for Linux, UNIX, and Windows
4(3)
IBM Certified Database Administrator—DB2 10 for z/OS
7(3)
IBM Certified System Administrator—DB2 10 for z/OS
10(2)
IBM Certified Advanced Database Administrator—DB2 10.1 for Linux, UNIX, and Windows
12(2)
Additional DB2 9.7 Certification Roles
14(4)
IBM Certified Application Developer—DB2 9.7 for Linux, UNIX, and Windows
14(2)
IBM Certified Solution Developer—DB2 9.7 SQL Procedure
16(2)
The Certification Process
18(17)
Preparing for the Certification Exams
18(2)
Arranging to Take a Certification Exam
20(2)
Taking an IBM Certification Exam
22(13)
2 Planning 35(28)
The DB2 Family
36(11)
DB2 Express-C
38(2)
DB2 Express Edition
40(1)
DB2 Workgroup Server Edition (WSE)
41(2)
DB2 Enterprise Server Edition (ESE)
43(1)
DB2 Advanced Enterprise Server Edition (AESE)
44(1)
DB2 for z/OS
45(2)
Database Workloads
47(5)
Optimized Solutions for Each Workload Type
49(3)
Managing Nonrelational Data
52(4)
Large Objects (LOBS)
53(2)
XML Documents
55(1)
DB2's Comprehensive Tool Set
56(7)
The DB2 Command Line Processor
56(3)
IBM Data Studio
59(4)
3 Security 63(44)
Controlling Database Access
64(1)
Authentication
64(3)
Where Authentication Takes Place
65(2)
Authorities and Privileges
67(16)
Administrative Authorities
68(4)
Privileges
72(11)
Granting Authorities and Privileges
83(5)
The GRANT Statement
84(3)
GRANT Statement Examples
87(1)
Revoking Authorities and Privileges
88(3)
REVOKE Statement Examples
90(1)
Row and Column Access Control (RCAC)
91(5)
Row Permissions
92(2)
Column Masks
94(2)
Activating Row and Column Access Control
96(1)
Label-Based Access Control (LBAC)
96(8)
Security Label Components
97(1)
Security Policies
98(2)
Security Labels
100(1)
Granting Security Labels to Users
101(1)
Implementing Row-Level LBAC Protection
102(1)
Implementing Column-Level LBAC Protection
103(1)
A Word About Trusted Contexts
104(3)
4 Working with Databases and Database Objects 107(44)
Servers, Instances, and Databases
108(1)
Other DB2 Objects
109(26)
Data Objects
109(16)
System Objects
125(10)
Creating a DB2 Database
135(4)
Establishing a Database Connection
139(5)
Tjpe 1 and Tjpe 2 Connections
140(2)
A Word About DB2 Connect
142(2)
Temporal Data Management and Time Travel Tables
144(7)
Basic Temporal Data Concepts
144(7)
5 Working with DB2 Data Using SQL 151(106)
Structured Query Language (SQL)
152(1)
SQL Data Manipulation Language (DML) Statements
153(11)
The INSERT Statement
153(3)
The UPDATE Statement
156(3)
The DELETE Statement
159(3)
The SELECT Statement
162(2)
A Closer Look at the SELECT Statement and Its Clauses
164(51)
Other SELECT Statement Clauses
168(1)
The Where Clause
169(11)
The GROUP BY Clause
180(1)
The GROUP BY ROLLUP Clause
181(2)
The GROUP BY CUBE Clause
183(2)
The HAVING Clause
185(1)
The ORDER BY Clause
186(1)
The FETCH FIRST Clause
187(2)
The Isolation Clause
189(1)
A Word About Common Table Expressions
190(2)
A Word About CASE Expressions
192(4)
Joining Tables
196(11)
Using a Set Operator to Combine the Results of Two or More Queries
207(8)
Using a Cursor to Obtain Results from a Result Data Set
215(8)
The DECLARE CURSOR Statement
216(2)
The OPEN Statement
218(1)
The FETCH Statement
219(1)
The CLOSE Statement
220(1)
Putting It All Together
221(2)
Working with Temporal (Time Travel) Tables
223(7)
Querying System-Period Temporal Tables
225(1)
Querying Application-Period Temporal Tables
226(3)
Querying Bitemporal Temporal Tables
229(1)
Working with XML Data
230(5)
Working with User-Defined Functions (UDFs)
235(6)
Creating SQL Scalar and SQL Table User-Defined Functions
237(3)
Invoking SQL Scalar and SQL Table User-Defined Functions
240(1)
Working with Stored Procedures
241(7)
Developing and Registering SQL Stored Procedures
242(4)
Calling a Stored Procedure
246(2)
Transactions and Transaction Boundaries
248(9)
Transaction Management with Savepoints
252(5)
6 Working with DB2 Tables, Views, and Indexes 257(84)
DB2's Data Types
258(9)
Numeric Data Types
259(1)
Character String Data Types
260(3)
Date and Time Data Types
263(1)
Large Object Data Types
264(1)
The Extensible Markup Language (XML) Data Type
265(1)
A Word About the Oracle Compatibility Data Types
266(1)
User-Defined Data Types
267(1)
Understanding Data Constraints
267(29)
NOT NULL Constraints
268(1)
Default Constraints
268(4)
UNIQUE Constraints
272(2)
Check Constraints
274(1)
Referential Integrity Constraints
275(18)
Informational Constraints
293(3)
Creating Tables
296(21)
Creating Tables with Identity Columns
304(2)
Creating Tables That Are Similar to Existing Tables
306(1)
A Quick Word About Schemas
307(1)
Examples of the CREATE TABLE Statement
308(9)
Altering Tables
317(2)
A Closer Look at Temporary Tables
319(4)
A Closer Look at Views
323(6)
A Closer Look at Indexes
329(3)
A Closer Look at Triggers
332(9)
7 Data Concurrency 341(36)
Understanding Data Consistency
342(1)
Transactions, Isolation Levels, and Locks
342(35)
Isolation Levels
344(8)
Choosing the Proper Isolation Level
352(2)
Specifying the Isolation Level to Use
354(2)
Locks
356(1)
Lock Attributes and Lock States
357(4)
How Locks Are Acquired
361(2)
Which Locks Are Acquired?
363(1)
Lock Avoidance
364(1)
Currently Committed Semantics
365(4)
Enabling Currently Committed Semantics Behavior
369(1)
Locks and Performance
369(8)
Appendix A: DB2 10.1 Fundamentals Exam (Exam 610) Objectives 377(4)
Appendix B: Practice Questions 381(58)
Appendix C: Answers to Practice Questions 439(54)
Index 493