Oracle SQL Recipes

A Problem-Solution Approach

Häftad, Engelska, 2009

AvGrant Allen,Bob Bryla,Darl Kuhn,Chris Allen

659 kr

Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.

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

Produktinformation

Utgivningsdatum2009-11-20
Mått178 x 254 x 31 mm
Vikt1 014 g
FormatHäftad
SpråkEngelska
Antal sidor576
FörlagAPress
ISBN9781430225096

Tillhör följande kategorier

Databaser inom Data och IT

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.

Foundations of Data Manipulation.- The Basics.- Summarizing and Aggregating Data.- Querying from Multiple Tables.- Creating and Deriving Data.- Common Query Patterns.- Data Types and Their Problems.- Working with Date and Time Values.- Strings.- Working with Numbers.- Your Development Environment.- Managing Transactions.- Data Dictionary.- Special Topics.- Common Reporting Problems.- Cleansing Data.- Tree-Structured Data.- Working with XML Data.- Partitioning.- LOBs.- Administration.- Database Administration.- Object Management.- SQL Monitoring and Tuning.- Database Troubleshooting.