To the people who are accomplished in its use, Structured Query Language (SQL) is a highly capable, eminently flexible, even beautiful way of describing the data that you want from a database, or the changes that you want to make to a database. For the rest of us, however, SQL is a first-class nuisance that we do our best to avoid by relying on relatively user-friendly–but usually less powerful–tools. SQL Queries for Mere Mortals aims to bring SQL-phobes closer to the first camp by tutoring them carefully in what SQL can do.
The authors recognize that SQL queries usually come about as a result of questions from human beings, and so usefully spend a fair bit of time showing how to convert, say, “In what cities do our customers live?” into, “Select city from the customers table” and, finally, “SELECT city FROM customers” in SQL. They call this the “translation and clean up” process, and it’s a fine approach. They don’t press it too far, however, and are equally adept at presenting straight explanations of SQL syntax elements in prose. They spend a lot of energy graphically diagramming aspects of SQL syntax in a format that requires some up-front study. A particular reader might prefer text capsules to this arrow-intensive format, but other learners might like the graphical syntax diagrams. –David Wall
Please Login or Register (Quick) to see the download links.
Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint–and solve–core problems and bottlenecks, and increase productivity exponentially.
Identify and Resolve System Bottlenecks Quickly
Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint–and solve–core problems and bottlenecks, and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views, their applications, and the extended SQL trace file. This invaluable resource will help you maximize the most advanced diagnostics tool available and minimize processing time.
Please Login or Register (Quick) to see the download links.
The landscape of doing SharePoint development has changed considerably in the last year, with the release of SharePoint Server 2007 and its related technologies. You need a contemporary reference to stay on top of the latest ways to combine .NET development techniques with your SharePoint development techniques, and SharePoint 2007 Development Techniques is your guide.
What makes this book unique are the topics that have never before been discussed in a SharePoint 2007 context. Learn how to incorporate the latest trends, capabilities, and enhancements in your daily SharePoint development activities.
Please Login or Register (Quick) to see the download links.
