Oracle Database 11g Release 2 High Availability
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.Leverage Oracle Database 11g Release 2 High Availability FeaturesProtect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource.Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier versionBuild test clusters and hosts using Oracle VMWork with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File SystemCreate synchronized standby databases using Oracle Data GuardReliably archive and restore data with Oracle Recovery ManagerUse Oracle Flashback to identify and undo user errorsConfigure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment
Achieving Extreme Performance With Oracle Exadata
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 MachineWork with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource ManagerUnderstand Oracle Exadata Database Machine balanced hardware architectureArchitect, administer, and monitor Oracle Exadata Storage ServersDeploy data warehouses on the Oracle Exadata Database MachineRun online transaction processing (OLTP) workloads on the Oracle Exadata Database MachineConsolidate databases with and migrate databases to the Oracle Exadata Database Machine
Oracle CRM on Demand Embedded Analytics
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.Link and Embed Oracle CRM On Demand ReportsIntegrate business intelligence directly into day-to-day business processes by presenting analytic reports to end users in applications. Oracle CRM On Demand Embedded Analytics shows you how to link and embed reports throughout Oracle CRM On Demand. This Oracle Press guide explains how to plan, design, and develop reports; make them available through hyperlinks; and embed reports in a variety of locations easily accessible to end users. Real-world examples and time-saving tips are included throughout this practical resource.Navigate the report development environment within Oracle CRM On DemandConfigure administrative settings to access report development and embedding toolsDesign reports for linking and embedding in applicationsFormat columns, filter data, and add and edit views, including pivot tables and pivot chartsAdd link functionality to Oracle CRM On Demand and your reportsEmbed reports using HTML and URL encodingDisplay reports inside dashboards and on home page screensEmbed reports inside other reportsAdd reports and dashboards to custom Web tabs and desktop applicationsInclude external sites in reports
Building the Unstructured Data Warehouse
Learn essential techniques from data warehouse legend Bill Inmon on how to build the reporting environment your business needs now!Answers for many valuable business questions hide in text. How well can your existing reporting environment extract the necessary text from email, spreadsheets, and documents, and put it in a useful format for analytics and reporting? Transforming the traditional data warehouse into an efficient unstructured data warehouse requires additional skills from the analyst, architect, designer, and developer. This book will prepare you to successfully implement an unstructured data warehouse and, through clear explanations, examples, and case studies, you will learn new techniques and tips to successfully obtain and analyze text.Master these ten objectives: Build an unstructured data warehouse using the 11-step approach Integrate text and describe it in terms of homogeneity, relevance, medium, volume, and structure Overcome challenges including blather, the Tower of Babel, and lack of natural relationships Avoid the Data Junkyard and combat the "Spider's Web" Reuse techniques perfected in the traditional data warehouse and Data Warehouse 2.0, including iterative development Apply essential techniques for textual Extract, Transform, and Load (ETL) such as phrase recognition, stop word filtering, and synonym replacement Design the Document Inventory system and link unstructured text to structured data Leverage indexes for efficient text analysis and taxonomies for useful external categorization Manage large volumes of data using advanced techniques such as backward pointers Evaluate technology choices suitable for unstructured data processing, such as data warehouse appliances
Pro Oracle Database 11g Administration
Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have "buck stops here" responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. Condenses and organizes the core job of a database administrator into one volume. Takes a results-oriented approach to getting things done. Lays a foundation upon which to build a senior level of expertise
Oracle PL/SQL Recipes
Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner.Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point
Master Data Management and Data Governance
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 latest techniques for building a customer-focused enterprise environmentRegain control of your master data and maintain a master-entity-centric enterprise data framework using the detailed information in this authoritative guide. Master Data Management and Data Governance, Second Edition provides up-to-date coverage of the most current architecture and technology views and system development and management methods. Discover how to construct an MDM business case and roadmap, build accurate models, deploy data hubs, and implement layered security policies. Legacy system integration, cross-industry challenges, and regulatory compliance are also covered in this comprehensive volume.Plan and implement enterprise-scale MDM and Data Governance solutionsDevelop master data modelIdentify, match, and link master records for various domains through entity resolutionImprove efficiency and maximize integration using SOA and Web servicesEnsure compliance with local, state, federal, and international regulationsHandle security using authentication, authorization, roles, entitlements, and encryptionDefend against identity theft, data compromise, spyware attack, and worm infectionSynchronize components and test data quality and system performance
MySQL
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 comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use todayWritten 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.
Pentaho Kettle Solutions
A complete guide to Pentaho Kettle, the Pentaho Data lntegration toolset for ETL This practical book is a complete guide to installing, configuring, and managing Pentaho Kettle. If you're a database administrator or developer, you'll first get up to speed on Kettle basics and how to apply Kettle to create ETL solutions--before progressing to specialized concepts such as clustering, extensibility, and data vault models. Learn how to design and build every phase of an ETL solution. Shows developers and database administrators how to use the open-source Pentaho Kettle for enterprise-level ETL processes (Extracting, Transforming, and Loading data) Assumes no prior knowledge of Kettle or ETL, and brings beginners thoroughly up to speed at their own pace Explains how to get Kettle solutions up and running, then follows the 34 ETL subsystems model, as created by the Kimball Group, to explore the entire ETL lifecycle, including all aspects of data warehousing with Kettle Goes beyond routine tasks to explore how to extend Kettle and scale Kettle solutions using a distributed "cloud" Get the most out of Pentaho Kettle and your data warehousing with this detailed guide--from simple single table data migration to complex multisystem clustered data integration tasks.
Practical DMX Queries for Microsoft SQL Server Analysis Services 2008
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.250+ Ready-to-Use, Powerful DMX QueriesTransform data mining model information into actionable business intelligence using the Data Mining Extensions (DMX) language. Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 contains more than 250 downloadable DMX queries you can use to extract and visualize data. The application, syntax, and results of each query are described in detail. The book emphasizes DMX for use in SSMS against SSAS, but the queries also apply to SSRS, SSIS, DMX in SQL, WinForms, WebForms, and many other applications. Techniques for generating DMX syntax from graphical tools are also demonstrated in this valuable resource.View cases within data mining structures and models using DMX Case queriesExamine the content of a data mining model with DMX Content queriesPerform DMX Prediction queries based on the Decision Trees algorithm and the Time Series algorithmRun Prediction and Cluster queries based on the Clustering algorithmExecute Prediction queries with Association and Sequence Clustering algorithmsUse DMX DDL queries to create, alter, drop, back up, and restore data mining objectsDisplay various parameters for each algorithm with Schema queriesExamine the values of discrete, discretized, and continuous structure columns using Column queriesUse graphical interfaces to generate Prediction, Content, Cluster, and DDL queriesDeliver DMX query results to end usersDownload the source code from www.mhprofessional.com/computingdownload
Oracle Database Administration for Microsoft SQL Server DBAs
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.Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide.Install and configure Oracle Database on Windows or Linux systemsAdminister and monitor databases from Oracle Enterprise ManagerImplement robust security using roles, permissions, and privilegesBack up and restore databases with Oracle Recovery ManagerUse the Oracle cost-based optimizer to tune performanceWrite, debug, and execute PL/SQL queries using Oracle SQL DeveloperMaximize availability with Oracle Real Application ClustersBuild standby and failover servers using Oracle Data Guard
Practical Powerpivot & DAX Formulas for Excel 2010
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.250 + ready-to-use, powerful DAX formulasDevelop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide.Build pivot tables and charts with PowerPivot for ExcelImport information from Access, Excel, data feeds, SQL Server, and other sourcesOrganize and format BI reports using the PowerPivot Field ListWrite DAX formulas that filter, sort, average, and denormalize dataConstruct complex DAX formulas from statistical, math, and date functionsCompare current and past performance using date and time intelligenceHandle non-additive numbers, non-numeric values, and running totalsDevelop complete self-service and sharable BI solutions in a few minutesDownload the source code from www.mhprofessional.com/computingdownload
Expert Oracle Database Architecture
Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Fully revised to cover Oracle Database 11g Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database's most powerful features
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
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.300+ ready-to-use, powerful MDX queriesThis hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.Work with dimensions, hierarchies, levels, and membersNavigate both horizontally and vertically across dimensions and hierarchiesSort the results of your queriesAccess subsets of dimension members and measure values using the Where clause and Filter functionUse MDX query calculationsExtract and manipulate dates and timesProduce totals, subtotals, and changes cross time using aggregate and other functionsCreate, visualize, and manipulate setsWork with perspectives, subselects, and subcubesDisplay and hide empty cellsUse, modify, format, and create Key Performance Indicators (KPIs)Deliver MDX query results to end users
Pro SQL Server 2008 Policy-Based Management
Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization. Provides in-depth treatment of policy-based management in a single source Provides practical usage scenarios for policy-based management Provides guidance to help meet growing regulatory compliance needs
Oracle RMAN 11g Backup and 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.Master Oracle Recovery MasterProtect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.Set up, configure, and maintain Oracle Recovery Manager (Oracle RMAN)Manage physical and virtual media with Oracle Secure BackupWork with Oracle RMAN catalogs, packages, and control filesUse the Amazon Web Services cloud as an offsite storage solutionCreate online, offline, and incremental system backupsPerform full and partial Oracle RMAN database restoresCorrect user-induced errors with Oracle FlashbackProduct clone and standby databases on local or remote serversUse Oracle Real Application Clusters and synch and split technologyFor a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Oracle Enterprise Manager 10g Grid Control 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.Master Oracle Enterprise Manager 10g Grid ControlCentralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, implement top-down performance monitoring, and maximize system availability.Plan and carry out an Oracle Enterprise Manager 10g Grid Control rolloutSet up customized metrics, alerts, thresholds, targets, and agentsManage IT resources from a centralized control console or the command lineManage your infrastructure using secure protocolsAutomate administrative tasks with Oracle's management agentDistribute business intelligence using the reporting and dashboard featuresWork with Oracle Enterprise Manager Database Control and Oracle Real Application ClustersBuild physical and logical standby databases using Oracle Data Guard
DBA Survivor
DBA Survivor is a book to help new database administrators understand more about the world of database administration. More and more people are moving into the DBA profession, and many are looking for a getting-started guide. Blogs are written about how to be an exceptional DBA and what to do in your first 100 days. This book takes a different approach, injecting some humor into helping you understand how to hit the ground running, and most importantly how to survive as a DBA. And it's not just survival that matters. Author Thomas LaRock wants much more for you than mere survival. He wants you to have excellence, competence, visibility, confidence, and service. These are the traits and characteristics of DBAs who truly succeed and become respected in their profession. Don't settle for just muddling through your job each day. Strive to excel. Aim to make a difference, for your clients, and for your colleagues. Focuses on the soft skills that distinguish truly exceptional DBAs Takes a humorous approach to keep readers engaged Written by a SQL Server "Most Valuable Professional" and board member of PASS
Oracle Database 11g Pl/SQL Programming 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.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 connectionsWork with data types, structures, blocks, cursors, and PL/SQL semanticsWrite, deploy, and use functions, procedures, and packagesManage transactions and moreUse dynamic SQL statements in real-world applicationsSupport online transaction processing and data warehousing applications with external tablesFind syntax samples and best practices to solve problemsWrite, deploy, and use object typesFor a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Microsoft SQL Server 2008 High Availability With Clustering & Database Mirroring
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.Create a Highly Available Microsoft SQL Server 2008 EnvironmentWritten by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.Configure Windows Failover ClusteringSet up the Microsoft Distributed Transaction Coordinator on a two node failover clusterInstall SQL Server 2008 on your clusterHandle cluster management and backupConfigure and manage database mirroring for high availabilityImplement Hyper-V virtualization and Live MigrationManage a SQL Server virtual machineMichael Otey is the technical director for SQL Server Magazine and Windows IT Pro and the bestselling author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books. He is president of TECA, Inc., a software development and consulting company.
Oracle SQL Recipes
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side. Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems
Oracle JDeveloper 11g 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.Written by the most knowledgeable Oracle JDeveloper author team in the worldThis Oracle Press guide shows how to build Web applications using the Fusion Middleware development tool, Oracle JDeveloper. The book discusses the latest technologies and explains how to develop code using multiple techniques.Oracle JDeveloper 11g Handbook: A Guide to Fusion Web Development covers the Oracle Application Development Framework and JavaServer Faces. Hands-on practice examples walk you through the creation of a complete sample application that employs highly-interactive user interface components and declarative development methods. You will learn the techniques required to implement Fusion-oriented software solutions in JDeveloper.
Text Mining
Giving a broad perspective of the field from numerous vantage points, Text Mining focuses on statistical methods for text mining and analysis. It examines methods to automatically cluster and classify text documents and applies these methods in a variety of areas, including adaptive information filtering, information distillation, and text search. The book begins with the classification of documents into predefined categories and then describes novel methods for clustering documents into groups that are not predefined. It concludes with various text mining applications that have significant implications for future research and industrial use.
Data Warehouse Design: Modern Principles and Methodologies
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 Mark Stephen LaRow, Vice President of Products, MicroStrategy"A unique and authoritative book that blends recent research developments with industry-level practices for researchers, students, and industry practitioners."Il-Yeol Song, Professor, College of Information Science and Technology, Drexel University
MySQL Administrator’s Bible
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management--including MySQL's unique approach to basic database features and functions--as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
The Top Ten Algorithms in Data Mining
Identifying some of the most influential algorithms that are widely used in the data mining community, this volume provides a description of each algorithm, discusses the impact of the algorithms, and reviews current and future research on the algorithms. Thoroughly evaluated by independent reviewers, each chapter focuses on a particular algorithm and is written by either the original authors of the algorithm or world-class researchers who have extensively studied the respective algorithm. The book concentrates on the following important algorithms: C4.5, k-Means, SVM, Apriori, EM, PageRank, AdaBoost, kNN, Naive Bayes, and CART.
Databases
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 Database Skills--Made Easy!Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases. Designed for Easy LearningKey Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter Ask the Expert--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show you how to apply your skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge
Mastering SQL Server 2008
As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support--the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to 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.
FileMaker Pro 10
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it -- especially with this book as your guide. Clear, thorough, and accessible, FileMaker Pro 10: The Missing Manual 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's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker. With this book, you will: Get your first database running in minutes and perform basic tasks right away Catalog people, processes, and things with streamlined data entry and sorting tools Use your data to generate reports, correspondence, and other documents with ease Create, connect, and manage multiple tables and set up complex relationships that display just the data you need Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas Outfit your database for the Web, and import and export data to other formats You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.
Oracle Database 11g
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 a Solid Foundation in Oracle Database TechnologyMaster Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being coveredMastery Checks--Chapter-ending quizzes to test your knowledge
Delivering Business Intelligence with Microsoft SQL Server 2008
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 Business Intelligence Tools in Microsoft SQL Server 2008Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.Understand the goals and benefits of business intelligenceDesign and create relational data marts and OLAP cubesManage Analysis Services databases using BI Development StudioCleanse data and populate data marts with SQL Server Integration ServicesTake advantage of the flexibility of the Unified Dimensional ModelManipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clusteringDevelop and distribute interactive reports with SQL Server 2008 Reporting ServicesIntegrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
Professional Microsoft SQL Server 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.
Microsoft SQL Server 2008 Reporting Services
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 Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting ServicesCreate SELECT queries to extract dataGenerate reports from the Report Wizard and from scratchAdd charts, images, and gaugesBuild reusable report templatesUse the new Tablix data format to create reports with any structureExport reports to Word, Excel, PDF, HTML, XML, and other formatsEnable end-user access to reports via the Report Server and its Report Manager web interface
Oracle CRM On Demand 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 One-Stop Guide to Oracle CRM On Demand ReportingPlan, build, and distribute data-rich business intelligence reports with ease. Oracle CRM On Demand Reporting details the entire report-building process and explains how to use the powerful features available in Answers On Demand to create and share comprehensive, integrated reports. The book includes proven strategies for report design and development, real-world examples, formatting tips, advanced reporting techniques, and sample formulas. Convert disparate corporate data into actionable business intelligence with help from this detailed guide. Maximize the features of Answers On DemandStrategically plan your reportsFormat, sort, filter, and modify report dataUse column formulas with numeric, date and time, and text data Apply logic and transform data with column formulasFormat report title and table viewsAdd charts, graphs, pivot tables, filter prompts, and interactivity to reportsConfigure advanced views and create custom dashboardsManage reports and control access
Pro SQL Server 2008 Relational Database Design and Implementation
Louis Davidson's book on database design is a solid, five-star book on Amazon that is reviewed and endorsed by leading lights such as Adam Mechanic and James Luetkehoelter. The book is technically and theoretically sound, and is grounded in best-practices. The previous two editions have sold in excess of 5000 units. There is no better book on database design catering to the SQL Server professional.
Pro T-sql 2008 Programmer’s Guide
Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmer's Guide shows developers the full range of what's possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.
SQL
Essential Skills--Made Easy!Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated
Microsoft SQL Server 2008: A Beginner’s 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.Get Started on Microsoft SQL Server 2008 in No TimeLearn 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 2008Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functionsOptimize database performance, availability, and reliabilityImplement solid security using authentication, encryption, and authorization Automate tasks using SQL Server AgentCreate reliable data backups and perform flawless system restoresUse all-new SQL Server 2008 Business Intelligence, development, and administration toolsLearn in detail the SQL Server XML technology (SQLXML)
Beginning SQL Server 2008 for Developers
Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services. The author has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He maintains visibility in the field through his website and his other books. The two previous editions of this book have sold well.
SQL Bible
Harness SQL for Oracle 11g, IBM DB2, and Microsoft SQL Server 2008Combining theory with everyday practicality, this definitive volume is packed with 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. Learn the basics of SQL and relational databases Explore tables, views, sequences, and other database objects Examine transactions and locking in multiuser environments Review functions mandated by the SQL standard and the three major vendors Access metadata information and implement database security Go beyond SQL to XML integration, OLAP business intelligence, and more Companion Web SiteFind downloadable code examples and more at www.wiley.com/go/SQLBible2
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
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.
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.
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
AP || 9FA79DA9A4