Practical Neo4j
Why have developers at places like Facebook and Twitter increasingly turned to graph databases to manage their highly connected big data? The short answer is that graphs offer superior speed and flexibility to get the job done. It's time you added skills in graph databases to your toolkit. In Practical Neo4j, database expert Greg Jordan guides you through the background and basics of graph databases and gets you quickly up and running with Neo4j, the most prominent graph database on the market today. Jordan walks you through the data modeling stages for projects such as social networks, recommendation engines, and geo-based applications. The book also dives into the configuration steps as well as the language options used to create your Neo4j-backed applications.Neo4j runs some of the largest connected datasets in the world, and developing with it offers you a fast, proven NoSQL database option. Besides those working for social media, database, and networking companies of all sizes, academics and researchers will find Neo4j a powerful research tool that can help connect large sets of diverse data and provide insights that would otherwise remain hidden. Using Practical Neo4j, you will learn how to harness that power and create elegant solutions that address complex data problems. This book: Explains the basics of graph databasesDemonstrates how to configure and maintain Neo4jShows how to import data into Neo4j from a variety of sourcesProvides a working example of a Neo4j-based application using an array of language of options including Java, .Net, PHP, Python, Spring, and RubyAs you'll discover, Neo4j offers a blend of simplicity and speed while allowing data relationships to maintain first-class status. That's one reason among many that such a wide range of industries and fields have turnedto graph databases to analyze deep, dense relationships. After reading this book, you'll have a potent, elegant tool you can use to develop projects profitably and improve your career options.
Data Lake Architecture
Organizations invest incredible amounts of time and money obtaining and then storing big data in data stores called data lakes. But how many of these organizations can actually get the data back out in a useable form? Very few can turn the data lake into an information gold mine. Most wind up with garbage dumps.Data Lake Architecture will explain how to build a useful data lake, where data scientists and data analysts can solve business challenges and identify new business opportunities. Learn how to structure data lakes as well as analog, application, and text-based data ponds to provide maximum business value. Understand the role of the raw data pond and when to use an archival data pond. Leverage the four key ingredients for data lake success: metadata, integration mapping, context, and metaprocess.Bill Inmon opened our eyes to the architecture and benefits of a data warehouse, and now he takes us to the next level of data lake architecture.
The New Relational Database Dictionary
No matter what DBMS you are using--Oracle, DB2, SQL Server, MySQL, PostgreSQL--misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect on the success of your database projects. For example, here are some common database terms: attribute, BCNF, consistency, denormalization, predicate, repeating group, join dependency. Do you know what they all mean? Are you sure? The New Relational Database Dictionary defines all of these terms and many, many more. Carefully reviewed for clarity, accuracy, and completeness, this book is an authoritative and comprehensive resource for database professionals, with over 1700 entries (many with examples) dealing with issues and concepts arising from the relational model of data. DBAs, database designers, DBMS implementers, application developers, and database professors and students can find the information they need on a daily basis, information that isn't readily available anywhere else.
The Patient Revolution
In The Patient Revolution, author Krisa Tailor--a noted expert in health care innovation and management--explores, through the lens of design thinking, how information technology will take health care into the experience economy. In the experience economy, patients will shift to being empowered consumers who are active participants in their own care. Tailor explores this shift by creating a vision for a newly designed health care system that's focused on both sickness and wellness, and is driven by data and analytics. The new system seamlessly integrates health into our daily lives, and delivers care so uniquely personalized that no two people are provided identical treatments. Connected through data, everyone across the health care ecosystem, including clinicians, insurers, and researchers, will be able to meet individuals wherever they are in their health journey to reach the ultimate goal of keeping people healthy. The patient revolution has just begun and an exciting journey awaits us. Praise for the patient revolution "A full 50% of the US population has at least one chronic disease that requires ongoing monitoring and treatment. Our current health care system is woefully inadequate in providing these individuals with the treatment and support they need. This disparity can only be addressed through empowering patients to better care for themselves and giving providers better tools to care for their patients. Both of those solutions will require the development and application of novel technologies. In Krisa Tailor's book The Patient Revolution, a blueprint is articulated for how this could be achieved, culminating in a vision for a learning health system within 10 years." --Ricky Bloomfield, MD, Director, Mobile Technology Strategy; Assistant Professor, Duke Medicine "In The Patient Revolution, Krisa Tailor astutely points out that 80% of health is impacted by factors outside of the health care system. Amazon unfortunately knows more about our patients than we do. The prescriptive analytics she describes will allow health care providers to use big data to optimize interventions at the level of the individual patient. The use of analytics will allow providers to improve quality, shape care coordination, and contain costs. Advanced analytics will lead to personalized care and ultimately empowered patients!" --Linda Butler, MD, Vice President of Medical Affairs/Chief Medical Officer/Chief Medical Information Officer, Rex Healthcare "The Patient Revolution provides a practical roadmap on how the industry can capture value by making health and care more personalized, anticipatory, and intuitive to patient needs." --Ash Damle, CEO, Lumiata "Excellent read. For me, health care represents a unique economy--one focused on technology, but requiring a deep understanding of humanity. Ms. Tailor begins the exploration of how we provide care via the concepts of design thinking, asking how we might redesign care with an eye toward changing the experience. She does an excellent job deconstructing this from the patient experience. I look forward to a hopeful follow-up directed at changing the provider culture." --Alan Pitt, MD, Chief Medical Officer, Avizia "Whether you're a health care provider looking to gain an understanding of the health care landscape, a health data scientist, or a seasoned business pro, you'll come away with a deeper, nuanced understanding of today's evolving health care system with this book. Krisa Tailor ties together--in a comprehensive, unique way--the worlds of health care administration, clinical practice, design thinking, and business strategy and innovation." --Steven Chan, MD, MBA, University of California, Davis
Getting Started With Data Science
Master Data Analytics Hands-On by Solving Fascinating Problems You'll Actually Enjoy! Harvard Business Review recently called data science "The Sexiest Job of the 21st Century." It's not just sexy: For millions of managers, analysts, and students who need to solve real business problems, it's indispensable. Unfortunately, there's been nothing easy about learning data science-until now. Getting Started with Data Science takes its inspiration from worldwide best-sellers like Freakonomics and Malcolm Gladwell's Outliers: It teaches through a powerful narrative packed with unforgettable stories. Murtaza Haider offers informative, jargon-free coverage of basic theory and technique, backed with plenty of vivid examples and hands-on practice opportunities. Everything's software and platform agnostic, so you can learn data science whether you work with R, Stata, SPSS, or SAS. Best of all, Haider teaches a crucial skillset most data science books ignore: how to tell powerful stories using graphics and tables. Every chapter is built around real research challenges, so you'll always know why you're doing what you're doing. You'll master data science by answering fascinating questions, such as: - Are religious individuals more or less likely to have extramarital affairs? - Do attractive professors get better teaching evaluations? - Does the higher price of cigarettes deter smoking? - What determines housing prices more: lot size or the number of bedrooms? - How do teenagers and older people differ in the way they use social media? - Who is more likely to use online dating services? - Why do some purchase iPhones and others Blackberry devices? - Does the presence of children influence a family's spending on alcohol? For each problem, you'll walk through defining your question and the answers you'll need; exploring how others have approached similar challenges; selecting your data and methods; generating your statistics; organizing your report; and telling your story. Throughout, the focus is squarely on what matters most: transforming data into insights that are clear, accurate, and can be acted upon.
Learning to Love Data Science
Until recently, many people thought big data was a passing fad. "Data science" was an enigmatic term. Today, big data is taken seriously, and data science is considered downright sexy. With this anthology of reports from award-winning journalist Mike Barlow, you'll appreciate how data science is fundamentally altering our world, for better and for worse.Barlow paints a picture of the emerging data space in broad strokes. From new techniques and tools to the use of data for social good, you'll find out how far data science reaches.With this anthology, you'll learn how: Analysts can now get results from their data queries in near real timeIndie manufacturers are blurring the lines between hardware and softwareCompanies try to balance their desire for rapid innovation with the need to tighten data securityAdvanced analytics and low-cost sensors are transforming equipment maintenance from a cost center to a profit centerCIOs have gradually evolved from order takers to business innovatorsNew analytics tools let businesses go beyond data analysis and straight to decision-makingMike Barlow is an award-winning journalist, author, and communications strategy consultant. Since launching his own firm, Cumulus Partners, he has represented major organizations in a number of industries.
Graphing Data With R
It's much easier to grasp complex data relationships with a graph than by scanning numbers in a spreadsheet. This introductory guide shows you how to use the R language to create a variety of useful graphs for visualizing and analyzing complex data for science, business, media, and many other fields. You'll learn methods for highlighting important relationships and trends, reducing data to simpler forms, and emphasizing key numbers at a glance. Anyone who wants to analyze data will find something useful here--even if you don't have a background in mathematics, statistics, or computer programming. If you want to examine data related to your work, this book is the ideal way to start. Get started with R by learning basic commands Build single variable graphs, such as dot and pie charts, box plots, and histograms Explore the relationship between two quantitative variables with scatter plots, high-density plots, and other techniques Use scatterplot matrices, 3D plots, clustering, heat maps, and other graphs to visualize relationships among three or more variables
Machine Learning and Data Science
A practitioner's tools have a direct impact on the success of his or her work. This book will provide the data scientist with the tools and techniques required to excel with statistical learning methods in the areas of data access, data munging, exploratory data analysis, supervised machine learning, unsupervised machine learning and model evaluation. Machine learning and data science are large disciplines, requiring years of study in order to gain proficiency. This book can be viewed as a set of essential tools we need for a long-term career in the data science field - recommendations are provided for further study in order to build advanced skills in tackling important data problem domains.The R statistical environment was chosen for use in this book. R is a growing phenomenon worldwide, with many data scientists using it exclusively for their project work. All of the code examples for the book are written in R. In addition, many popular R packages and data sets will be used.
Oracle Data Integration
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in this Oracle Press guideThrough clear explanations and practical examples, a team of Oracle experts shows how to assimilate data from disparate sources into a single, unified view. Find out how to transform data in real time, handle replication and migration, and deploy Oracle Data Integrator and Oracle GoldenGate. Oracle Data Integration: Tools for Harnessing Data offers complete coverage of the latest "big data" hardware and software solutions. -Efficiently move data both inside and outside an Oracle environment-Map sources to database fields using Data Merge and ETL-Export schema through transportable tablespaces and Oracle Data Pump-Capture and apply changes across heterogeneous systems with Oracle GoldenGate-Seamlessly exchange information between databases using Oracle Data Integrator-Correct errors and maximize quality through data cleansing and validation-Plan and execute successful Oracle Database migrations and replications-
Oracle Pl/Sql Language Pocket Reference
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c. Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of: Fundamental language elements, such as block structure, datatypes, and declarations Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Execution of PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.
Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques
Detect fraud earlier to mitigate loss and prevent cascading damage Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques is an authoritative guidebook for setting up a comprehensive fraud detection analytics solution. Early detection is a key factor in mitigating fraud damage, but it involves more specialized techniques than detecting fraud at the more advanced stages. This invaluable guide details both the theory and technical aspects of these techniques, and provides expert insight into streamlining implementation. Coverage includes data gathering, preprocessing, model building, and post-implementation, with comprehensive guidance on various learning techniques and the data types utilized by each. These techniques are effective for fraud detection across industry boundaries, including applications in insurance fraud, credit card fraud, anti-money laundering, healthcare fraud, telecommunications fraud, click fraud, tax evasion, and more, giving you a highly practical framework for fraud prevention. It is estimated that a typical organization loses about 5% of its revenue to fraud every year. More effective fraud detection is possible, and this book describes the various analytical techniques your organization must implement to put a stop to the revenue leak. Examine fraud patterns in historical data Utilize labeled, unlabeled, and networked data Detect fraud before the damage cascades Reduce losses, increase recovery, and tighten security The longer fraud is allowed to go on, the more harm it causes. It expands exponentially, sending ripples of damage throughout the organization, and becomes more and more complex to track, stop, and reverse. Fraud prevention relies on early and effective fraud detection, enabled by the techniques discussed here. Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques helps you stop fraud in its tracks, and eliminate the opportunities for future occurrence.
Accumulo
Get up to speed on Apache Accumulo, the flexible, high-performance key/value store created by the National Security Agency (NSA) and based on Google's BigTable data storage system. Written by former NSA team members, this comprehensive tutorial and reference covers Accumulo architecture, application development, table design, and cell-level security. With clear information on system administration, performance tuning, and best practices, this book is ideal for developers seeking to write Accumulo applications, administrators charged with installing and maintaining Accumulo, and other professionals interested in what Accumulo has to offer. You will find everything you need to use this system fully. Get a high-level introduction to Accumulo's architecture and data model Take a rapid tour through single- and multiple-node installations, data ingest, and query Learn how to write Accumulo applications for several use cases, based on examples Dive into Accumulo internals, including information not available in the documentation Get detailed information for installing, administering, tuning, and measuring performance Learn best practices based on successful implementations in the field Find answers to common questions that every new Accumulo user asks
Oracle Database 12c 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 Most Complete, Current Oracle DBA ResourceMaintain a high-performance Oracle Database using the best practices and expert techniques in this Oracle Press guide. Oracle Database 12c DBA Handbook is thoroughly updated to cover the new features and utilities, including the multitenant architecture, Oracle Database In-Memory option, and cloud enhancements. Real-world examples for every major configuration are included. You'll learn how to successfully manage a highly available, robust, secure, and extensible Oracle enterprise database environment. Upgrade to Oracle Database 12cPlan and manage tablespacesMaximize database performance using effective physical database layouts and storage management methodsMonitor disk space used by database objectsManage transactions with undo tablespacesImplement expert performance-tuning techniquesIncrease query speed using the new Oracle Database In-Memory optionManage database security through authentication, authorization, and auditingTake full advantage of the multitenant database architectureEnable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data GuardPerform backup and recovery with Oracle Recovery ManagerManage distributed databases and VLDBs
The Enterprise Cloud
Despite the buzz surrounding the cloud computing, only a small percentage of organizations have actually deployed this new style of IT--so far. If you're planning your long-term cloud strategy, this practical book provides insider knowledge and actionable real-world lessons regarding planning, design, operations, security, and application transformation. This book teaches business and technology managers how to transition their organization's traditional IT to cloud computing. Rather than yet another book trying to sell or convince readers on the benefits of clouds, this book provides guidance, lessons learned, and best practices on how to design, deploy, operate, and secure an enterprise cloud based on real-world experience. Author James Bond provides useful guidance and best-practice checklists based on his field experience with real customers and cloud providers. You'll view cloud services from the perspective of a consumer and as an owner/operator of an enterprise private or hybrid cloud, and learn valuable lessons from successful and less-than-successful organization use-case scenarios. This is the information every CIO needs in order to make the business and technical decisions to finally execute on their journey to cloud computing.Get updated trends and definitions in cloud computing, deployment models, and for building or buying cloud servicesDiscover challenges in cloud operations and management not foreseen by early adoptersUse real-world lessons to plan and build an enterprise private or hybrid cloudLearn how to assess, port, and migrate legacy applications to the cloudIdentify security threats and vulnerabilities unique to the cloudEmploy a cloud management system for your enterprise (private or multi-provider hybrid) cloud ecosystemUnderstand the challenges for becoming an IT service broker leveraging the power of the cloud
Oracle Database Upgrade, Migration & Transformation Tips & 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.A practical roadmap for database upgrade, migration, and transformationThis Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors' real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource. Leverage the features of Oracle Data Guard to migrate an Oracle DatabaseUse Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platformsMigrate databases with export/importUse Oracle GoldenGate for zero or near-zero downtime migrationsTake advantage of the Cross-Platform Transportable Tablespace Set utilityMigrate to new storage platforms using the features of Oracle Automatic Storage ManagementUpgrade to Oracle Database 12c with the Database Upgrade Assistant toolMove seamlessly to Oracle's engineered systemsMigrate to the cloud
Oracle SQL Developer Data Modeler for Database Design Mastery
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Design Databases with Oracle SQL Developer Data ModelerIn this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler--the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.Configure Oracle SQL Developer Data ModelerPerform requirement analysisTranslate requirements into a formal conceptual data model and process modelsTransform the conceptual (logical) model into a relational modelManage physical database designGenerate data definition language (DDL) scripts to create database objectsDesign a data warehouse databaseUse subversion for version control and to enable a multiuser environmentDocument an existing database Use the reporting tools in Oracle SQL Developer Data ModelerCompare designs and the database
Field Guide to Hadoop
If your organization is about to enter the world of big data, you not only need to decide whether Apache Hadoop is the right platform to use, but also which of its many components are best suited to your task. This field guide makes the exercise manageable by breaking down the Hadoop ecosystem into short, digestible sections. You'll quickly understand how Hadoop's projects, subprojects, and related technologies work together.Each chapter introduces a different topic--such as core technologies or data transfer--and explains why certain components may or may not be useful for particular needs. When it comes to data, Hadoop is a whole new ballgame, but with this handy reference, you'll have a good grasp of the playing field.Topics include: Core technologies--Hadoop Distributed File System (HDFS), MapReduce, YARN, and SparkDatabase and data management--Cassandra, HBase, MongoDB, and HiveSerialization--Avro, JSON, and ParquetManagement and monitoring--Puppet, Chef, Zookeeper, and OozieAnalytic helpers--Pig, Mahout, and MLLibData transfer--Scoop, Flume, distcp, and StormSecurity, access control, auditing--Sentry, Kerberos, and KnoxCloud computing and virtualization--Serengeti, Docker, and Whirr
Pro Hadoop 2
Pro Apache Hadoop, Second Edition brings you up to speed on Hadoop - the framework of big data. Revised to cover Hadoop 2.0, the book covers the very latest developments such as YARN (aka MapReduce 2.0), new HDFS high-availability features, and increased scalability in the form of HDFS Federations. All the old content has been revised too, giving the latest on the ins and outs of MapReduce, cluster design, the Hadoop Distributed File System, and more. This book covers everything you need to build your first Hadoop cluster and begin analyzing and deriving value from your business and scientific data. Learn to solve big-data problems the MapReduce way, by breaking a big problem into chunks and creating small-scale solutions that can be flung across thousands upon thousands of nodes to analyze large data volumes in a short amount of wall-clock time. Learn how to let Hadoop take care of distributing and parallelizing your software--you just focus on the code; Hadoop takes care of the rest. Covers all that is new in Hadoop 2.0 Written by a professional involved in Hadoop since day one Takes you quickly to the seasoned pro level on the hottest cloud-computing framework
I Heart Logs
Why a book about logs? That's easy: the humble log is an abstraction that lies at the heart of many systems, from NoSQL databases to cryptocurrencies. Even though most engineers don't think much about them, this short book shows you why logs are worthy of your attention. Based on his popular blog posts, LinkedIn principal engineer Jay Kreps shows you how logs work in distributed systems, and then delivers practical applications of these concepts in a variety of common uses--data integration, enterprise architecture, real-time stream processing, data system design, and abstract computing models. Go ahead and take the plunge with logs; you're going love them. Learn how logs are used for programmatic access in databases and distributed systems Discover solutions to the huge data integration problem when more data of more varieties meet more systems Understand why logs are at the heart of real-time stream processing Learn the role of a log in the internals of online data systems Explore how Jay Kreps applies these ideas to his own work on data infrastructure systems at LinkedIn
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
Oracle Database 12c 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.Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statementsWork with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlersExecute black box, white box, and integration testsConfigure and manage stored packages and librariesHandle security with authentication and encryptionUse LOBs to store text and multimedia contentWrite and implement PL/SQL and Java triggersExtend functionality using dynamic SQL statementsUnderstand object types, nested tables, and unnesting queries
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 Nosql Database
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle NoSQL DatabaseEnable highly reliable, scalable, and available data. Oracle NoSQL Database: Real-Time Big Data Management for the Enterprise shows you how to take fulladvantage of this cost-effective solution for storing, retrieving, and updating high-volume, unstructured data. The book covers installation, configuration, application development, capacity planning and sizing, and integration with other enterprise data center products. Real-world examples illustrate the concepts presented in this Oracle Press guide.Understand Oracle NoSQL Database architecture and the underlying data storage engine, Oracle Berkeley DBInstall and configure Oracle NoSQL Database for optimal performanceDevelop complex, distributed applications using a rich set of APIsRead and write data into the Oracle NoSQL Database key-value storeApply an Avro schema to the value portion of the key-value pair using Avro bindingsLearn best practices for capacity planning and sizing an enterpriselevel Oracle NoSQL Database deploymentIntegrate Oracle NoSQL Database with Oracle Database, Oracle Event Processing, and HadoopCode examples from the book are available for download at www.OraclePressBooks.com.
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 E-Business Suite 12 Tuning Tips & 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.Master Oracle E-Business Suite 12 Performance Tuning and OptimizationDeliver on the promise of lower TCO and achieve operational excellence by implementing a comprehensive enterprise application management process. Oracle E-Business Suite 12 Tuning Tips & Techniques offers detailed coverage of the versatile tools, features, and services available for managing application reliability, availability, performance, optimization, and governance. Best practices for maintaining overall application health and supporting evolving priorities, technologies, andsystems are also included in this Oracle Press guide.Get a comprehensive technical and functional overview of Oracle E-Business Suite 12Plan, develop, and implement a management lifecycle strategyExecute an effective reliability management solutionMonitor and maintain availabilityImprove application speed and performanceOptimize Oracle E-Business Suite for short-term flexibility and long-term strategic goalsImplement strong application governance processesMeasure the success and performance of your managementplanMaintain an agile, future-ready Oracle E-Business Suite platform
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.
The Oracle Big Data 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.Transform Big Data into Insight"In this book, some of Oracle's best engineers and architects explain how you can make use of big data. They'll tell you how you can integrate your existing Oracle solutions with big data systems, using each where appropriate and moving data between them as needed." -- Doug Cutting, co-creator of Apache HadoopCowritten by members of Oracle's big data team, Oracle Big Data Handbook provides complete coverage of Oracle's comprehensive, integrated set of products for acquiring, organizing, analyzing, and leveraging unstructured data. The book discusses the strategies and technologies essential for a successful big data implementation, including Apache Hadoop, Oracle Big Data Appliance, Oracle Big Data Connectors, Oracle NoSQL Database, Oracle Endeca, Oracle Advanced Analytics, and Oracle's open source R offerings. Best practices formigrating from legacy systems and integrating existing data warehousing and analytics solutions into an enterprise big data infrastructure are also included inthis Oracle Press guide.Understand the value of a comprehensive big data strategyMaximize the distributed processing power of the Apache Hadoop platformDiscover the advantages of using Oracle Big Data Appliance as an engineered system for Hadoop andOracle NoSQL DatabaseConfigure, deploy, and monitor Hadoop and Oracle NoSQL Database using Oracle Big Data ApplianceIntegrate your existing data warehousing and analytics infrastructure into a big data architectureShare data among Hadoop and relational databases using Oracle Big Data ConnectorsUnderstand how Oracle NoSQL Database integrates into the Oracle Big Data architectureDeliver faster time to value using in-database analyticsAnalyze data with Oracle Advanced Analytics (Oracle R Enterprise and Oracle Data Mining), Oracle R Distribution, ROracle, and Oracle R Connector for HadoopAnalyze disparate data with Oracle Endeca Information DiscoveryPlan and implement a big data governance strategy and develop an architecture and roadmap
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
Oracle Database 12c 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 how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide contains everything you need to know to master SQL. Use SQL statements to access an Oracle databaseWork with SQL*Plus and SQL DeveloperWrite PL/SQL programsCreate tables, sequences, indexes, views, and triggersDesign advanced queries containing complex calculationsCreate database objects to handle abstract dataUse date, time stamp, and time interval data typesEstablish user roles and privilegesHandle multimedia files using large objectsTune SQL statements to make them execute fasterGenerate, process, and store XML dataMaster the very latest Oracle Database 12c featuresCode examples in the book are available for download.
Oracle Goldengate 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.Master Oracle GoldenGate 11gEnable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You'll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide. Install and configure Oracle GoldenGateImplement Oracle GoldenGate one-way replicationConfigure multitarget and cascading replicationUse bidirectional replication to build a heterogeneous database infrastructure Secure your environment, control and manipulate data, and prevent errors Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application ClustersUse Oracle GoldenGate with MySQL and Microsoft SQL ServerPerform near-zero-downtime upgrades and migrationsUse Oracle GoldenGate Monitor and Oracle GoldenGate DirectorEnsure data quality with Oracle GoldenGate VeridataImplement nondatabase integration options
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.
Harness the Power of Big Data
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.Boost your Big Data IQ! Gain insight into how to govern and consume IBM's unique in-motion and at-rest Big Data analytic capabilitiesBig Data represents a new era of computing--an inflection point of opportunity where data in any format may be explored and utilized for breakthrough insights--whether that data is in-place, in-motion, or at-rest. IBM is uniquely positioned to help clients navigate this transformation. This book reveals how IBM is infusing open source Big Data technologies with IBM innovation that manifest in a platform capable of "changing the game."The four defining characteristics of Big Data--volume, variety, velocity, and veracity--are discussed. You'll understand how IBM is fully committed to Hadoop and integrating it into the enterprise. Hear about how organizations are taking inventories of their existing Big Data assets, with search capabilities that help organizations discover what they could already know, and extend their reach into new data territories for unprecedented model accuracy and discovery.In this book you will also learn not just about the technologies that make up the IBM Big Data platform, but when to leverage its purpose-built engines for analytics on data in-motion and data at-rest. And you'll gain an understanding of how and when to govern Big Data, and how IBM's industry-leading InfoSphere integration and governance portfolio helps you understand, govern, and effectively utilize Big Data. Industry use cases are also included in this practical guide.
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
Effective Mysql Advanced Replication 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.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.
Oracle Solaris 11 System Administration
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.Take Full Advantage of the Oracle Solaris 11 Management FeaturesManage a highly scalable, cloud-based computing platform and deliver unmatched performance levels at every layer of your IT stack. Oracle Solaris 11 System Administration: The Complete Reference shows how to deploy Solaris from scratch. Get up-to-date details on installation options, device configuration, virtualization techniques, network security, file encryption, and Web services. NFS, Samba, and Apache are fully covered in this Oracle Press guide.Install Oracle Solaris 11 on x86 and SPARC machinesManage storage using the ZFS file systemDefine user roles and enforce strong access policiesCreate fully isolated zones and virtual system environmentsConfigure print, e-mail, DNS, and DHCP servicesShare files and devices using NFS and SambaSet up Apache Web servers and deploy AMP applications
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
Oracle High-Performance SQL Tuning
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.From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal executionThis expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.
IBM Cognos 10 Business Intelligence
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The only authorized guide to IBM Cognos Business Intelligence v10.1Updated for the latest release of the software, IBM Cognos Business Intelligence 10: The Official Guide explains how to create, implement, and manage an enterprise BI solution. Maximize all of the new and enhanced features, including the powerful modeling, monitoring, and analytics capabilities. Build and deliver reports that foster informed business decisions and better results. Filled with real-world examples and expert advice, this practical resource is ideal for anyone working with IBM Cognos Business Intelligence v10.1--from administrators to end users.Monitor performance using dashboards and scorecardsAssign user roles and privilegesProvide a single access point to application-specific data via Cognos ConnectionAccess content from Microsoft Office applications and mobile devicesCollect and analyze BI data in an interactive dashboard with Cognos Business InsightUse Cognos Administration tools for system managementImplement appropriate security measuresCreate BI reports with relational and dimensional data using Business Insight AdvancedUse Report Studio to build dimensional reports and statistical analysesIdentify and deliver mission-critical information using Event StudioMonitor business performance with Metric StudioCreate, modify, organize, and publish a model in Framework ManagerEnsure report integrity with Lifecycle Manager
Microsoft SQL Server Xxxx
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Essential Microsoft SQL Server 2012 Skills Made EasyGet up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.Install, configure, and customize SQL Server 2012Create and modify database objects with Transact SQL statementsWrite stored procedures and user-defined functionsHandle backup and recoveryAutomate administrative tasksTune your database system for optimal performance, availability, and reliabilityImplement security measures using authentication, encryption, and authorizationWork with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence toolsStore, display, and query XML documents Manage spatial dataQuery documents using MS Full-Text Search (FTS)
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
Effective MySQL Optimizing SQL Statements
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 SQL Statement OptimizationWritten by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.Identify the essential analysis commands for gathering and diagnosing issuesLearn how different index theories are applied and represented in MySQLPlan and execute informed SQL optimizationsCreate MySQL indexes to improve query performanceMaster the MySQL query execution planIdentify key configuration variables that impact SQL execution and performanceApply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the resultsImprove index utilization with covering indexes and partial indexesLearn hidden performance tips for improving index efficiency and simplifying SQL statements
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.
AP || 9FA79DA9A4