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/