Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

Dieses Buch erlautert Theorie und Praxis zu relationalen Datenbanken Was sind relationale Datenbanken? Die Antwort darauf geben die theoretischen Grundlagen und Praxisbeispiele in diesem Buch. Zunachst erlautert Thomas Studer die mathematisch prazise Darstellung des relationalen Modells und die relationale Algebra. Daneben widmet er sich der Datenbanksprache SQL und schafft damit den Praxisbezug. Die zahlreichen Beispiele auf Basis der open-source Datenbank PostgreSQL erleichtern die Anwendung. Dieses Buch erklart die grundlegenden Prinzipien des Schemaentwurfs und Normalformen fundiert und praxisnah und verbindet die relationale Datenbanktheorie mit Datenbankdesign. Studer hat aktuelle Entwicklungen im Blick Die vorliegende Auflage ist umfassend aktualisiert und dem aktuellen Kenntnisstand angepasst. Studer widmet sich in diesem Buch den folgenden Teilaspekten relationaler Datenbanken: Logische und physische Query-Optimierung Isolation von serializable Snapshots Zerlegung der dritten Normalform in die Boyce-Codd Normalform Rollen und Berechtigungen SQL als Sprache zur Datendefinition und Datenmanipulation Sicherheitsrichtlinien auf Zeilenebene Durch die nachhaltige Verbindung von Theorie und Praxis eignet sich das Buch "Relationale Datenbanken" fur: Studierende aus den Bereichen (Wirtschafts-)Informatik Praktiker wie Softwareentwickler, Systemadministratoren oder Fachinformatiker Besuchen Sie uns online und entdecken Sie die zahlreichen Begleitmaterialien zu diesem Buch, die alle frei zuganglich sind.

This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who are not getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

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 2007 Maximize 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 components Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007 Enable advanced data analysis with PerformancePoint Server and ProClarity tools Take advantage of the enhanced analytic capabilities of Excel 2007 Use SQL Server Reporting Services for analytics Align performance with organizational objectives

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. Extract and analyze mission-critical enterprise data using Microsoft Office 2007 This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work. Create Excel PivotTables and PivotCharts and apply Conditional Formatting Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting Connect external data to Excel using Office Data Connections and SharePoint Create SharePoint dashboards that display data from multiple sources Add Key Performance Indicators and Excel Services reports to your dashboards Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams Generate integrated PerformancePoint Scorecards Create Visio PivotDiagrams and Windows Mobile spreadsheets All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book's title to download the examples.

This book is written in a recipe-based style packed full of practical tips and techniques to help you analyse multidimensional data stored in SSAS 2012 cubes. If you need to master MDX queries in SSAS, then this book is for you!If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you. This book is also an essential resource for report developers who need to access the multidimensional cubes through the MDX language. The book assumes you have some basic working knowledge of MDX and a basic understanding of dimensional modelling and cube design.

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.Deploy and Maintain an Integrated MDS Architecture Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012Master Data Services, Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide. Install Microsoft SQL Server 2012 Master Data Services Build custom MDS models and entityspecific staging tables Load and cleanse data from disparate sources Logically group assets into collections and hierarchies Ensure integrity using versioning and business rules Configure security at functional, object, and attribute levels Extend functionality with SOA and Web services Facilitate collaboration using the MDS Excel Add-In Export data to subscribing systems through SQL views

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. UPGRADE TO THE NEW GENERATION OF DATABASE SOFTWARE FOR THE ERA OF BIG DATA!If big data is an untapped natural resource, how do you find the gold hidden within? Leaders realize that big data means all data, and are moving quickly to extract more value from both structured and unstructured application data. However, analyzing this data can prove costly and complex, especially while protecting the availability,performance and reliability of essential business applications. In the new era of big data, businesses require data systems that can blend always-available transactions with speed-of-thought analytics. DB2 10.5 with BLU Acceleration provides this speed, simplicity, andaffordability while making it easier to build next-generation applications with NoSQL features, such as a mongo-styled JSON document store, a graph store, and more. Dynamic in-memory columnar processing and other innovations deliver faster insights from more data, and enhanced pureScale clustering technology delivers high-availability transactions with application-transparent scalability for business continuity. With this book, you'll learn about the power and flexibility of multiworkload, multi-platform database software. Use the comprehensive knowledge from a team of DB2 developers and experts to get started with the latest DB2 trial version you can download at ibm.com/developerworks/downloads/im/db2/. Stay up to date on DB2 by visiting ibm.com/db2/.

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. Essential Microsoft SQL Server 2012 Skills Made EasyGet up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. Install, configure, and customize SQL Server 2012 Create and modify database objects with Transact SQL statements Write stored procedures and user-defined functions Handle backup and recovery Automate administrative tasks Tune your database system for optimal performance, availability, and reliability Implement security measures using authentication, encryption, and authorization Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools Store, display, and query XML documents Manage spatial data Query documents using MS Full-Text Search (FTS)

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 only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances

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. 400+ ready-to-use, powerful SQL queriesLearn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications. Enter, maintain, and retrieve database data Search records using the Where clause Sort SQL query results with the Order By clause Create tables and perform joins on tables Perform set operations using Union, Intersect, and Except Group data and produce totals with the Group By clause Manipulate and transform data using built-in functions Create reusable views and user-defined functions Use stored procedures to change SQL dynamically based on conditional factors Create, maintain, and secure database objects with DDL and DCL Deliver SQL query results to end users

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. Extreme Availability and Scalability--Up and Running With DB2 pureScaleDB2 is a leading-edge hybrid data server that offers optimum storage, scalability, and availability. DB2 pureScale is a new technology primarily optimized for scale-out transactional processing clusters in an active-active manner. This succinct guide will show you how DB2 with pureScale can deliver transparent application scalability, the ability to deliver agile-like computing to your transaction systems, and extreme availability. This book, together with IBM DB2 9 New Features (McGraw-Hill, 2007) and Break Free with DB2 9.7 (McGraw-Hill, 2009), provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try the new features by downloading DB2 Express-C 9.7--it is free to develop, deploy, and distribute (with no user and database size limitations) and features pureXML technology. Go to ibm.com/db2/express. Discover the benefits your business can achieve with the agility provided by DB2 pureScale Find out how applications can be transparently scaled Reduce the risk and cost of business growth through umlimited capacity

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. Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

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 easiest way to set up a PostgreSQL database server on Windows Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database. Install and configure PostgreSQL 8 on Windows Customize your system using the configuration files Work with the utilities Administer your database from the pgAdmin III graphical interface Use the psql command line program to manually execute SQL commands Take advantage of built-in functions or create your own stored procedures and triggers Implement tested security measures Maintain optimal database performance Access a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQL Create .NET, Visual C++, and Java applications that interface with your PostgreSQL server

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 and Deliver PeopleSoft Enterprise Resource Planning Solutions Develop data-driven Oracle PeopleSoft applications and business intelligence reports with help from the expert advice in this Oracle Press guide. PeopleSoft Developer's Guide for PeopleTools & PeopleCode shows you how to build and enhance PeopleSoft modules that maximize return on investment. Set up PeopleSoft Pure Internet Architecture, create PeopleCode projects, integrate HTML and Web features, and create reports with Oracle XML Publisher. You will also learn how to use COBOL, SQR, PeopleSoft Application Engine, and Middleware integration. Install and configure PeopleSoft Pure Internet Architecture Work with PeopleCode components, objects, and classes Build pages and modules using the PeopleTools application designer Add HTML and Web elements in PeopleCode Implement code on the middle tier tools and work with process manager Execute powerful batch processes with application engine Generate detailed reports using Oracle XML Publisher and SQR Debug, secure, and optimize your PeopleSoft applications

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. Get Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. Set up, configure, and maintain SQL Server 2008 Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functions Optimize database performance, availability, and reliability Implement solid security using authentication, encryption, and authorization Automate tasks using SQL Server Agent Create reliable data backups and perform flawless system restores Use all-new SQL Server 2008 Business Intelligence, development, and administration tools Learn in detail the SQL Server XML technology (SQLXML)

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 ERP Sales & Distribution Written by senior SAP consultant Glynn Williams, Implementing SAP ERP Sales & Distribution is packed with tested, time-saving tips and advice. Learn how to use SAP ERP Central Component 5.0 and 6.0 to create sales documents and contracts, control material and customer master data, schedule deliveries, and automate billing. You'll also find out how to deliver robust financial and transactional reports, track customer and credit information, and interoperate with other SAP modules. Configure and manage the SAP ERP SD module Track sales, shipping, and payment status using master records Create multi-level sales documents and item proposals Develop contracts and rebate agreements Deliver materials and services requirements to the supply chain Plan deliveries, routes, and packaging using Logistics Execution Perform resource-related, collective, and self billing Generate pricing reports, incompletion logs, and hierarchies Handle credit limits, payment guarantees, and customer blocks Integrate user exits, third-party add-ons, and data sharing Configure pricing procedures and complex pricing condition types

Gain the Competitive Edge with the Ultimate Resource on BusinessObjects XI Release 2.

. Publish actionable business reports across your enterprise using BusinessObjects XI and the detailed information contained in this one-stop resource. "BusinessObjects XI: The Complete Reference" explains, step-by-step, how to design and build powerful universes, integrate security, execute efficient queries, and distribute the results..

. You'll learn how to create an implementation strategy that fits your business goals, define and manage users, and integrate your reports into Web and Windows applications. All of the new and updated features of BusinessObjects XI Release 2 are covered in full detail, including the new architecture, Designer, security through the Central Management Console, InfoView, Web Intelligence, Desktop Intelligence, report scheduling, and auditing usage..

. Develop a visionary BusinessObjects XI deployment strategy. Migrate existing deployments to BusinessObjects XI Release 2. Use Designer to create robust universes aligned with the business goals that empower users to answer their own questions. Design and implement security policies that fit your company's needs. Monitor system usage and develop deployment practices for mission-critical BI. Translate complex business questions into simple, efficient Web Intelligence queries. Design reports that facilitate insight with richly formatted tables, charts, alerters, and report formulas. Reach more users with the power of interactive reports to dynamically sort, filter, rank, and drill through to detail at a simple mouse-click

CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS.

. Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. "Microsoft SQL Server 2005 Developer's Guide" explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth -- including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler..

. ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS. Use SQL Server Management Studio and Business Intelligence Development Studio. Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML). Create custom database objects with .NET CLR. Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET. Develop and deploy SQL Server Integration Services packages. Design enterprise reports using Reporting Services and Report Builder. Integrate cross-platform data using XML and Web services. Extend SQL Server manageability using SQL Management Objects (SMO)

Most modern-day organizations have a need to record data relevant to their everyday activities and many choose to organise and store some of this information in an electronic database. Database Systems provides an essential introduction to modern database technology and the development of database systems. This new edition has been fully updated to include new developments in the field, and features new chapters on: e-business, database development process, requirements for databases, and distributed processing. In addition, a wealth of new examples and exercises have been added to each chapter to make the book more practically useful to students, and full lecturer support will be available online.

Maintaining the advanced technical focus found in Developing Essbase Applications, this second volume is another collaborative effort by some of the best and most experienced Essbase practitioners from around the world. Developing Essbase Applications: Hybrid Techniques and Practices reviews technology areas that are much-discussed but still very new, including Exalytics and Hybrid Essbase. Covering recent improvements to the Essbase engine, the book illustrates the impact of new reporting and analysis tools and also introduces advanced Essbase best practices across a variety of features, functions, and theories. Some of this book's chapters are in the same vein as the previous volume: hardware, engines, and languages. Others cover new ground with Oracle Business Intelligence Enterprise Edition, design philosophy, benchmarking concepts, and multiple client tools. As before, these subjects are covered from both the technical and best practice perspectives. This updated volume continues in the tradition of its bestselling predecessor by defining, investigating, and explaining Essbase concepts like no other resource. It also includes use cases that transform abstract theory into practical examples you can easily relate to your own Essbase environment. Illustrating the recent expansion of Essbase functionality, this book provides the up-to-date understanding you need to explore the full depth of the Essbase technology stack. Although the book presents detailed tutorial chapters that can be read on their own, reading the entire book will provide you with a similar understanding as some of the most experienced Essbase practitioners from around the world.