MySQL in a Nutshell
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL. Inside, you'll find: A thorough reference to MySQL statements, functions, and administrative utilities Several tutorial chapters to help newcomers get started Programming language APIs for PHP, Perl, and C Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory New chapters on replication, triggers, and stored procedures Plenty of new examples of how MySQL is used in practice Useful tips to help you get through the most difficult subjects Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.
Oracle Database 11g Pl/SQL Programming
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Design Feature-Rich PL/SQL ApplicationsDeliver 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.Create, debug, and manage Oracle-driven PL/SQL programsUse PL/SQL structures, delimiters, operators, variables, and statementsIdentify and eliminate errors using PLSQL_WARNINGS and exception handlersWork with functions, procedures, packages, collections, and triggersDefine and deploy varray, nested table, and associative array data typesHandle external routines, object types, large objects, and secure filesCommunicate between parallel sessions using DBMS_ALERT and DBMS_PIPECall external procedures through Oracle Net Services and PL/SQL wrappersIntegrate internal and server-side Java class libraries using Oracle JVMDevelop robust Web applications using PL/SQL Gateway and Web Toolkit
ADO.NET 3.5 Cookbook
This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform. Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations. This collection of timesaving recipes covers vital topics including: Connecting to data Retrieving and managing data Transforming and analyzing data Modifying data Binding data to .NET user interfaces Optimizing .NET data access Enumerating and maintaining database objects Maintaining database integrity Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
Sap(r) Project System Handbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Centralize and Control Enterprise Project ManagementPlan, execute, and track projects across the entire lifecycle using SAP Project System (PS) and the in-depth information contained in this comprehensive volume. SAP Project System Handbook explains how to configure PS for optimal performance, design structures and networks, create project blueprints, generate cost estimates and materials demands, and use the latest SAP tools. You will find full details on scheduling work, automating and tracking billing and POs, triggering events, and integrating with most other SAP modules. An invaluable reference to PS transaction codes is also included. Configure and customize SAP Project SystemBuild PS objects, networks, and Work Breakdown StructuresUse customer and service projects to track sales and billingUnderstand Assembly Processing conceptsCreate integrated cost, settlement, and resource plansDevelop financial, workforce, and materials management blueprints Perform resource-related billing using Dynamic Item Processor ProfilesSimulate and automatically generate sales documents, POs, and quotationsManage corporate investments with IM structures and AUCsConstruct timesaving Project, Network, and Milestone TemplatesExtend functionality with the Project Builder, Planning Board, and ProMan
SAP Business Information Warehouse Reporting
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Your Hands-On Guide to SAP Business Information WarehouseGive your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance. Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooksWork with the BEx Analyzer, Web Analyzer, and Query Designer Build queries and reports using the Business Administration WorkbenchAdd attachments and drill-through using Document Integration and RRIFormat and distribute results using Report Designer and Information BroadcasterExtend functionality with Enterprise Portal, Data Modeling, and Visual ComposerDeploy charts, maps, diagrams, and unit of measure conversionsPredict trends and possible outcomes using SBC and Integrated PlanningGenerate HTML pages using Enterprise Reporting and Web Application DesignerCreate BI-based corporate Web and intranet sites using SAP Enterprise Portal
Beginning C# 2008 Databases
This book is for every C# programmer. It assumes no prior database experience and teaches through hands-on examples how to create and use relational databases with the standard database language SQL and how to access them with C#. Assuming only basic knowledge of C# 3.0, Beginning C# 3.0 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers. A comprehensive tutorial on both SQL Server 2005 and ADO.NET 3.0, this book explains and demonstrates how to create database objects and program against them in both T-SQL and C#. Almost every application needs to access a database, and this book concisely teaches all the fundamentals needed---and most that are ever needed---to develop professional database applications.
Business Intelligence for Dummies
You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in making the right decisions about your business. But you've heard at least a dozen definitions of what it is, and heard of at least that many BI tools. Where do you start? Business Intelligence For Dummies makes BI understandable! It takes you step by step through the technologies and the alphabet soup, so you can choose the right technology and implement a successful BI environment. You'll see how the applications and technologies work together to access, analyze, and present data that you can use to make better decisions about your products, customers, competitors, and more. You'll find out how to: Understand the principles and practical elements of BI Determine what your business needs Compare different approaches to BI Build a solid BI architecture and roadmap Design, develop, and deploy your BI plan Relate BI to data warehousing, ERP, CRM, and e-commerce Analyze emerging trends and developing BI tools to see what else may be useful Whether you're the business owner or the person charged with developing and implementing a BI strategy, checking out Business Intelligence For Dummies is a good business decision.
Pro SQL Server 2005 Integration Services
SQL Server 2005 Integration Services (SSIS) is a powerful and widely adopted SQL Server technology. It allows information from a number of data sources to be rapidly integrated together to provide an effective data management, performance and control for system dealing with anything from a few hundred thousand elements to those where multi-billion elements are common. This book offers complete coverage on SQL Server 2005 Integration Services, from using existing components to writing complex Custom Controls with their own User-Interface, all proven by implementation. Written by an author who has been using SSIS since its inception this book uses efficient best practice methods to achieve results for the most demanding user.
Computational Intelligence
Computational Intelligence: An Introduction, Second Edition offers an in-depth exploration into the adaptive mechanisms that enable intelligent behaviour in complex and changing environments. The main focus of this text is centred on the computational modelling of biological and natural intelligent systems, encompassing swarm intelligence, fuzzy systems, artificial neutral networks, artificial immune systems and evolutionary computation. Engelbrecht provides readers with a wide knowledge of Computational Intelligence (CI) paradigms and algorithms; inviting readers to implement and problem solve real-world, complex problems within the CI development framework. This implementation framework will enable readers to tackle new problems without any difficulty through a single Java class as part of the CI library. Key features of this second edition include: A tutorial, hands-on based presentation of the material. State-of-the-art coverage of the most recent developments in computational intelligence with more elaborate discussions on intelligence and artificial intelligence (AI). New discussion of Darwinian evolution versus Lamarckian evolution, also including swarm robotics, hybrid systems and artificial immune systems. A section on how to perform empirical studies; topics including statistical analysis of stochastic algorithms, and an open source library of CI algorithms. Tables, illustrations, graphs, examples, assignments, Java code implementing the algorithms, and a complete CI implementation and experimental framework. Computational Intelligence: An Introduction, Second Edition is essential reading for third and fourth year undergraduate and postgraduate students studying CI. The first edition has been prescribed by a number of overseas universities and is thus a valuable teaching tool. In addition, it will also be a useful resource for researchers in Computational Intelligence and Artificial Intelligence, as well as engineers, statisticians, operational researchers, and bioinformaticians with an interest in applying AI or CI to solve problems in their domains. Check out http: //www.ci.cs.up.ac.za for examples, assignments and Java code implementing the algorithms.
Oracle Database 11g Dba Handbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The Essential Resource for Oracle DBAs--Fully Updated and ExpandedManage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.Plan and deploy permanent, temporary, and bigfile tablespacesOptimize disk allocation, CPU usage, I/O throughput, and SQL queriesDevelop powerful database management applicationsGuard against human errors using Oracle Flashback and Oracle Automatic Undo ManagementDiagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning SetsImplement robust security using authentication, authorization, fine-grained auditing, and fine-grained access controlMaintain high availability using Oracle Real Application Clusters and Oracle Active Data GuardRespond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair AdvisorBack up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and ImportWork with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
Visualizing Data
Enormous quantities of data go unused or underused today, simply because people can't visualize the quantities and relationships in it. Using a downloadable programming environment developed by the author, Visualizing Data demonstrates methods for representing data accurately on the Web and elsewhere, complete with user interaction, animation, and more. How do the 3.1 billion A, C, G and T letters of the human genome compare to those of a chimp or a mouse? What do the paths that millions of visitors take through a web site look like? With Visualizing Data, you learn how to answer complex questions like these with thoroughly interactive displays. We're not talking about cookie-cutter charts and graphs. This book teaches you how to design entire interfaces around large, complex data sets with the help of a powerful new design and prototyping tool called "Processing". Used by many researchers and companies to convey specific data in a clear and understandable manner, the Processing beta is available free. With this tool and Visualizing Data as a guide, you'll learn basic visualization principles, how to choose the right kind of display for your purposes, and how to provide interactive features that will bring users to your site over and over. This book teaches you: The seven stages of visualizing data -- acquire, parse, filter, mine, represent, refine, and interact How all data problems begin with a question and end with a narrative construct that provides a clear answer without extraneous details Several example projects with the code to make them work Positive and negative points of each representation discussed. The focus is on customization so that each one best suits what you want to convey about your data set The book does not provide ready-made "visualizations" that can be plugged into any data set. Instead, with chapters divided by types of data rather than types of display, you'll learn how each visualization conveys the unique properties of the data it represents -- why the data was collected, what's interesting about it, and what stories it can tell. Visualizing Data teaches you how to answer questions, not simply display information.
Microsoft Office Access 2007 VBA
Business Solutions Microsoft(R) Office Access 2007 VBA Develop your Access 2007 VBA expertise instantly with proven techniques Microsoft Office Access 2007 VBA builds on the skills you've already developed in creating database applications and helps you take them to the next level--using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming language. Even if you've never programmed, this book will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before. Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access frequently in their daily work. You have serious work to get done and you can't spend all day reading a computer book. This book teaches you the essential skills you need to automate your databases as quickly as possible. Although written for Access 2007, the techniques and concepts covered will work in most versions of Microsoft Access. Highlights of This Book Include - Navigating within the Visual Basic Editor - Using variables, constants, and data types - Employing built-in functions - Creating procedures - Understanding object-and event-driven coding - Working with arrays - Understanding scope - Working with forms - Using selection controls - Creating reports - Exploring menus, navigation, and ribbons - Using object models - Working with data - Defining database schema - Using the Windows API - Working with XML files - Exploring Access SQL On the Website Download database files used in the book at www.quepublishing.com. Category Office Applications Covers Visual Basic for Applications User Level Intermediate - Advanced Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20+ years, he has designed databases on a wide range of platforms, including dBASE, FoxPro, SQL/DS, Lotus Approach, Lotus Notes, and, for the past 10 years, Microsoft Access. Scott has worked as a consultant, both in-house and freelance, and as a support professional at firms that are among the leaders in their industries. Scott spends some of his free time answering questions at the premier site for Access support: http: //www.utteraccess.com. Brent Spaulding started writing applications about 20 years ago and has utilized Microsoft Access since version 2.0. He looks forward to using Access well into the future. In July 2007, he received the Microsoft MVP award for Access, which recognizes his talent and contributions to the Access community. Front cover bullets: Edit and debug your code Use looping and conditional statements Understand the Access object- and event-driven architecture Automate data entry Learn how to use variables for dynamic automation Create user-friendly applications for others Create custom functions and objects Customize the user interface Manipulate data and objects with code
Oracle Automatic Storage Management: Under-The-Hood & Practical Deployment Guide
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Build and manage a scalable storage infrastructure with Oracle Automatic Storage ManagementStreamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASMDefine, discover, and manage disk storage under Oracle ASM Create external, normal-redundancy, and high-redundancy disk groupsAdd and remove Oracle ASM storage without affecting RDMS instance availabilityLearn how Oracle ASM provides even I/O distribution Work with Oracle ASM directories, files, templates, and aliasesImprove storage performance and integrity using the ASMLIB APISimplify system administration with the Oracle ASM command line interfaceUnderstand key internal Oracle ASM structures and algorithms
Oracle Database 11g New Features
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.FOREWORD by Tom KyteYour Must-Have Guide to Everything New in Oracle Database 11gRealize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade componentsImproved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compressionNew Database Advisors for data recovery and repair, partitioning, and streams performanceNew tuning features, such as Automatic SQL Tuning and SQL Performance AnalyzerEnhancements to Oracle RMAN, including active database duplication and UNDO backup optimizationImproved auditing and security capabilitiesAdvanced BI, data warehousing, and partitioning featuresNew SQL and PL/SQL enhancements
Oracle Database 11g SQL
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Write powerful SQL statements and PL/SQL programsLearn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.Explore SQL Plus and SQL DeveloperUse SQL SELECT, INSERT, UPDATE, and DELETE statementsWrite PL/SQL programsCreate tables, sequences, indexes, views, and triggersWrite advanced queries containing complex analytical functionsCreate database objects and collections to handle abstract dataUse large objects to handle multimedia files containing music and moviesWrite Java programs to access an Oracle Database using JDBCTune your SQL statements to make them execute fasterExplore the XML capabilities of the Oracle DatabaseMaster the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more
Business Intelligence with Microsoft(r) Office Performancepoint(tm) Server 2007
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services. Configure, deploy, and secure all the PerformancePoint componentsCreate KPIs, scorecards, reports, and dashboards with the Dashboard DesignerCreate business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007Enable advanced data analysis with PerformancePoint Server and ProClarity toolsTake advantage of the enhanced analytic capabilities of Excel 2007 Use SQL Server Reporting Services for analyticsAlign performance with organizational objectives
Data Quality Assessment
Imagine a group of prehistoric hunters armed with stone-tipped spears. Their primitive weapons made hunting large animals, such as mammoths, dangerous work. Over time, however, a new breed of hunters developed. They would stretch the skin of a previously killed mammoth on the wall and throw their spears, while observing which spear, thrown from which angle and distance, penetrated the skin the best. The data gathered helped them make better spears and develop better hunting strategies. Quality data is the key to any advancement, whether it's from the Stone Age to the Bronze Age. Or from the Information Age to whatever Age comes next. The success of corporations and government institutions largely depends on the efficiency with which they can collect, organize, and utilize data about products, customers, competitors, and employees. Fortunately, improving your data quality doesn't have to be such a mammoth task. DATA QUALITY ASSESSMENT is a must read for anyone who needs to understand, correct, or prevent data quality issues in their organization. Skipping theory and focusing purely on what is practical and what works, this text contains a proven approach to identifying, warehousing, and analyzing data errors - the first step in any data quality program. Master techniques in: Data profiling and gathering metadata Identifying, designing, and implementing data quality rules Organizing rule and error catalogues Ensuring accuracy and completeness of the data quality assessment Constructing the dimensional data quality scorecard Executing a recurrent data quality assessment
Web Publishing With PHP and Filemaker 9
Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you. In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website! Detailed information on how to... Master web publishing Read and write basic HTML Read and write basic PHP Build a FileMaker database Install and configure FileMaker Server Publish your FileMaker data to the web Work with portals and container fields Repurpose your FileMaker layouts on the web Introduction 1Part I: Basics of Web PublishingChapter 1: How Web Publishing Works 7Chapter 2: Introduction to HTML 17Chapter 3: Introduction to PHP 31Part II: Laying the GroundworkChapter 4: Building a Simple FileMaker File 49Chapter 5: Configuring the Server(s) 67Part III: Publishing FileMaker Data on the WebChapter 6: Viewing FileMaker Data 91Chapter 7: Altering FileMaker Data 115Chapter 8: Working with Related Data (Portals) 137Chapter 9: Working with Images 167Chapter 10: Repurposing a FileMaker Layout on the Web 189Part IV: More InformationAppendix A: Performance Tuning 213Appendix B: Security Concerns 217Appendix C: Error Handling and Prevention 225Appendix D: FileMaker PHP API Reference 231Index 239
Beginning PL/SQL
Beginning PL/SQL is a fast-paced and blissfully short introduction to Oracle's PL/SQL language. PL/SQL is the built-in language that every Oracle developer and database administrator simply must know. This book gets readers up-to-speed on the core of the language without wasting the readers time on esoteric and seldom used syntax.
RMAN Recipes for Oracle Database 11 g
Oracle's backup and recovery tool is called Recovery Manager, or RMAN for short. It's one tool that every database administrator absolutely must know, and know well, because to lose a critical database can be a job-ending event. RMAN Recipes is a task-oriented book providing ready-made and example-based solutions to common (and some not-so-common) backup and recovery operations. The authors respect their reader's time. When the pressure's on, database administrators don't have time for long discussions of theory. They need solutions, and right now. RMAN Recipes delivers, getting right to the point with quick- and easy-to-read, step-by-step solutions that database administrators can implement with confidence.
Oracle Database 10g Performance Tuning Tips & Techniques
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Maintain a High-Performance Oracle Database 10g EnvironmentMonitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.
Microsoft Office Access 2007 Forms, Reports, and Queries
Microsoft Access is a large, intimidating program. Unlike Word or Excel where users can perform basic tasks without much in the way of training, Access presents challenges from the outset. Most users never progress beyond creating simple tables and using Wizards to create basic forms and reports. At the same time, all users - from managers to researchers to administrative assistants - need to know that what they seek is embedded somewhere in their Access tables. Without a more sophisticated knowledge of how to extract and present that data, they are forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions. This book will change all that by giving readers the skills required to extract the data they need (queries), build efficient front-ends for that data (forms), and publish the results in an attractive and easy-to-read format (reports). To that end, this book shuns the big Access picture and instead focuses intently on queries, forms, and reports. This in-depth approach will give the reader the skills and understanding he or she needs to get at the data and prove the old adage that knowledge is indeed power.
Exam Prep CISA
CISA Exam Prep Certified Information Systems Auditor Michael Gregg Your Complete Certification Solution! The Smart Way to Study(TM) In This Book You'll Learn How To: Approach the IS audit process from ISACA's view of IS auditing best practices Relate and apply information security and systems audit best practices to the six CISA job practice areas Understand the IS audit process and learn how to apply best practices to secure an organization's assets Evaluate IT governance to ensure that the organization has the structure, policies, and mechanisms in place to provide sufficient IS controls Minimize risk within an IT/IS environment by using sound security techniques and practices Assess systems and infrastructure lifecycle practices to determine their effectiveness in meeting security requirements and meeting organizational objectives Gain a deeper understanding of the business continuity and disaster recovery process to help minimize risk Protect key informational assets by examining the security architecture and evaluating controls designed for the protection of confidentiality, availability, and integrity Streamline your exam preparations with our exam insights, tips, and study strategies WRITTEN BY A LEADING CISA EXAM EXPERT! Michael Gregg, founder and president of Superior Solutions, Inc., a Houston-based IT security consulting and auditing firm, has more than 20 years experience in information security and risk. He holds two associate degrees, a bachelor's degree, and a master's degree. He presently maintains more than a dozen certifications and is a nine-time winner of Global Knowledge's Perfect Instructor Award. Michael not only has experience in performing security audits and assessments, but also is the author of Que Publishing's Certified Ethical Hacker Exam Prep, CISSP Exam Cram, and is the co-author of Inside Network Security Assessment: Guarding Your IT Infrastructure by Sams Publishing. Introduction Study and Exam Prep Tips Part I: IT Governance and the Audit Process Chapter 1: The Audit Process Chapter 2: IT Governance Part II: System and Infrastructure Lifecycle Management Chapter 3: Lifecycle Management Chapter 4: System Infrastructure Control Part III: IT Service Delivery and Support Chapter 5: Information Systems Hardware and Architecture Chapter 6: Information Systems Used for IT Delivery and Support Part IV: Protection of Information Assets Chapter 7: Protection of Logical Assets Chapter 8: Physical Security Part V: Business Continuity and Disaster Recovery Chapter 9: Business Continuity and Disaster Recovery Part VI: Final Preparation Fast Facts Practice Exam Answers to Practice Exam Questions Glossary Index www.examcram.com ISBN-13: 978-0-7897-3573-7 ISBN-10: 0-7897-3573-3
Access Data Analysis Cookbook
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.
Pro T-sql 2005 Programmer’s Guide
T-SQL is the fundamental language for database programming in SQL Server 2005. All professional SQL Server users need to know it and, even more important, must understand how to use it well. To achieve this they need a convenient single source of information and advice. This book provides that, clearly and comprehensively. Both database administrators and developers will find this highly readable, detailed description of T-SQL an eye-opening and invaluable reference for as long as they work with SQL Server 2005. The author has over a decade's experience designing and administering SQL Server databases.
Beginning SQL Server 2005 Express for Developers
This book is a comprehensive, clear and gentle introduction to all fundamental aspects of SQL Server 2005 Express and the T-SQL database language. It assumes no prior experience in databases or programming and is ideal for any new SQL Server Express user, whatever their use of SQL Server Express. SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Express Edition and then move on to SQL Server 2005. Users can also develop significant real-world solutions in SQL Server 2005 Express Edition and then migrate them to the full version. In fact, for small databases and organizations, the Express Edition is often adequate on its own to support business needs and its user base is rapidly growing.
Expert Mysql
The MySQL database remains one of the hottest open source technologies today, with users flocking by the millions to MySQL.com to download the latest version. As the database has evolved into a product capable of competing with proprietary counterparts such as Oracle and IBM DB2, MySQL has attracted the attention of large scale corporate users who require a high-powered blend of features and performance. Expert MySQL is the first book to delve deep into the MySQL architecture, showing users how to truly make the most of the database through tasks such as the creation of custom storage handlers, optimization of MySQL's query execution, and use of the embedded server product. This book will appeal to any user interested in deploying MySQL in truly high-traffic environments and in situations requiring minimal resource allocation.
Beginning Database Design
The problem of how to design a database is commonly encountered by those not specifically trained and practiced in the art. This book, therefore, is written with the lay person in mind. It is shorter and more readable than the competing book. In clear and simple language, the author uses examples from her real-life experience to highlight the types of problems that can result from poor design, to motivate readers to do good design. She then goes on to provide a sound method that readers can follow in order to produce a good design. While focus is on implementing designs in relational databases such as Microsoft Access, PostgreSQL, MySQL, the author does not forget those readers who will choose to implement their database in a spreadsheet such as Microsoft Excel.
Access 2007 for Starters: The Missing Manual
This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with: Clear explanations Step-by-step instructions Lots of illustrations Larger type Plenty of friendly advice Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
SQL Server 2005 Practical Troubleshooting
Never-Before-Published Insiders' Information for Troubleshooting SQL Server 2005. This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru's Guides to SQL Server, has assembled a "dream team" of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft's own source code. From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You'll find comprehensive, in-depth chapters on - Waiting and blocking - Data corruption and recovery - Memory - Procedure cache issues - Query processing - Server crashes and other critical failures - Service Broker - SQLOS and scheduling - tempdb - Clustering This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Web developers alike. Contents About the Authors ix Preface xii Acknowledgments xiv 1 Waiting and Blocking Issues 1 2 Data Corruption and Recovery Issues 47 3 Memory Issues 137 4 Procedure Cache Issues 183 5 Query Processor Issues 225 6 Server Crashes and Other Critical Failures 273 7 Service Broker Issues 331 8 SQLOS and Scheduling Issues 369 9 Tempdb Issues 411 10 Clustering Issues 425 The Aging Champion 441 Index 445
Microsoft SQL Server 2005: The Complete Reference
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clusteringPowerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0Business Intelligence features, such as Integration Services, data warehousing, and reports
How to Do Everything With Microsoft Office Access 2007
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Maximize the powerful features of the latest release of today's most popular desktop database programHow to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007.Navigate the new user interface with easeDesign a well-organized database using pre-designed templatesEnter and edit data and ensure data validitySort, filter, and print recordsExtract specific information using queriesMaster form and report design basicsAdd charts and graphs to forms and reports easilyOptimize database performance and speedExchange database objects and text files between Access databases
Oracle Database 10g Real Application Clusters Handbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Learn cutting-edge technology from Oracle expertsWritten by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems.Concepts covered are applicable to all previous versions of OracleTuning and troubleshooting tips, providing insight on the most advanced diagnostics availableDetailed coverage of advanced RAC conceptsWorking code for all examples available online
Oracle Database 10g RMAN Backup & Recovery
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The Most Complete Guide to Maximizing Oracle Recovery ManagerDeploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning.Set up, configure, and maintain Oracle Database 10g RMAN Use RMAN recovery catalogs, target database packages, and control filesCentralize backup tape management using Oracle Secure BackupPerform online, offline, and incremental system backupsMonitor and tune performance with Enterprise Manager Grid Control and Database ControlAccomplish complete and partial RMAN database restoresImprove functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage ManagerOvercome human errors using Flashback Versions Query and Transaction QueryCreate clone and standby databases from tape and disc backupsWork with Real Application Cluster (RAC) databases and sync-and-split hardware technologies
FileMaker Pro Design & Scripting for Dummies
Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video
Business Objects XI the Complete Reference
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.This book is a must read for anyone deploying Business Objects It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There's in depth coverage of Designer, security via the Central Management Console, InfoView, Web Intelligence, and Desktop Intelligence. It goes beyond step-by-step instructions to cover how and why in a business context. Transition notes are interspersed for version 5 and 6 customers to understand the biggest changes in XI Release 2. If you drive BI requirements in your company or are a data warehouse program manager, Business Objects administrator, report author or consumer, this book is for you.
