rssHome » Database Administration

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, 2nd...

eBook Details:

  • Paperback: 796 pages
  • Publisher: WOW! eBook; 2nd edition (July 17, 2013)
  • Language: English
  • ISBN-10: 143024836X
  • ISBN-13: 978-1430248361

eBook Description:

RMAN Recipes for Oracle Database 12c

Oracle’s flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, 2nd Edition is aimed squarely at Oracle database administrators responsible for database backup and recovery operations.

Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, 2nd Edition delivers. It’ll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It’ll be the book that lets you sleep at night knowing that no matter what transpires, that you’ve done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, 2nd Edition gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence. RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, 2nd Edition is an example-driven approach to the Oracle database administrator’s #1 job responsibility: Be able to recover the database. CLICK TO DOWNLOAD

Pro Oracle Database 12c Administration, 2nd Edition

eBook Details:

  • Paperback: 756 pages
  • Publisher: WOW! eBook; 2nd edition (July 17, 2013)
  • Language: English
  • ISBN-10: 1430257288
  • ISBN-13: 978-1430257288

eBook Description:

Pro Oracle Database 12c Administration, 2nd Edition

Pro Oracle Database 12c Administration, 2nd Edition 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 12c Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator.

Pro Oracle Database 12c Administration, 2nd Edition is aimed at new database administrators who aspire to senior positions in which employers and customers trust you to work independently, and with a “buck stops here” attitude. CLICK TO DOWNLOAD

Big Data Imperatives: Enterprise ‘Big Data’ Warehouse, ‘BI’ Implementa...

eBook Details:

  • Paperback: 320 pages
  • Publisher: WOW! eBook; 1st edition (June 26, 2013)
  • Language: English
  • ISBN-10: 1430248726
  • ISBN-13: 978-1430248729

eBook Description:

Big Data Imperatives

Big Data Imperatives: Enterprise ‘Big Data’ Warehouse, ‘BI’ Implementations and Analytics, focuses on resolving the key questions on everyone’s mind: Which data matters? Do you have enough data volume to justify the usage? How you want to process this amount of data? How long do you really need to keep it active for your analysis, marketing, and BI applications?

Big Data Imperatives: Enterprise ‘Big Data’ Warehouse, ‘BI’ Implementations and Analytics explains ‘what big data can do’. It can batch process millions and billions of records both unstructured and structured much faster and cheaper. Big data analytics provide a platform to merge all analysis which enables data analysis to be more accurate, well-rounded, reliable and focused on a specific business capability.

Big Data Imperatives: Enterprise ‘Big Data’ Warehouse, ‘BI’ Implementations and Analytics describes the complementary nature of traditional data warehouses and big-data analytics platforms and how they feed each other. This book aims to bring the big data and analytics realms together with a greater focus on architectures that leverage the scale and power of big data and the ability to integrate and apply analytics principles to data which earlier was not accessible. CLICK TO DOWNLOAD

Expert Oracle Enterprise Manager 12c

eBook Details:

  • Paperback: 532 pages
  • Publisher: WOW! eBook; 1st edition (June 19, 2013)
  • Language: English
  • ISBN-10: 1430249382
  • ISBN-13: 978-1430249382

eBook Description:

Expert Oracle Enterprise Manager 12c

Enterprise Manager 12c (EM12c), Oracle’s newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today’s increasingly chaotic and change-driven IT environment.

Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager.

Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle’s online knowledgebase. Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. CLICK TO DOWNLOAD

Developing Business Intelligence Apps for SharePoint

eBook Details:

  • Paperback: 592 pages
  • Publisher: WOW! eBook (July 30, 2013)
  • Language: English
  • ISBN-10: 144932083X
  • ISBN-13: 978-1449320836

eBook Description:

Developing Business Intelligence Apps for SharePoint

  • Learn the fundamentals of SharePoint, LightSwitch, and SQL Server 2012
  • Get a solid grounding in BI application basics and database design principles
  • Use LightSwitch to build a help desk app, including data model design and SharePoint data integration
  • Build a tabular cube with Microsoft’s Business Intelligence Semantic Model (BISM)
  • Dive into the data visualization stack, including Excel and SQL Server Reporting Services
  • Create reports with Excel Services, Report Builder, and PowerView
  • Use tips and tricks for setting up your BI application development environment

Create dynamic business intelligence (BI) solutions for SharePoint faster and with more capabilities than previously possible. With this book, you’ll learn the entire process from high-level concepts to development and deployment for building data-rich BI applications with Visual Studio LightSwitch, SQL Server 2012, and a host of related Microsoft technologies.

You’ll learn practical techniques and patterns necessary to use all of these technologies together as you build an example application through the course of the book, step by step. Discover how to solve real problems, using BI solutions that will evolve to meet future needs. CLICK TO DOWNLOAD

Apache Sqoop Cookbook

eBook Details:

  • Paperback: 94 pages
  • Publisher: WOW! eBook (July 23, 2013)
  • Language: English
  • ISBN-10: 1449364624
  • ISBN-13: 978-1449364625

eBook Description:

Apache Sqoop Cookbook

  • Transfer data from a single database table into your Hadoop ecosystem
  • Keep table data and Hadoop in sync by importing data incrementally
  • Import data from more than one database table
  • Customize transferred data by calling various database functions
  • Export generated, processed, or backed-up data from Hadoop to your database
  • Run Sqoop within Oozie, Hadoop’s specialized workflow scheduler
  • Load data into Hadoop’s data warehouse (Hive) or database (HBase)
  • Handle installation, connection, and syntax issues common to specific database vendors

Integrating data from multiple sources is essential in the age of big data, but it can be a challenging and time-consuming task. This handy cookbook provides dozens of ready-to-use recipes for using Apache Sqoop, the command-line interface application that optimizes data transfers between relational databases and Hadoop.

Sqoop is both powerful and bewildering, but with this cookbook’s problem-solution-discussion format, you’ll quickly learn how to deploy and then apply Sqoop in your environment. The authors provide MySQL, Oracle, and PostgreSQL database examples on GitHub that you can easily adapt for SQL Server, Netezza, Teradata, or other relational systems. CLICK TO DOWNLOAD

Enterprise Data Workflows with Cascading

eBook Details:

  • Paperback: 170 pages
  • Publisher: WOW! eBook (July 31, 2013)
  • Language: English
  • ISBN-10: 1449358721
  • ISBN-13: 978-1449358723

eBook Description:

Enterprise Data Workflows with Cascading

  • Start working on Cascading example projects right away
  • Model and analyze unstructured data in any format, from any source
  • Build and test applications with familiar constructs and reusable components
  • Work with the Scalding and Cascalog Domain-Specific Languages
  • Easily deploy applications to Hadoop, regardless of cluster location or data size
  • Build workflows that integrate several big data frameworks and processes
  • Explore common use cases for Cascading, including features and tools that support them
  • Examine a case study that uses a dataset from the Open Data Initiative

There is an easier way to build Hadoop applications. With this hands-on book, you’ll learn how to use Cascading, the open source abstraction framework for Hadoop that lets you easily create and manage powerful enterprise-grade data processing applications without having to learn the intricacies of MapReduce.

Working with sample apps based on Java and other JVM languages, you’ll quickly learn Cascading’s streamlined approach to data processing, data filtering, and workflow optimization. This book demonstrates how this framework can help your business extract meaningful information from large amounts of distributed data. CLICK TO DOWNLOAD

Graph Databases

eBook Details:

  • Paperback: 224 pages
  • Publisher: WOW! eBook (June 12, 2013)
  • Language: English
  • ISBN-10: 1449356265
  • ISBN-13: 978-1449356262

eBook Description:

Graph Databases

  • Model data with the Cypher query language and property graph model
  • Learn best practices and common pitfalls when modeling with graphs
  • Plan and implement a graph database solution in test-driven fashion
  • Explore real-world examples to learn how and why organizations use a graph database
  • Understand common patterns and components of graph database architecture
  • Use analytical techniques and algorithms to mine graph database information

Discover how graph databases can help you manage and query highly connected data. With this practical book, you’ll learn how to design and implement a graph database that brings the power of graphs to bear on a broad range of problem domains. Whether you want to speed up your response to user queries or build a database that can adapt as your business evolves, this book shows you how to apply the schema-free graph model to real-world problems.

Learn how different organizations are using graph databases to outperform their competitors. With this book’s data modeling, query, and code examples, you’ll quickly be able to implement your own solution. CLICK TO DOWNLOAD

Practical Database Programming with Visual Basic.NET, 2nd Edition

eBook Details:

  • Paperback: 896 pages
  • Publisher: Wiley-IEEE Press; 2nd edition (June 19, 2012)
  • Language: English
  • ISBN-10: 1118162056
  • ISBN-13: 978-1118162057

eBook Description:

Practical Database Programming with Visual Basic.NET, 2nd Edition

Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge). This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.

  • Covers both fundamentals and advanced database programming techniques
  • Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
  • Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
  • Includes downloadable programming codes and exercise questions

Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. CLICK TO DOWNLOAD

Relational Theory for Computer Professionals

eBook Details:

  • Paperback: 284 pages
  • Publisher: WOW! eBook (May 31, 2013)
  • Language: English
  • ISBN-10: 144936943X
  • ISBN-13: 978-1449369439

eBook Description:

Relational Theory for Computer Professionals

  • Learn how to see database systems as programming systems
  • Get a careful, precise, and detailed definition of the relational model
  • Explore a detailed analysis of SQL from a relational point of view

There are literally hundreds of books on relational theory or the SQL language or both. But this one is different. First, nobody is more qualified than Chris Date to write such a book. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chris’s involvement with the technology goes back to the time of Codd’s first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach. Its primary aim is to teach relational theory as such. Then it uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively.

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available. CLICK TO DOWNLOAD