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.
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
- 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
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
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
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.
Über den Autor
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.
Inhaltsverzeichnis
- 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
Klappentext
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
Merges the approach of two, proven successful books on SQL (the SQL Cookbook and Mastering Oracle SQL)
Cowritten by one of Apress's strongest, recipe-book authors
Takes a solution-oriented approach that is sure to appeal to readers with problems to solve and little time to sit back and read
