Query Name Index
Author :
Publisher :
Page : 614 pages
File Size : 42,37 MB
Release : 1973
Category :
ISBN :
Access Data Analysis Cookbook
Author : Ken Bluttman
Publisher : "O'Reilly Media, Inc."
Page : 369 pages
File Size : 43,28 MB
Release : 2007-05-14
Category : Computers
ISBN : 0596555210
Book Description
If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works. 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, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to: Develop basic and sophisticated queries Apply aggregate functions, custom functions, regular expressions, and crosstabs Apply queries to perform non-passive activities such as inserting, updating, and deleting data Create and manipulate tables and queries programmatically Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing Use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products Find answers from time-based data, such as how to add time, count elapsed time, work with leap years, and how to manage time zones in your calculations Deal with business and finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment (ROI) Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, combinations and permutations Access Data Analysis Cookbook is a one-stop-shop for extracting nuggets of valuable information from your database, and anyone with Access experience will benefit from these tips and techniques, including seasoned developers. If you want to use your data, and not just store it, you'll find this guide indispensable.
High Performance MySQL
Author : Jeremy D. Zawodny
Publisher : "O'Reilly Media, Inc."
Page : 297 pages
File Size : 39,20 MB
Release : 2004-04-08
Category : Computers
ISBN : 0596555164
Book Description
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include: A review of configuration and setup options Storage engines and table types Benchmarking Indexes Query Optimization Application Design Server Performance Replication Load-balancing Backup and Recovery Security
The Definitive Guide to Berkeley DB XML
Author : Daniel Brian
Publisher : Apress
Page : 417 pages
File Size : 37,12 MB
Release : 2007-02-01
Category : Computers
ISBN : 1430202203
Book Description
This book teaches the basics of XML with an original approach, using real-world examples from an interesting (and operating) environment with broad applicability. It covers the full spectrum of Berkeley DB XML tools, including the command-line shell, transactions, rollbacks, replication, archiving and monitoring. Techniques and concepts that have broad applicability outside of the subject matter are skillfully explained: XML, XPath, XQuery, XML schemas, all industry-standard technologies that find one of their best tutorial treatments, and all in the context of a simple database solution. The book also presents a remarkable example of query power.
The Source
Author : Loretto Dennis Szucs
Publisher : Ancestry Publishing
Page : 1000 pages
File Size : 24,57 MB
Release : 2006
Category : Reference
ISBN : 9781593312770
Book Description
Genealogists and other historical researchers have valued the first two editions of this work, often referred to as the genealogist's bible."" The new edition continues that tradition. Intended as a handbook and a guide to selecting, locating, and using appropriate primary and secondary resources, The Source also functions as an instructional tool for novice genealogists and a refresher course for experienced researchers. More than 30 experts in this field--genealogists, historians, librarians, and archivists--prepared the 20 signed chapters, which are well written, easy to read, and include many helpful hints for getting the most out of whatever information is acquired. Each chapter ends with an extensive bibliography and is further enriched by tables, black-and-white illustrations, and examples of documents. Eight appendixes include the expected contact information for groups and institutions that persons studying genealogy and history need to find. ""
Database Performance Tuning and Optimization
Author : Sitansu S. Mittra
Publisher : Springer Science & Business Media
Page : 495 pages
File Size : 46,41 MB
Release : 2006-04-18
Category : Computers
ISBN : 0387218084
Book Description
Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.
Advanced Ajax
Author : Shawn M. Lauriat
Publisher : Pearson Education
Page : 399 pages
File Size : 24,77 MB
Release : 2007-10-15
Category : Computers
ISBN : 0132702983
Book Description
“I very much enjoyed how this book covers the full Ajax application lifecycle and not only coding techniques. Anyone who is looking to become a professional front-end developer will appreciate the architectural insight and best practices delivered by this book.” — Andi Gutmans, Co-Founder & Co-Chief Technology Officer of Zend Technologies Mission-Critical Ajax: Maximizing Scalability, Performance, Security, Reliability, and Maintainability Advanced Ajax: Architecture and Best Practices is the definitive guide to building business-critical, production-quality Web applications with Ajax. Shawn M. Lauriat systematically addresses the design, architecture, and development issues associated with Ajax, offering proven patterns and robust code examples available in no other book. You’ll find best practices for addressing the full spectrum of issues enterprise Ajax developers face: scalability, performance, security, reliability, flexibility, maintainability, and reusability. Writing for experienced Web developers, Lauriat delivers fresh ideas and elegant solutions: meaty technical content, presented with exceptional clarity. Among the many topics he covers in unprecedented depth: cleanly implementing JavaScript custom events to reduce coupling and to enhance flexibility; overcoming Ajax’s traditional accessibility limitations; reducing network latency through compression and other techniques; and much more. Coverage includes Planning Ajax interfaces for simplicity, clarity, and intuitiveness Creating scalable, maintainable architectures for client-side JavaScript Using the latest tools to profile, validate, and debug client-side code Architecting the server side for security and functionality, while restricting loaded data, objects, and actions to current requests Protecting against the most widespread and significant Ajax security risks Optimizing every component of an Ajax application, from server-side scripts to database interactions Introducing cutting-edge Ajax: game development, Ajax with canvas, and Ajax for enterprise applications About the Web Site This book’s companion Web site (http://advancedajax.frozen-o.com) doesn’t just provide all the code: It shows code examples in action, as building blocks of a real Web application interface.
The Programmer's Guide to SQL
Author : Cristian Darie
Publisher : Apress
Page : 565 pages
File Size : 22,74 MB
Release : 2008-01-01
Category : Computers
ISBN : 1430208007
Book Description
This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
MySQL Cookbook
Author : Paul DuBois
Publisher : "O'Reilly Media, Inc."
Page : 1026 pages
File Size : 17,33 MB
Release : 2003
Category : Computers
ISBN : 9780596001452
Book Description
DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects.
SQL
Author : Michael J. Donahoo
Publisher : Elsevier
Page : 273 pages
File Size : 50,84 MB
Release : 2010-07-21
Category : Computers
ISBN : 0080489745
Book Description
SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses — no matter what main text you use or what flavor of SQL is required. It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user. This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses. - Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL. - The approach is vendor-neutral—so very adaptable and flexible - The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter. - Coverage is on the key features of the language that are required to understand SQL and begin using it effectively. - SQL 2003-compliant.
