Oracle SQL Recipes

Part 1. Foundations of Data Manipulation

1. The Basics
Grant Allen, Bob Bryla, Darl Kuhn

2. Summarizing and Aggregating Data
Grant Allen, Bob Bryla, Darl Kuhn

3. Querying from Multiple Tables
Grant Allen, Bob Bryla, Darl Kuhn

4. Creating and Deriving Data
Grant Allen, Bob Bryla, Darl Kuhn

5. Common Query Patterns
Grant Allen, Bob Bryla, Darl Kuhn

Part 2. Data Types and Their Problems

6. Working with Date and Time Values
Grant Allen, Bob Bryla, Darl Kuhn

7. Strings
Grant Allen, Bob Bryla, Darl Kuhn

8. Working with Numbers
Grant Allen, Bob Bryla, Darl Kuhn

Part 3. Your Development Environment

9. Managing Transactions
Grant Allen, Bob Bryla, Darl Kuhn

10. Data Dictionary
Grant Allen, Bob Bryla, Darl Kuhn

Part 4. Special Topics

11. Common Reporting Problems
Grant Allen, Bob Bryla, Darl Kuhn

12. Cleansing Data
Grant Allen, Bob Bryla, Darl Kuhn

13. Tree-Structured Data
Grant Allen, Bob Bryla, Darl Kuhn

14. Working with XML Data
Grant Allen, Bob Bryla, Darl Kuhn

15. Partitioning
Grant Allen, Bob Bryla, Darl Kuhn

16. LOBs
Grant Allen, Bob Bryla, Darl Kuhn

PART 5. Administration

17. Database Administration
Grant Allen, Bob Bryla, Darl Kuhn

18. Object Management
Grant Allen, Bob Bryla, Darl Kuhn

19. SQL Monitoring and Tuning
Grant Allen, Bob Bryla, Darl Kuhn

20. Database Troubleshooting
Grant Allen, Bob Bryla, Darl Kuhn

Keywords: Computer Science, Data Structures, Cryptology and Information Theory