You may have seen Unix quick-reference guides, but you've never seen anything like UNIX in a Nutshell. Not a scaled-down quick reference of common commands, UNIX in a Nutshell is a complete reference containing all commands and options, along with generous descriptions and examples that put the commands in context. For all but the thorniest Unix problems, this one reference should be all the documentation you need.The third edition of UNIX in a Nutshell includes thorough coverage of System V Release 4. To that, author Arnold Robbins has added the latest information about: Sixty new commands in The Alphabetical Summary of Commands Solaris 7 Shell syntax (sh, csh, and the 1988 and 1993 versions of ksh) Regular expression syntax vi and ex commands, as well as newly updated Emacs information sed and awk commands troff and related commands and macros, with a new section on refer make, RCS (version 5.7), and SCCS commandsIn addition, there is a new Unix bibliography to guide the reader to further reading about the Unix environment.If you currently use Unix SVR4, or if you're a Solaris user, you'll want this book. UNIX in a Nutshell is the most comprehensive quick reference on the market, a must for any Unix user.

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open-source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL's most significant release to date, readers will learn how to take advantage of the features of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, readers will not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's seven years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide. What you’ll learn The PHP language How to back your web site with MySQL Templating so that you can apply a consistent design across all pages on your site How to authenticate your web site users How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site Who this book is for This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.

The Seventh Edition continues to focus on the hallmark feature of its previous editions: providing a solid grounding in the foundations of database technology and shedding some light on how the field is likely to develop in the future. This comprehensive introduction to databases has been thoroughly revised to reflect the latest developments and advances in the field of database systems. Emphasizing insight and understanding rather than formalism, Chris Date has divided the book into six parts: Basic Concepts, The Relational Model, Database Design, Transaction Management, Further Topics, and Object and Object/Relational Databases. Throughout the book, there are numerous worked examples and exercises for the reader--with selected answers--as well as an extensive set of annotated references. The release of this new edition of An Introduction to Database Systems coincides with the 25th Anniversary of its initial publication.

Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS).You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications.If you are familiar with relational database concepts but are new to Microsoft SQL Server or the T-SQL language, this book will teach you the basics from the ground up. If you're familiar with earlier versions of SQL Server, it will get you up-to-speed on the newest features. And if you know SQL Server 2005, you'll learn about some exciting new capabilities in SQL Server 2008.Information Technology professionals in many different roles use T-SQL. Our goal is to provide a guide and a reference for IT pros across the spectrum of operational database solution design, database application development, and reporting and business intelligence solutions.Database solution designers will find this book to be a thorough introduction and comprehensive reference for all aspects of database modeling, design, object management, query design, and advanced query concepts.Application developers who write code to manage and consume SQL Server data will benefit from our thorough coverage of basic data management and simple and advanced query design. Several examples of ready-to-use code are provided to get you started and to continue to support applications with embedded T-SQL queries.Report designers will find this book to be a go-to reference for report query design. You will build on a thorough introduction to basic query concepts and learn to write efficient queries to support business reports and advanced analytics.Finally, database administrators who are new to SQL Server will find this book to be an all-inclusive introduction and reference of mainstream topics. This can assist you as you support the efforts of other team members. Beyond the basics of database object management and security concepts, we recommend Beginning SQL Server 2005 Administration and Beginning SQL Server 2008 Administration from Wrox, co-authored in part by the same authors.This book introduces the T-SQL language and its many uses, and serves as a comprehensive guide at a beginner through intermediate level. Our goal in writing this book was to cover all the basics thoroughly and to cover the most common applications of T-SQL at a deeper level. Depending on your role and skill level, this book will serve as a companion to the other Wrox books in the Microsoft SQL Server Beginning and Professional series..This book will help you to learn:How T-SQL provides you with the means to create tools for managing databases of different size, scope, and purposeVarious programming techniques that use views, user-defined functions, and stored proceduresWays to optimize query performanceHow to create databases that will be an essential foundation to applications you develop laterEach section of this book organizes topics into logical groups so the book can be read cover-to-cover or can be used as a reference guide for specific topics.We start with an introduction to the T-SQL language and data management systems, and then continue with the SQL Server product fundamentals. This first section teaches the essentials of the SQL Server product architecture and relational database design principles. This section (Chapters 1–3) concludes with an introduction to the SQL Server administrator and developer tools.The next section, encompassing Chapters 4 through 9, introduces the T-SQL language and teaches the core components of data retrieval, SQL functions, aggregation and grouping, and multi-table queries. We start with the basics and build on the core structure of the SQL SELECT statement, progressing to advanced forms of SELECT queries.Chapter 10 introduces transactions and data manipulation. You will learn how the INSERT, UPDATE, and DELETE statements interact with the relational database engine and transaction log to lock and modify data rows with guaranteed consistency. You will not only learn to use correct SQL syntax but will understand how this process works in simple terms.More advanced topics in the concluding section will teach you to create and manage T-SQL programming objects, including views, functions, and stored procedures. You learn to optimize query performance and use T-SQL in application design, applying the query design basics to real-world business solutions. Chapter 15 contains a complete tutorial on using SQL Server 2008 Reporting Services to visualize data from the T-SQL queries you create.The book concludes with a comprehensive set of reference appendixes for command syntax, system stored procedures, information schema views, file system commands, and system management commands.The material in this book applies to all editions of Microsoft SQL Server 2005 and 2008. To use all the features discussed, we recommend that you install the Developer Edition, although you can also use the Enterprise, Standard, or Workgroup editions.SQL Server 2005 Developer Edition or SQL Server 2008 Developer Edition can be installed on a desktop computer running Windows 2000, Windows XP, or Windows Vista. You can also use Windows 2000 Server, Windows Server 2003, or Windows Server 2008 with the Enterprise or Standard edition. The SQL Server client tools must be installed on your desktop computer and the SQL Server relational database server must be installed on either your desktop computer or on a remote server with network connectivity and permission to access.Consult www.microsoft.com/sql for information about the latest service packs, specific compatibilities, and minimum recommend system requirements.The examples throughout this book use the following sample databases, which are available to download from Microsoft: the sample database for SQL Server 2005 is called AdventureWorks, and the sample database for SQL Server 2008 is called AdventureWorks2008. Because the structure of these databases differs significantly, separate code samples are provided throughout the book for these two version-specific databases.An example using the AdventureWorks2008DW database for SQL Server 2008 is also used in Chapter 15.

Ready to put Intuit's QuickBase to work? Our new Missing Manual shows you how to capture, modify, share, and manage data and documents with this web-based data-sharing program quickly and easily. No longer do you have to coordinate your team through a blizzard of emails or play frustrating games of "guess which document is the right one." QuickBase saves your organization time and money, letting you manage and share the information that makes your business tick: sales figures, project timelines, drafts of documents, purchase or work requests--whatever information you need to keep business flowing smoothly. QuickBase: The Missing Manual shows you how to choose among QuickBase's dozens of ready-made applications (mini-databases, essentially) and how to customize one to fit your needs exactly. You'll also learn to assign people different roles within the application. The guide also shows you how to:Capture and modify data: Whatever kind of data you need to store--sales leads, catalog listings, project milestones, workflow checklists--you can use QuickBase's forms to record and organize that data so it makes sense to you. Filter, sort, and group data: Easily find the records that match your criteria, and then sort those records into groups that make their relationships clear. Display your data: QuickBase uses different views (Table, Grid Edit, Summary/Crosstab, Calendar, Chart, and Timeline) to display and summarize data. Switching between them is easy, like taking tasks listed in a table and displaying them as a timeline. Create reports: Print out a hard copy, embed charts in the annual report, or email this month's sales numbers. Because Intuit frequently introduces new features to QuickBase, you'll find updates to this book at our Missing Manual web site so you can benefit from the latest technology and user suggestions right away.

Logistics is defined as a business planning framework for the management of material, service, information and capital flows. Logistic systems have received considerable attention in the last 10 years, as they constitute one of the cornerstones in the design and control of production systems and the modeling of supply chains. This renewed interest is partly due to the recognition that well-known planning and control systems such as ‘Manufacturing Resources Planning’ and ‘Just in Time’ systems fail to establish a sound integration of lead time management, capacity planning and quality considerations.This book uniquely:Presents a balanced treatment of quantitative methods for logistics systems planning, organization and control.Each topic is illustrated with real examples.Each chapter features an annotated bibliography of key references.Features a number of case studies that show how the methods can be applied to complex logistics problems.Assumes only a basic knowledge of operations research.Supported by a Website (http://wileylogisticsbook.dii.unile.it) featuring exercises and teaching material.A unique, leading edge title for researchers, practitioners, and students of logistics and supply chain management, in both academia; engineering, computer science, management science, undergraduate, graduate students and industry professionals.

After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 releaseOnce readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation servicesThe companion Web site provides all of the code found in the book

With the latest incarnations of ASP.NET 2.0 and SQL Server 2005, programming dynamic data-driven websites with Microsoft technologies has become easier and much more efficient than ever before. Fewer mouse clicks and fewer lines of code can now enable more powerful features and the tools you need—Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition—are free! In this book you’ll learn how to best use the free development tools offered by Microsoft to build an online product catalog with shopping cart, checkout, product searching, product recommendations, a control panel, customer accounts, order processing and much much more. You’ll learn how to handle payments by integrating PayPal, DataCash, and VeriSign Payflow Pro into your site. We’ll also teach you how to expand your site’s product listing by expanding your product section through web services. Each feature you add to your website will introduce you to new challenges and theoretical concepts, which are carefully analyzed and explained throughout the book. You will gain an intimate understanding of every piece of code you write. This understanding will enable you to build your own powerful and flexible websites efficiently and rapidly with ASP.NET 2.0. You can visit a demonstration version of the site built in this book by visiting the author's website (www.cristiandarie.ro).