Knowledge of "insider" tips on administering Oracle databases can mean the difference between a secure, smoothly running database and a corporate disaster. This book provides high-end administrative solutions for the day-to-day DBA by leveraging relatively unexplored Oracle features with methods that have proven merit in practical situations.

The definitive book on Oracle's Rdb database.
Written by a team of bestselling database experts, including a principal product architect, this is unquestionably the definitive book on Oracle's Rdb8, the latest version of the powerful database for advanced enterprise applications. Rdb: A Comprehensive Guide, Third Edition teaches administrators, programmers, database designers and IT managers the critical components and functions of the new version 8 and explains how to develop powerful Rdb8 programs. The book specifically addresses new Rdb8 management, tuning and scalability tools and describes the new Rdb/NT Workbench for Windows NT. No other source gives readers the authoritative and timely information provided by Rdb: A Comprehensive Guide, Third Edition.

Only book on Rdb8
Written by Rdb8 experts from Oracle, including the principal product architect
Explains how to use Rdb8 on both Windows NT and OpenVMS

The ultimate beginning-to-end guide for SQL developers building Web-enabled database applications. Contains data tools to help make building Web applications easier for developers. Includes coverage of security issues and building N-tier Web solutions, an important topic in web development today.

This book shows PeopleSoft developers and administrators how to integrate PeopleSoft ERP systems with third party software.

This book is the definitive guide to SQL*Plus, Oracle's interactive query tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, provides a syntax quick reference, and describes how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, use the SQL*Plus administrative features (new in Oracle8i), and much more.

Understanding dBASE5 for Windows is a good tutor for anyone interested in the new Windows version.

From this systematic and comprehensive book, you can learn the basics and features of dBASE as well as the advanced techniques that will make you an expert.

The book presents the basic concepts of using a database, and instructs you to build sophisticated database systems step by step. It is full of valuable tips, tricks and timesaving techniques.

"The Complete HyperCard Handbook" is your best choice for learning and mastering HyperCard whether you are a professional or a beginner.

Macintosh products expert Danny Goodman introduces HyperCard 2.2's powerful new features to you.

AppleScript support; Improved user interface design elements; Enhanced HyperTalk scripting language; Convenient Color Tools for applications design; Creating double-clickable applications

And shares his experience: using HyperCard for multimedia applications; debugging HyperTalk scripts; applying Apple events; using AppleScript with a multiuser FileMaker database

This volume is for those interested in methods and tools for improving the development of educational hypermedia on a large scale. Interactive multimedia or hypermedia is one of the technologies which is most influencing the educating and training of people. This book shows how coordination and reuse pertain to the development of courseware, which provides new opportunities and challenges to researchers, practitioners, and designers from disciplines such as computer science, education, library science, communication and psychology.

This new, advanced supplement to the 16-group program described in The Adolescent Self provides advanced exercises and techniques for adolescents who have mastered those taught in the original PRISM Workbook.

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 Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

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.

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. * Implement new best practices for effective use of SSIS * Work through tutorials for hands-on learning of complex techniques * Read case studies that illustrate the more advanced concepts * Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

Proven database optimization solutions-fully updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips & Techniques thoroughly explains the latest monitoring, troubleshooting, and optimization methods. You will find out how to find and fix bottlenecks, configure storage devices, use Oracle Enterprise Manager, and develop and execute effective queries. Start-to-finish instruction is provided for writing faster, cleaner SQL and PL/SQL code and building radically more efficient, secure, and durable systems. In-depth details throughout highlight new options available for tuning both Oracle Database 12c and 12c Release 2. Testing, reporting, and security enhancements are also covered in this hands-on guide from Oracle Press. * Covers all of the new features in Oracle Database 12c Release 2 * Offers expert advice, proven strategies, and detailed examples * Written by an Oracle Certified Master, highly-respected speaker, and bestselling author

Master Oracle Fusion General Ledger and Fusion Financials Accounting Hub Maintain a centralized, highly automated financial processing platform across your organization using Oracle Fusion Applications General Ledger and Financial Accounting Hub. This hands-on Oracle Press guide thoroughly explains the deployment process and illustrates every technique through a start-to-finish case study. Find out how to plan and carry out an end-to-end implementation, integrate data from disparate sources, build budgets and journals, handle ledger and subledger accounting, and distribute mission-critical information through reports and dashboards. Implementing Oracle Fusion Applications General Ledger & Financials Accounting Hub offers complete coverage of security, auditing, and consolidation. * Explore the capabilities of Oracle Fusion Applications General Ledger and Financials Accounting Hub * Configure, perform, and track a new implementation * Construct enterprise and financials reporting structures * Work with currencies, calendars, budgets, ledgers, and journals * Secure your system through authentication and authorization * Meet your enterprise's consolidation and elimination requirements * Transform and load data from external applications * Handle General Ledger revaluation, allocation, and period close * Build feature-rich financial reports and analysis dashboards

Master Oracle Database 12c Release 2's powerful In-Memory option Maximize database performance and dramatically cut transaction processing time using Oracle Database 12c Release 2's In-Memory feature and the detailed instruction and best practices offered in this Oracle Press guide. You will discover how to exponentially improve efficiency and enable smarter, faster, more informed business decisions enterprise-wide. Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance starts by teaching, step-by-step, how to configure the software and construct In-Memory enabled databases. From there, you will discover how to deliver optimized analytics, use In-Memory Advisor, effectively secure mission-critical data, and distribute real-time, actionable business intelligence. This hands-on resource also provides thorough coverage of Oracle Real Application Clusters and Oracle Multitenant integration. * Offers proven implementation tips drawn from the author's experience * Features real-life case studies not available elsewhere * Written by an Oracle enterprise architect and well-known speaker

Master the multitenant features of Oracle Database 12c Maintain a scalable, highly available enterprise computing platform and dramatically reduce complexity by learning to leverage the powerful new multitenant tools and cloud enhancements available in Oracle Database 12c. You will get hands-on, detailed coverage of key areas such as installation, creation, configuration, and day-to-day administration. Oracle Database 12c Release 2 Multitenant teaches, step-by-step, how to implement and manage multitenant configurations across IT frameworks of all types and sizes. Special attention is given to new features built for both public and private clouds, including Database as a Service (DBaaS) functionality and cloud-based security. Advanced topics are also fully explained, including backup and recovery, data guard, flashback, and resource manager. * Provides targeted best practices and tips for effective administration * Offers start-to finish coverage of both simple and complex installations * Authored by a team of Oracle Masters with a combined 40+ years of experience