Oracle SQL Recipes: A Problem-Solution Approach

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 you'll 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.

==> Download <==

Oracle PL/SQL Programming

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

This indispensable reference for both novices and experienced Oracle programmers will help you:

* Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
* Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
* Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
* Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
* Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
* Build modular PL/SQL applications using procedures, functions, triggers, and packages

==> Download <==

SQL The Complete Reference, 3rd Edition

Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

* Build SQL-based relational databases and applications
* Create, load, and modify database objects using SQL
* Construct and execute simple, multitable, and summary queries
* Implement security measures with authentication, privileges, roles, and views
* Handle database optimization, backup, recovery, and replication
* Work with stored procedures, functions, extensions, triggers, and objects
* Extend functionality using APIs, dynamic SQL, and embedded SQL
* Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol
* Understand the latest market trends and the future of SQL

==> Download <==

SQL Fundamentals (3rd Edition)

Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.

SQL Fundamentals,Third Edition, teaches you how to

* Build simple statements to retrieve, store, or modify data
* Craft complex queries that draw information from multiple tables
* Sort and summarize your data just the way you want it
* Create and edit your own tables
* Protect the integrity of your data
* Create more efficient, high-performance queries
* Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
* Use the Oracle Data Dictionary

==> Download <==

Refactoring SQL Applications

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to:

* Determine if and where you can expect performance gains
* Apply quick fixes, such as limiting calls to the database in stored functions and procedures
* Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements
* Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous
* Refactor design using schema extensions, regular views, materialized views, partitioning, and more
* Compare before and after versions of a program to ensure you get the same results once you make modifications

Refactoring SQL Applications teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.

==> Download <==

Sams Teach Yourself SQL in 24 Hours

In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.

Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.

Step-by-step instructions carefully walk you through the most common SQL tasks.

Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.

Notes and Tips point out shortcuts and solutions.

New terms are clearly defined and explained.

==> Download <==

Oracle Database 11g PL/SQL Programming

Book Description

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.

==> Download <==