Nosql With Mongodb in 24 Hours
NoSQL database usage is growing at a stunning 50% per year, as organizations discover NoSQL's potential to address even the most challenging Big Data and real-time database problems. Every NoSQL database is different, but one is the most popular by far: MongoDB. Now, in just 24 lessons of one hour or less, you can learn how to leverage MongoDB's immense power. Each short, easy lesson builds on all that's come before, teaching NoSQL concepts and MongoDB techniques from the ground up. Sams Teach Yourself NoSQL with MongoDB in 24 Hours covers all this, and much more: Learning how NoSQL is different, when to use it, and when to use traditional RDBMSes instead Designing and implementing MongoDB databases of diverse types and sizes Storing and interacting with data via Java, PHP, Python, and Node.js/Mongoose Choosing the right NoSQL distribution model for your application Installing and configuring MongoDB Designing MongoDB data models, including collections, indexes, and GridFS Balancing consistency, performance, and durability Leveraging the immense power of Map-Reduce Administering, monitoring, securing, backing up, and repairing MongoDB databases Mastering advanced techniques such as sharding and replication Optimizing performance
Non-Invasive Data Governance
Data-governance programs focus on authority and accountability for the management of data as a valued organizational asset. Data Governance should not be about command-and-control, yet at times could become invasive or threatening to the work, people and culture of an organization. Non-Invasive Data Governance(TM) focuses on formalizing existing accountability for the management of data and improving formal communications, protection, and quality efforts through effective stewarding of data resources.Non-Invasive Data Governance will provide you with a complete set of tools to help you deliver a successful data governance program. Learn how: Steward responsibilities can be identified and recognized, formalized, and engaged according to their existing responsibility rather than being assigned or handed to people as more work. Governance of information can be applied to existing policies, standard operating procedures, practices, and methodologies, rather than being introduced or emphasized as new processes or methods. Governance of information can support all data integration, risk management, business intelligence and master data management activities rather than imposing inconsistent rigor to these initiatives. A practical and non-threatening approach can be applied to governing information and promoting stewardship of data as a cross-organization asset. Best practices and key concepts of this non-threatening approach can be communicated effectively to leverage strengths and address opportunities to improve.
Oracle Weblogic Server 12c Administration 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.Best Practices for Oracle WebLogic Server 12c Configuration and AdministrationMaintain a high-performance enterprise application framework using the detailed information in this authoritative resource. Through expert instruction and real-world examples, Oracle WebLogic Server 12c Administration Handbook fully explains the latest management tools and techniques. Learn how to work from the Oracle WebLogic Server Administration Console or command line, configure servers and clusters, deploy applications, and optimize application performance. Tuning, troubleshooting, and load balancing are thoroughly covered in this Oracle Press guide.Install Oracle WebLogic Server 12c or perform an upgradeManage domains, server instances, networks, and virtual hostsWork with the WebLogic Scripting Tool feature and Node ManagerBuild custom network channels and resource adaptersMonitor performance with the WebLogic Diagnostics Framework featurePrioritize requests using Oracle WebLogic Server Work ManagersConfigure Oracle WebLogic clusters and migrate servers and servicesDeploy web applications, Enterprise JavaBeans, and Java EE modulesEstablish security realms and authenticate and authorize usersAllocate memory, optimize throughput, and tune the Java Virtual Machine
Marketing Analytics
Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques--and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoid high-risk customers Helps you forecast sales and improve response rates for marketing campaigns Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.
Oracle Database 12c 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.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 12cArchitectural changes, such as Oracle MultitenantThe most current information on upgrading and migrating to Oracle Database 12cThe pre-upgrade information tool and parallel processing for database upgradesOracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File SystemOracle RMAN enhancements, including cross-platform backup and recoveryOracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far SyncSQL, PL/SQL, DML, and DDL new featuresImprovements to partitioning manageability, performance, and availabilityAdvanced business intelligence and data warehousing capabilitiesSecurity enhancements, including privileges analysis, data redaction, and new administrative-level privilegesManageability, performance, and optimization improvements
Oracle 12c for Dummies
Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world's largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. Highlights the important features of Oracle 12c Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database Covers advanced Oracle 12c technologies including Oracle Multitenant--the "pluggable database" concept--as well as several other key changes in this release Make the most of Oracle 12c's improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.
Doing Data Science
Now that people are aware that data can make the difference in an election or a business model, data science as an occupation is gaining ground. But how can you get started working in a wide-ranging, interdisciplinary field that's so clouded in hype? This insightful book, based on Columbia University's Introduction to Data Science class, tells you what you need to know. In many of these chapter-long lectures, data scientists from companies such as Google, Microsoft, and eBay share new algorithms, methods, and models by presenting case studies and the code they use. If you're familiar with linear algebra, probability, and statistics, and have programming experience, this book is an ideal introduction to data science. Topics include: Statistical inference, exploratory data analysis, and the data science process Algorithms Spam filters, Naive Bayes, and data wrangling Logistic regression Financial modeling Recommendation engines and causality Data visualization Social networks and data journalism Data engineering, MapReduce, Pregel, and Hadoop Doing Data Science is collaboration between course instructor Rachel Schutt, Senior VP of Data Science at News Corp, and data science consultant Cathy O'Neil, a senior data scientist at Johnson Research Labs, who attended and blogged about the course.
Oracle Manufacturing and Supply Chain 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.Implement Oracle's Internet-based Manufacturing and Supply Chain Management products using this Oracle authorized resource. This comprehensive guide explains how to implement the planning, engineering, pricing, order fulfillment, and inventory management components of Oracle Manufacturing and Supply Chain--and develop and deliver goods and services faster, cheaper, and more efficiently than your competitors.
Oracle Essentials
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle's product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle's architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle's online transaction processing (OLTP) Data warehouses, Big Data, and Oracle's business intelligence tools Backup and recovery, and high availability and failover solutions
Redis in Action
Summary Redis in Action introduces Redis and walks you through examples that demonstrate how to use it effectively. You'll begin by getting Redis set up properly and then exploring the key-value model. Then, you'll dive into real use cases including simple caching, distributed ad targeting, and more. You'll learn how to scale Redis from small jobs to massive datasets. Experienced developers will appreciate chapters on clustering and internal scripting to make Redis easier to use. About the Technology When you need near-real-time access to a fast-moving data stream, key-value stores like Redis are the way to go. Redis expands on the key-value pattern by accepting a wide variety of data types, including hashes, strings, lists, and other structures. It provides lightning-fast operations on in-memory datasets, and also makes it easy to persist to disk on the fly. Plus, it's free and open source. About this book Redis in Action introduces Redis and the key-value model. You'll quickly dive into real use cases including simple caching, distributed ad targeting, and more. You'll learn how to scale Redis from small jobs to massive datasets and discover how to integrate with traditional RDBMS or other NoSQL stores. Experienced developers will appreciate the in-depth chapters on clustering and internal scripting. Written for developers familiar with database concepts. No prior exposure to NoSQL database concepts nor to Redis itself is required. Appropriate for systems administrators comfortable with programming. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. What's InsideRedis from the ground upPreprocessing real-time dataManaging in-memory datasetsPub/sub and configurationPersisting to diskAbout the Author Dr. Josiah L. Carlson is a seasoned database professional and an active contributor to the Redis community. Table of ContentsPART 1 GETTING STARTEDGetting to know RedisAnatomy of a Redis web applicationPART 2 CORE CONCEPTSCommands in RedisKeeping data safe and ensuring performanceUsing Redis for application supportApplication components in RedisSearch-based applicationsBuilding a simple social networkPART 3 NEXT STEPSReducing memory useScaling RedisScripting Redis with Lua
Using R to Unlock the Value of Big Data: Big Data Analytics with Oracle R Enterprise and Oracle R Connector for Hadoop
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 Oracle Press Guide to Big Data Analytics using RCowritten by members of the Big Data team at Oracle, this Oracle Press book focuses on analyzing data with R while making it scalable using Oracle's R technologies. Using R to Unlock the Value of Big Data provides an introduction to open source R and describes issues with traditional R and database interaction. The book then offers in-depth coverage of Oracle's strategic R offerings: Oracle R Enterprise, Oracle R Distribution, ROracle, and Oracle R Connector for Hadoop. You can practice your new skills using the end-of-chapter exercises.
Effective 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.The Essential Guide to Scaling Your Business SolutionWritten by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replicationto build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features andadditional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.Master the strengths and limitations of native asynchronous replication in a MySQL topologyIdentify the important features to improve replication for growing business requirementsRecognize the key business factors to determine your optimal highavailability needsUnderstand the benefits of using MySQL replication for failover scenariosIdentify the key configuration variables and SQL commands affecting master/ slave replicationLearn about the advancements in replication techniques provided by new products, including Tungsten Replicator and GaleraOptimize your replication management with various utilities and toolkitsFind additional detailed information and presentations at EffectiveMySQL.com.
Connecting the Data
Business data integration is a complex problem that must be solved when organizations change or enhance their internal structures. The goal of this book is to present a simple yet thorough resource that describes the challenges of business data integration and the solutions to these challenges such as schema integration, illustrated through an Operational Data Store (ODS) case study. This book contains three sections spanning ten chapters. Section I, Foundational Concepts, will provide you with the necessary basic concepts and discuss schema integration. Section II, Preparation and Design, introduces the case study and we will reverse engineer each of the data sources to create a set of data dictionary reports which will provide us with the meta data we need to apply the schema integration process. Section III, Physical Implementation, will present scripts to populate each of the source databases and spreadsheets and use reports to create Extract, Transform, and Load (ETL) specifications. The ten chapters within these three sections are: Chapter 1 - Introduction and Roadmap Chapter 2 - What is an Operational Data Store (ODS)? Chapter 3 - What is Schema Integration? Chapter 4 - The Role of the ODS within DW Architectures Chapter 5 - Reverse Engineering the four Source Schema Chapter 6 - Designing the Interim Schema Chapter 7 - Preparing the ETL Specifications Chapter 8 - Designing the Physical ODS Database Model Chapter 9 - Designing Our ETL processes with SSIS Chapter 10 - Data Quality Profiling
Filemaker 12 Developer’s Reference
The new FileMaker 12 allows you to build unparalleled databases for a wide variety of devices, from Windows and Mac desktops to iPhones and iPad. With 10 million registered customers, FileMaker's users are "average Joes" who are knowledge workers, subject matter experts, and business users from all walks of life. The community extends well beyond the pool of professional software developers. FileMaker's legendary ease-of-use has led to its wide adoption and has allowed non-programmers an avenue into creating sophisticated software solutions. FileMaker 12 Developer's Reference will serve to help bridge the gaps in these people's understanding of FileMaker's hundreds of calculation functions, script steps, and operations. They know FileMaker, they've used it for years, but they need a quick reference, immediately accessible while not interrupting their work on screen. There is no other book like this on the market. All FileMaker books include information on calculation formulas, scripting, etc., but none have expressly focused on giving readers one simple thing: a quick reference to be used in conjunction with their programming efforts. Some books teach, others explain, still others explore specific in-depth topics. This book will appeal to the entire FileMaker Pro community and be a great extension of their library. This edition is updated for the many new features coming with FileMaker 12, including the product's design functionality and the file format, and a new section dedicated to FileMaker Go, which is the iOS client.
The Art and Science of Oracle Performance Tuning
Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the Lawson's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.
Vmware Cookbook
With scores of step-by-step solutions, this cookbook helps you work with VMware ESXi in a wide range of network environments. You'll not only learn the basics--how to pool resources from hardware servers, computer clusters, networks, and storage, and then distribute them among virtual machines--but also how to overcome the stumbling blocks you'll encounter when you monitor systems, troubleshoot problems, and deal with security. This expanded second edition covers recent advances in vCloud Director and vShield cloud security. Ideal for system administrators of any level, VMware Cookbook also includes valuable information to help you determine your virtualization needs. Move into the cloud with vCloud Director, and secure virtual datacenters with vSphere Secure and monitor your virtual environment from the command line Manage disk, SSD, and SAN storage implementation and configuration Discover options for managing resources, such as clustering, shares, and hot add/hotplug support Configure logical and physical networks, including virtual switches and software and hardware adapters Make virtual machine replication easier by automating ESXi installations Gain valuable tips for configuration and fine-tuning
Effective Mysql 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.The Essential Guide to Protecting Your Business InformationWritten by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Backup and Recovery covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations. Learn how different backup strategies affect locking and system availabilityIdentify the importance of static backup options and point-in-time requirementsRecognize the important business factors to determine your optimal data protection requirementsUnderstand the benefits of using MySQL replication for leveraging different backup strategiesUnderstand the benefits and risks of implementing solutions with MySQL in the cloudIdentify key configuration variables that affect data durability and performanceFind out about the types of possible disasters and develop a robust plan to address themOptimize your backup approach with compression, streaming, incremental, and parallel options
DB2 9.7 Exam 541 Practice Questions
This book will help you pass IBM Exam 541 and become an IBM Certified Database Administrator. The questions and answers in the book offer you a significant advantage by helping you to gauge your readiness for the exam, to better understand the objectives being tested, and to get a broad exposure to the knowledge you'll be tested on. * 180 high quality questions and answers* Full coverage of exam topics* Book format enables you to study wherever you are
IBM DB2 Version 10
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.Save Time and Money with DB2 10 for LUWEven travel through time and shrink dataHow would you like to compress even more data, store it in a cloud, and analyze it as though you are traveling through time without compromising security? In addition to these enhancements, you will experience lower costs and faster performance with the latest release of DB2. Read this book to understand the power of DB2 10 and get started now!This book provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try some of the new features by downloading DB2 Express for free, which features Big Data and Cloud technology. Go to ibm.com/db2/express.
Oracle Database 11g Performance Tuning Tips and Techniques
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.Implement Proven Database Optimization SolutionsSystematically 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 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.Properly index and partition Oracle Database 11g Release 2Work with Oracle Exadata and Oracle Exalogic Elastic CloudEfficiently manage disk drives, RAID arrays, and memoryTune queries with Oracle SQL hints and the TRACE utilityTroubleshoot databases using V$ views and X$ tablesDistribute workload using Oracle Real Application TestingGenerate reports using Oracle's Statspack and Automatic Workload Repository toolsUse sar, vmstat, and iostat to monitor system statistics"This is a timely update of Rich's classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products." --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies
MariaDB Crash Course
MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches. MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data. Learn how to: Retrieve and sort data Filter data using comparisons, regular expressions, and full text search Join relational data Create and alter tables Insert, update, and delete data Leverage the power of stored procedures and triggers Use views and cursors Manage transactional processing Create user accounts and manage security via access control
Oracle Weblogic Server 11g Administration 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 the Configuration and Administration of Oracle WebLogic Server 11gOversee a robust, highly available environment for your mission-critical applications using the expert information in this Oracle Press guide. Oracle WebLogic Server 11g Administration Handbook explains the latest management techniques for the de facto application server for Oracle Fusion Middleware 11g> and provides detailed examples and best practices. Find out how to use the Oracle WebLogic Server Administration Console feature, employ command-line and scripting tools, implement failover and migration capabilities, and generate reliable backups. Troubleshooting, tuning, and security procedures are also covered in this comprehensive resource.Install Oracle WebLogic Server 11g or upgrade from a previous versionConfigure domains, servers, clusters, custom networks, and virtual hostsWork with the Administration Console and Monitoring Dashboard features of Oracle WebLogic ServerUse the WebLogic Scripting Tool (WLST) feature of Oracle WebLogic Server to manage and monitor domainsUse the Oracle WebLogic Server Work Managers feature to optimize scheduled workDeploy Web applications, Enterprise JavaBeans, and Java EE modulesImprove scalability and reliability using Oracle WebLogic Server clustersMonitor servers, tune the Java Virtual Machine, maximize throughput, and optimize performanceAuthenticate, authorize, and map users within defined security realms
Oracle Database 11g Building Oracle XML DB Applications
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master the XML Programming Features in Oracle Database 11gDevelop, debug, and administer data-backed XML applications using the expert instruction and best practices in this Oracle Press guide. Oracle Database 11g: Building Oracle XML DB Applications discusses the latest development tools, technologies, and components. Find out how to set up Oracle XML Database (Oracle XML DB), build XML applications in Oracle JDeveloper 11g, work with XSLT stylesheets, and incorporate full-text search. Troubleshooting, performance tuning, and security are also covered in this comprehensive resource.Create, store, and query XML types using Oracle XML DBLoad XML documents into relational tables and define SQL viewsParse and validate schema with Oracle XDK for Java and PL/SQL packagesMerge documents, generate reports, and transform data using XSLTConstruct applications from Oracle XML DB Web servicesUse Oracle JDeveloper 11g to design and deploy XML applicationsIntegrate Oracle Text and Oracle Secure Enterprise Search featuresStreamline the development process using Oracle Application Express
Programming SQL Server 2005
SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005. Programming SQL Server 2005 can help you: Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts. Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.
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
DB2 Purescale
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Extreme Availability and Scalability--Up and Running With DB2 pureScaleDB2 is a leading-edge hybrid data server that offers optimum storage, scalability, and availability. DB2 pureScale is a new technology primarily optimized for scale-out transactional processing clusters in an active-active manner. This succinct guide will show you how DB2 with pureScale can deliver transparent application scalability, the ability to deliver agile-like computing to your transaction systems, and extreme availability.This book, together with IBM DB2 9 New Features (McGraw-Hill, 2007) and Break Free with DB2 9.7 (McGraw-Hill, 2009), provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try the new features by downloading DB2 Express-C 9.7--it is free to develop, deploy, and distribute (with no user and database size limitations) and features pureXML technology. Go to ibm.com/db2/express.Discover the benefits your business can achieve with the agility provided by DB2 pureScaleFind out how applications can be transparently scaledReduce the risk and cost of business growth through umlimited capacity
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.
Oracle CRM on Demand Combined Analyses
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 the Combined Analysis Tools in Oracle CRM on DemandDrive better decision-making across your enterprise using the reporting and analysis techniques in this Oracle Press guide. Through clear explanations and detailed case studies, Oracle CRM on Demand Combined Analyses shows you how to deliver real-time insightful business intelligence to end users. Learn how to perform multiple queries, join tables, format result columns, and add interactivity to your reports. Methods for filtering the results of a combined analysis are also covered in this practical resource.Create, edit, and join reports with set operators in Oracle Answers On DemandConfigure roles and privileges to allow access to development toolsUse negative reporting methods to compensate for null dataAnalyze records from the transactional databases and data warehouse in federated reportsAdd advanced views such as gauges, view selectors, funnel charts, and narrative views to your combined reportsIntegrate ad hoc analysis using Oracle Answers on DemandConsolidate information from disparate sources with pivot tablesPerform calculations across multiple reports using result columns
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
Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition
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.Transform Raw Data Into Meaningful Business Intelligence with SSISDeploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource.Build SSIS packages using the Import and Export Wizard and Business Intelligence Development StudioCreate Loop and Task Host Containers with Control Flow DesignerAdminister SSIS from SQL Server Management Studio and dutilSecure packages using encryption, roles, signatures, and permissionsBuild-in memory lookups and transformations using the Data Flow EngineExtend functionality using custom scripts and ActiveX componentsUse SCD transformations to load data warehouses and data martsLearn to build a Star Schema and Parallel Data WarehouseMigrate Data Transformation Services 2000 and SSIS 2005 packages
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
