The first book to offer the comprehensive insights professionals need to build enterprise-class OLAP solutions with Analysis Services 2008 rapidly and efficiently. Using this text, developers, architects, and DBA can create solutions that uncover new opportunities and solve real business problems.
Helps business decision-makers and Business Intelligence professionals get the most value out of their BI investments. This book explains the various components of a BI architecture. It shows how to choose the appropriate tools and technologies, and how to roll out a BI strategy throughout the organization.
A hands-on guide to leveraging NoSQL databases NoSQL databases are an efficient and powerful tool for storing and manipulating vast quantities of data. Most NoSQL databases scale well as data grows. In addition, they are often malleable and flexible enough to accommodate semi-structured and sparse data sets.
Reveals how to combine PeopleSoft's PeopleTools with modern languages, technologies, and methodologies. This guide helps you to hone intermediate to advanced PeopleSoft development skills. It covers Java, JavaScript, and Ajax. It includes tips for improving the PeopleSoft development process with Test Driven Development (TDD).
SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the internet. This book contains the information about these attacks. It helps you understand what SQL injection is and how it works. It also helps you create exploits using SQL injection, and avoid the dangers of these attacks.
Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues.
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required.
There is a lot at stake for administrators taking care of servers, since they house sensitive data like credit cards, social security numbers, medical records, and much more. This title helps to learn about the potential attack vectors that can be used to break into your SQL Server database, and how to protect yourself from these attacks.
Get started with the fundamentals of Transact-SQL and learn how to write efficient and powerful database queries. With this hands-on guide, you'll gain a solid understanding of T-SQL and good programming practices through the right balance of conceptual and practical content.
A guide to SQL Server, Microsoft's high-performance database and data analysis software package. It helps you understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate the features of the 2008 release.
If you're in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system.
Shows database developers and administrators and those who use database application how to get up to speed fast. This title offers an introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance. It covers the various features of the 'Yukon' release.
This is the definitive guide for Symbian C++ developers looking to use Symbian SQL in applications or system software. Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Structured Query Language (SQL) tutorial.
If you have never programmed with T-SQL but have some background programming knowledge and experience, this book presents you with an overview of SQL Server query operations and tools used with T-SQL, Microsoft's implementation of the SQL database query language.
A study tool and on-the-job reference for the MCITP SQL Server 2005 Database Administration exams. It covers three of the Microsoft Certified IT Professional exams for SQL Server 2005. It provides details on database configuration, T-SQL, security, and high availability. It is filled with case studies, checklists, and technical sidebars.
Sybase Adaptive Server Enterprise 15 is a high-performance, mission-critical database management system designed to meet the increasing demands of large databases and high-transaction volumes, while providing a cost-effective database management system. This book focuses on the many enhancements in Sybase ASE 15.
SQL (Structured Query Language) is the worldwide standard programming language for managing data in a relational database management system (DBMS). This title provides students, programmers, accountants, and others who need to manage data in a DBMS with a practical overview of the most common database management tasks.
When developers build software, they're able to keep track of all the different versions and all the components they use with Software Configuration Management (SCM) systems. One of the more popular SCM products is Perforce. This book offers an introduction to Perforce. It also serves as a resource for those familiar with this SCM product.
By collecting and detailing the diverse standards of myriad industries, and giving a declaration for the units that can be used in an SQL schema, this book enables readers to write and implement portable data that can interface to many external application systems, allowing readers to cross business boundaries and move up the career ladder.
Aims to cover the internals of the PostgreSQL open source database chapter, offering a code-based approach explaining how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This guide helps in building, programming and administering the PostgreSQL open-source database system.
Author and developer Dewson shows readers the way from beginner to SQL Server 2008 professional, teaching them how to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks.
The only book professionals need to harness the power that Microsoft SQL Server Integration Services provides, this guide features clear, concise explanations and samples that will allow readers to grasp a clear understanding of working in the Integration Services environment.
Contains material on the 2008 release of SQL Server Integration Services (SSIS). This book show developers how to master the 2008 release of SSIS. It covers data warehousing using SSIS, fresh methods for managing the SSIS platform, and improved techniques for ETL operations.
Offers coverage on SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and, its extensive performance data collection.
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it. This book helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It is suitable for non-technical and experienced folks alike.
Thoroughly updated to reflect Microsoft SQL Server 2008's newest features and best practices, the latest edition of this bestselling independent reference to Microsoft SQL Server presents comprehensive, real-world guidance for professionals who work with SQL Server.
The growing popularity of Apache Cassandra rests on this database's ability to handle very large data sets that include hundreds of terabytes. This hands-on guide provides the details and practical examples you need to understand Cassandra's non-relational database design and how to take advantage of it in a production environment.
Offers coverage of Oracle E-Business Suite Self Service modules, including iProcurement, iSupplier, iExpense, and iReceivables. This book covers: Role of Self Service Modules in an Organization; Implementation Considerations; iProcurement Setup; Using iProcurement; iProcurement Processing; iSupplier Setups; and, iSupplier Processing.
Covers the fundamentals of MySQL database management, including MySQL's approach to basic database features and functions - as well as SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. This title also covers such topics as MySQL server tuning, managing storage engines, and managing users.
Enables you to discover how to solve real-world BI problems by leveraging a slew of powerful new Analysis Services features and capabilities. This book covers SQL Server 2011 Analysis Services and includes PowerPivot, a tool for performing analysis of data. It explores real-world scenarios to help developers build comprehensive solutions.
Professional Microsoft SQL Server 2011 Integration Services An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2011 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005.
A platform-independent tutorial on the basic principles of relational database design, this book helps you create efficient and effective relational databases. This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process.
Offers details on the innovative features and benefits available in SQL Server 2008. This guide provides an overview of the enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements. It is suitable for decision-makers, developers, and DBAs preparing for upgrades or migration.
A workbook that supplements and builds on the "Oracle Database 11g PL/SQL Programming". It helps you learn essential Oracle PL/SQL skills through real-world labs, examples, exercises, and projects. It covers the enhancements and improvements made to PL/SQL with the release of Oracle Database 11g.
Explains how to create, manage, and deliver traditional and interactive reports with SQL Server 2008 Reporting Services. This guide covers the report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. It contains more than 60 practical, reusable report and code samples.
A professional approach for career programmers, the book combines the basics of client/server programming with a practical, corporate-based introduction to Access 97. Its examples show business applications, giving professional programmers the real-world perspective they need.
Covering everything from design logic that business users will understand all the way to the physical implementation of the design in an SQL Server database, this title teaches effective and scalable database design techniques in an SQL Server environment.
Make information work for you with the FileMaker Pro 11 desktop database and FileMaker Pro 11: The Missing Manual. This book helps you get started, build your database, and produce results, whether you're running a business, pursuing a hobby, or planning your retirement.
Offers coverage of the material on three of the Microsoft Certified IT Professional exams for SQL Server 2005, which test the ability of certification candidates to design a secure, stable, enterprise SQL Server database solution. This book includes case studies, checklists, technical sidebars, and real-world examples.
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL provides several features that can protect you from outages, whether you're running directly on the hardware, on virtual machines, or in the cloud.
This manual covers information from creating a database to publishing it on the Web. It describes building and working with a database, maintaining it, building tables and making queries, creating reports, and using Access 2000's many wizards and shortcuts.
Readers will start their journey by seeing what they need to know about T-SQL--without needless theory and filler. By putting together real-world projects step by step, readers will gain hands-on experience on writing code for outstanding applications.
Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions. This work also explains reporting services architecture and business intelligence, and teaches the fundamentals of designing reports through the use of careful planning considerations.
Whether you handle Microsoft[registered] SQL Server[registered] 2008 and SQL Server[registered] 2008 R2 administration for 50 users or 5000, this guide focuses on what you need to do to get the job done quickly. It helps you get facts to: plan, deploy, and configure SQL Server[registered] 2008 R2; and perform backups and recovery.
Helps you implement database clustering and mirroring solutions. This book features practical management procedures and realistic case studies, and details the database and server failure prevention techniques for SQL Server 2005. It includes practical steps to ensure zero database loss, avoid system downtime, and provide instant data backups.
Provides details on creating scorecards, dashboards, and analytics. This guide shows how to integrate PerformancePoint with Microsoft Office 2007 and SQL Server 2005 Reporting Services. It includes coverage of the financial planning, reporting, security, and delivery tools available in PerformancePoint 2007.
Shows how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes within Microsoft's Business Intelligence stack. This book contains more than 300 downloadable MDX queries that can be immediately applied across a wide variety of business intelligence-related problems.
Covering the relational database model, this work uses different engines to illustrate the model. It enables the readers to apply the model using their preferred database engine. It shows how simple and useful databases can be. It contains real world examples which show how to manage data efficiently.
A book-and-video package for learning Microsoft SQL Server Integration Services. It introduces the Microsoft SQL Server 2008 Integration Services (SSIS). It includes three components: a description of how each SSIS feature or process works; a tutorial that walks you through the process; and a video lesson that demonstrates it.
High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential.
A guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL. It covers everything from basic program structure through advanced techniques and includes coverage of optimization and troubleshooting. It shows developers how to take advantage of various facets of the SQL PL language and development environment.
FileMaker Pro is an award-winning database program for managing people, projects, images, assets, and other information. Covering FileMaker for Windows and Macintosh, this book shows you how to: get FileMaker running; import and organize information; design relational databases; automate processes with scripting; customize FileMaker Pro; and more.
Covers SAP ERP Central Component 5.0 and 6.0. This book focuses on the implementation of functionality related to the Sales and Distribution (SD) module. It is suitable for SAP professionals who desire to utilize the SD module to its fullest capability by referring to time saving practical advice and tips.
What is this book about? With help from Microsoft ASP. NET insider Bradley Millington, John Kaufman covers both VB. NET and C coding for ASP. NET databases so you don't have to decide up front which language you want more and retailers no longer have to manage inventory on separate language versions.
SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. This guide to designing effective solutions for data cleansing, ETL, and file management with SSIS 2008 demonstrates how to integrate data from a variety of data sources.
Delivers a range of BI capabilities - reporting, analysis, scorecarding, dashboards, business event management, and data integration, on a single, proven architecture. This guide offers BI developers and architects, consultants, IT managers, and end-users coverage of various product's versatile features.
Offering comprehensive coverage on FileMaker Pro 10, this In Depth guide gives users the advice and techniques that they need to get the job done. It provides specific, tested, and proven solutions to the problems users run into every day--things other books ignore or oversimplify.