SQL Pocket Guide, 3rd EditionIf you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax. ...
Regular Expression Pocket Reference, 2nd EditionThis handy little book offers programmers a complete overview of the syntax and semantics of regular expressions that are at the heart of every text-processing application. Ideal as a quick reference, Regular Expression Pocket Reference covers the regular expression APIs for Perl 5.8, Ruby (including some upcoming 1.9 features), Java, PHP, .NET and C#, Python, vi, JavaScript, and the PCRE regular expression libraries. ...
Oracle Built-in PackagesOracle's built-in packages dramatically extend the power of the PL/SQL language, but few developers know how to use them effectively. This book is a complete reference to all of the built-ins, including those new to Oracle8. the enclosed diskette includes an online tool that provides easy access to the many files of source code and documentation developed by the authors. ...
Oracle DBA Checklists Pocket ReferenceIn a series of easy-to-use checklists, the Oracle DBA Checklists Pocket Reference summarizes the enormous number of tasks an Oracle DBA must perform. Each section takes the stress out of DBA problem solving with a step-by-step "cookbook" approach to presenting DBA quick-reference material, making it easy to find the information you need--and find it fast. ...
Oracle PL/SQL Language Pocket Reference, 4th EditionThe fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information into an accessible summary. ...
Oracle RMAN Pocket ReferenceOracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital. ...
C# 4.0 Pocket Reference, 3rd EditionWhen you're programming C# 4.0 and need a little help, this tightly focused and practical book tells you exactly what you need to know - without long introductions or bloated examples. It's ideal as a succinct quick reference or as a guide to get you rapidly up to speed if you already know Java, C++, or an earlier version of C#. Written by the authors of the acclaimed C# 4.0 in a Nutshell, this book covers the entire C# 4.0 language - without skimping on the details ...
Access 2007: The Missing ManualAccess 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks - even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master. ...
Access Data Analysis CookbookThis book offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, how to jump beyond SQL by manipulating data with VBA, and more. ...
Access Database Design & Programming, 3rd EditionWhen using GUI-based software, we often focus so much on the interface that we forget about the general concepts required to use the software effectively. Access Database Design & Programming takes you behind the details of the interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. The main sections of this book include: database design,queries, and programming. ...