OCP (oracle 10g administration ii study guide 2)

Clear and concise information on advanced database administration with Oracle 10g

Practical examples and insights drawn from the authors' real-world experiences

Leading-edge exam preparation software, including a test engine and electronic flashcards

Link: http://www.zshare.net/download/6149151015d8fcf6/

OCA 11g SQL Fundamentals 1z0-051

This Book provides complete study material for SQL Fundamentals Exam 1z0-051

It Includes:

1. SQL SELECT statements
2. Restricting and sorting data
3. Single-row functions
4. Conversion functions and conditional expressions
5. Group functions
6. Displaying data from multiple tables
7. Subqueries
8. Set operators
9. DML and DDL statements

Table Of Contents:

Chapter 1. Oracle Server Technologies and the Relational Paradigm

Chapter 2. Data Retrieval Using the SQL SELECT Statement

Chapter 3. Restricting and Sorting Data

Chapter 4. Single-Row Function

Chapter 5. Using Conversion Functions and Conditional Expressions

Chapter 6. Reporting Aggregated Data Using the Group Functions

Chapter 7. Displaying Data from Multiple Tables

Chapter 8. Using Subqueries to Solve Problems

Chapter 9. Using the Set Operators

Chapter 10. Manipulating Data

Chapter 11. Using DDL Statements to Create and Manage Tables

Chapter 12. Creating Other Schema Objects

Appendix

Glossary

Index

Link:http://www.zshare.net/download/614917056825a268/