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)

Here is an invaluable overview of all the cutting-edge features of Oracle’s latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle’s free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

This authorized guide from Oracle Press explains how to administer Oracle9i on all of the major UNIX platforms, including Solaris, HP-UNIX and IBM-UNIX, and Linux. Inside, youll find proven techniques and UNIX scripts that can be used to perform dozens of UNIX-related tasks.

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.

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.

Prepare for Microsoft Exam 70-764-and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. Focus on the expertise measured by these objectives: * Configure data access and auditing * Manage backup and restore of databases * Manage and monitor SQL Server instances * Manage high availability and disaster recovery This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access. About the Exam Exam 70-764 focuses on skills and knowledge required for database administration. About Microsoft Certification Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning

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

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 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

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 authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, offering the most up-to-date information This fully updated volume lays out the easiest, fastest, and most effective methods of deploying RMAN in Oracle Database environments of any size. Keeping with previous editions, this book teaches computing professionals at all skill levels how to fully leverage every powerful RMAN tool and protect mission-critical data. Oracle Database 12c RMAN Backup and Recovery explains how to generate reliable archives and carry out successful system restores. You will learn to work from the command line or GUI, automate the database backup process, perform Oracle Flashback recoveries, and deploy third-party administration utilities. The book features full details on cloud computing, report generation, performance tuning, and security. Offers up-to-date coverage of Oracle Database 12c new features Examples and workshops throughout walk you through important RMAN operations

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 Effective Visual Solutions of BI DataCowritten by an Oracle ACE Director and an expert in data visualization design specializing in BI and analytics, Data Visualization for Oracle Business Intelligence 11g reveals best practices for presenting data-driven insights with graphs, tables, maps, dashboards, and other methods that will immediately enhance corporate decision-making. Throughout the book, the principles of effective design are emphasized. Leverage the power of this comprehensive business intelligence platform to deliver rich visualizations of business information across the enterprise. Create well-organized tables and pivot tables Convey data insights with line, bar, pie, waterfall, radar, and other graphs Configure MapViews so that you can provide interactive maps and spatial analysis capabilities Build advanced visualizations, including trellis charts, gauges, R images, jQuery sparklines, and more Use Oracle Business Intelligence Publisher to create pixel-perfect reports from various data sources Design effective, interactive BI dashboards Use the Oracle Scorecard and Strategy Management module to measure, evaluate, and manage key performance indicators Make smart color choices using data science tools

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. Master Oracle SOA Suite 12cDesign, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this practical resource. Get started with the Oracle SOA Suite 12c development and run time environment Deploy and manage SOA composite applications Expose SOAP/XML REST/JSON through Oracle Service Bus Establish interactions through adapters for Database, JMS, File/FTP, UMS, LDAP, and Coherence Embed custom logic using Java and the Spring component Perform fast data analysis in real time with Oracle Event Processor Implement Event Drive Architecture based on the Event Delivery Network (EDN) Use Oracle Business Rules to encapsulate logic and automate decisions Model complex processes using BPEL, BPMN, and human task components Establish KPIs and evaluate performance using Oracle Business Activity Monitoring Control traffic, audit system activity, and encrypt sensitive data

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.

Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in this Oracle Press guide. Through clear explanations and practical examples, a team of Oracle experts shows how to assimilate data from disparate sources into a single, unified view. Find out how to transform data in real time, handle replication and migration, and deploy Oracle Data Integrator and Oracle GoldenGate. Oracle Data Integration: Tools for Harnessing Data offers complete coverage of the latest "big data" hardware and software solutions. * Efficiently move data both inside and outside an Oracle environment* Map sources to database fields using Data Merge and ETL * Export schema through transportable tablespaces and Oracle Data Pump* Capture and apply changes across heterogeneous systems with Oracle GoldenGate* Seamlessly exchange information between databases using Oracle Data Integrator* Correct errors and maximize quality through data cleansing and validation* Plan and execute successful Oracle Database migrations and replications* Handle high-volume transactions with Oracle Big Data Appliance, Oracle NoSQL, and third-party utilities

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

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, Current Oracle DBA ResourceMaintain a high-performance Oracle Database using the best practices and expert techniques in this Oracle Press guide. Oracle Database 12c DBA Handbook is thoroughly updated to cover the new features and utilities, including the multitenant architecture, Oracle Database In-Memory option, and cloud enhancements. Real-world examples for every major configuration are included. You'll learn how to successfully manage a highly available, robust, secure, and extensible Oracle enterprise database environment. Upgrade to Oracle Database 12c Plan and manage tablespaces Maximize database performance using effective physical database layouts and storage management methods Monitor disk space used by database objects Manage transactions with undo tablespaces Implement expert performance-tuning techniques Increase query speed using the new Oracle Database In-Memory option Manage database security through authentication, authorization, and auditing Take full advantage of the multitenant database architecture Enable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data Guard Perform backup and recovery with Oracle Recovery Manager Manage distributed databases and VLDBs

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 Databases with Oracle SQL Developer Data ModelerIn this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler-the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book. Configure Oracle SQL Developer Data Modeler Perform requirement analysis Translate requirements into a formal conceptual data model and process models Transform the conceptual (logical) model into a relational model Manage physical database design Generate data definition language (DDL) scripts to create database objects Design a data warehouse database Use subversion for version control and to enable a multiuser environment Document an existing database Use the reporting tools in Oracle SQL Developer Data Modeler Compare designs and the database

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 Next-Generation In-Database Predictive Analytics Applications with Oracle Data Miner"If you have an Oracle Database and want to leverage that data to discover new insights, make predictions, and generate actionable insights, this book is a must read for you! In Predictive Analytics Using Oracle Data Miner: Develop & Use Oracle Data Mining Models in Oracle Data Miner, SQL & PL/SQL, Brendan Tierney, Oracle ACE Director and data mining expert, guides you through the basic concepts of data mining and offers step-by-step instructions for solving data-driven problems using SQL Developer's Oracle Data Mining extension. Brendan takes it full circle by showing you how to deploy advanced analytical methodologies and predictive models immediately into enterprise-wide production environments using the in-database SQL and PL/SQL functionality. Definitely a must read for any Oracle data professional!" --Charlie Berger, Senior Director Product Management, Oracle Data Mining and Advanced Analytics Perform in-database data mining to unlock hidden insights in data. Written by an Oracle ACE Director, Predictive Analytics Using Oracle Data Miner shows you how to use this powerful tool to create and deploy advanced data mining models. Covering topics for the data scientist, Oracle developer, and Oracle database administrator, this Oracle Press guide shows you how to get started with Oracle Data Miner and build Oracle Data Miner models using SQL and PL/SQL packages. You'll get best practices for integrating your Oracle Data Miner models into applications to automate the discovery and distribution of business intelligence predictions throughout the enterprise. Install and configure Oracle Data Miner for Oracle Database 11g Release 11.2 and Oracle Database 12c Create Oracle Data Miner projects and workflows Prepare data for data mining Develop data mining models using association rule analysis, classification, clustering, regression, and anomaly detection Use data dictionary views and prepare your data using in-database transformations Build and use data mining models using SQL and PL/SQL packages Migrate your Oracle Data Miner models, integrate them into dashboards and applications, and run them in parallel Build transient data mining models with the Predictive Queries feature in Oracle Database 12c

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 New and Improved Features of Oracle Database 12cWritten by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you'll find everything you need to know to get up and running quickly on Oracle Database 12c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements