Oracle SQL Recipes: A Problem-Solution Approach (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
542
Utgivningsdatum
2009-11-23
Upplaga
1
Förlag
APRESS
Medarbetare
Bryla, Bob / Kuhn, Darl
Illustrationer
illustrations
Dimensioner
234 x 190 x 30 mm
Vikt
999 g
Antal komponenter
1
Komponenter
Paperback
ISBN
9781430225096

Oracle SQL Recipes: A Problem-Solution Approach

av Grant Allen, Bob Bryla, Darl Kuhn, Grant Allen
Häftad,  Engelska, 2009-11-23
531
Köp
Spara som favorit
  • Skickas från oss inom 3-6 vardagar.
  • Fri frakt över 249 kr för privatkunder i Sverige.
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side.
  • Example-based, providing quality solutions to everyday problems
  • Respects your time by putting solutions first and keeping discussions short
  • Solves the most commonly encountered SQL problems

What youll learn

  • Recognize common query patterns and apply their corresponding solutions.
  • Solve common reporting problems such as sorting rows into buckets.
  • Troubleshoot SQL performance problems.
  • Create and manage database objects such as tables, indexes, and views.
  • Work with XML and tree-structured data.
  • Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL.

Who this book is for

Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you.

Table of Contents

  1. The Basics
  2. Summarizing and Aggregating Data
  3. Querying from Multiple Tables
  4. Creating and Deriving Data
  5. Common Query Patterns
  6. Working with Date and Time Values
  7. Strings
  8. Working with Numbers
  9. Managing Transactions
  10. Data Dictionary
  11. Common Reporting Problems
  12. Cleansing Data
  13. Tree-Structured Data
  14. Working with XML Data
  15. Partitioning
  16. LOBs
  17. Database Administration
  18. Object Management
  19. SQLMonitoring and Tuning
  20. Database Troubleshooting
Visa hela texten

Passar bra ihop

  1. Oracle SQL Recipes: A Problem-Solution Approach
  2. +
  3. Co-Intelligence

De som köpt den här boken har ofta också köpt Co-Intelligence av Ethan Mollick (häftad).

Köp båda 2 för 759 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Fler böcker av författarna

Grant Allen, Bob Bryla, Darl Kuhn, Grant Allen

Övrig information

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.

Innehållsförteckning

* The Basics * Summarizing and Aggregating Data * Querying from Multiple Tables * Creating and Deriving Data * Common Query Patterns * Working with Date and Time Values * Strings * Working with Numbers * Managing Transactions * Data Dictionary * Common Reporting Problems * Cleansing Data * Tree-Structured Data * Working with XML Data * Partitioning * LOBs * Database Administration * Object Management * SQL Monitoring and Tuning * Database Troubleshooting

Du kanske gillar