rssHome » Database Administration

The Art of SQL

eBook Details:

  • Paperback: 372 pages
  • Publisher: WOW! eBook (March 1, 2006)
  • Language: English
  • ISBN-10: 0596008945
  • ISBN-13: 978-0596008949

eBook Description:

The Art of SQL

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any “bad SQL” later.

In The Art of SQL, author and SQL expert Stephane Faroult argues that this “safe approach” only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult’s approach takes a page from Sun Tzu’s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can’t be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL. CLICK TO DOWNLOAD

Professional Hadoop Solutions

eBook Details:

  • Paperback: 504 pages
  • Publisher: WOW! eBook; 1st edition (September 23, 2013)
  • Language: English
  • ISBN-10: 1118611934
  • ISBN-13: 978-1118611937

eBook Description:

Professional Hadoop Solutions

  • The ultimate guide for developers, designers, and architects who need to build and deploy Hadoop applications
  • Covers storing and processing data with various technologies, automating data processing, Hadoop security, and delivering real-time solutions
  • Includes detailed, real-world examples and code-level guidelines
  • Explains when, why, and how to use these tools effectively
  • Written by a team of Hadoop experts in the programmer-to-programmer WOW! eBook style

Professional Hadoop Solutions: The go-to guidebook for deploying Big Data solutions with Hadoop

Today’s enterprise architects need to understand how the Hadoop frameworks and APIs fit together, and how they can be integrated to deliver real-world solutions. This book is a practical, detailed guide to building and implementing those solutions, with code-level instruction in the popular WOW! eBook tradition. It covers storing data with HDFS and Hbase, processing data with MapReduce, and automating data processing with Oozie. Hadoop security, running Hadoop with Amazon Web Services, best practices, and automating Hadoop processes in real time are also covered in depth. With in-depth code examples in Java and XML and the latest on recent additions to the Hadoop ecosystem, this complete resource also covers the use of APIs, exposing their inner workings and allowing architects and developers to better leverage and customize them. CLICK TO DOWNLOAD

Making Sense of NoSQL: A guide for managers and the rest of us

eBook Details:

  • Paperback: 312 pages
  • Publisher: WOW! eBook; Pap/Psc edition (September 17, 2013)
  • Language: English
  • ISBN-10: 1617291072
  • ISBN-13: 978-1617291074

eBook Description:

Making Sense of NoSQL: A guide for managers and the rest of us

Making Sense of NoSQL clearly and concisely explains the concepts, features, benefits, potential, and limitations of NoSQL technologies. Using examples and use cases, illustrations, and plain, jargon-free writing, this guide shows how you can effectively assemble a NoSQL solution to replace or augment the traditional RDBMS you have now. Making Sense of NoSQL starts by comparing familiar database concepts to the new NoSQL patterns that augment or replace them. Then, you’ll explore case studies on big data, search, reliability, and business agility that apply these new patterns to today’s business problems. You’ll see how NoSQL systems can leverage the resources of modern cloud computing and multiple-CPU data centers. The final chapters show you how to choose the right NoSQL technologies for your own needs.

Making Sense of NoSQL starts by comparing familiar database concepts to the new NoSQL patterns that augment or replace them. Then, you’ll explore case studies on big data, search, reliability, and business agility that apply these new patterns to today’s business problems. You’ll see how NoSQL systems can leverage the resources of modern cloud computing and multiple-CPU data centers. The final chapters show you how to choose the right NoSQL technologies for your own needs. Making Sense of NoSQL clearly and concisely explains the concepts, features, benefits, potential, and limitations of NoSQL technologies. Using examples and use cases, illustrations, and plain, jargon-free writing, this guide shows how you can effectively assemble a NoSQL solution to replace or augment the traditional RDBMS you have now. CLICK TO DOWNLOAD

Expert PHP and MySQL: Application Design and Development

eBook Details:

  • Paperback: 340 pages
  • Publisher: WOW! eBook; 1st edition (August 21, 2013)
  • Language: English
  • ISBN-10: 1430260076
  • ISBN-13: 978-1430260073

eBook Description:

Expert PHP and MySQL: Application Design and Development

Expert PHP and MySQL: Application Design and Development takes you beyond learning syntax to showing you how to apply proven software development methods to building commerce-grade PHP and MySQL projects that will stand the test of time and reliably deliver on customer needs. Meet these challenges and more head-on! Author Marc Rochkind shows how to begin a project right, with a clear contract and set of written requirements. You’ll learn about project organization, setting up a solid development environment, connecting with client personnel. Database design is essential, and Expert PHP and MySQL has you covered with guidance on creating a sound model and database, and on pushing functionality into the database as appropriate; not everything should be done in PHP.

Developers of real-world applications face numerous problems that seem trivial on the surface, but really do take some skill to get right. Error handling is about more than just the mechanics in the PHP syntax, but also about handling MySQL errors, logging those errors, and about hiding information about application internals that error messages sometimes can expose. Expert PHP and MySQL: Application Design and Development is aimed at programmers competent in PHP and MySQL. Readers should know the mechanics of the language and the database, and have a desire to learn to build commercial systems that will stand the test of time and reliably deliver on customer needs. CLICK TO DOWNLOAD

Expert Oracle RAC 12c

eBook Details:

  • Paperback: 464 pages
  • Publisher: WOW! eBook; 1st edition (August 14, 2013)
  • Language: English
  • ISBN-10: 1430250445
  • ISBN-13: 978-1430250449

eBook Description:

Expert Oracle RAC 12c

Expert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You’ll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic.

All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise. Expert Oracle RAC 12c is for experienced Oracle Database Administrators (DBAs) who are ready to take the next step in their career by expanding their skill set to include building and managing Oracle Real Application Clusters (RAC). DBAs and architects who are in the process of implementing RAC can immensely benefit from this book. It’s an excellent choice for DBAs to learn RAC conceptually, understand best practices, and become experts in troubleshooting RAC problems. CLICK TO DOWNLOAD

PostgreSQL Server Programming

eBook Details:

  • Paperback: 264 pages
  • Publisher: WOW! eBook (June 25, 2013)
  • Language: English
  • ISBN-10: 1849516987
  • ISBN-13: 978-1849516983

eBook Description:

PostgreSQL Server Programming

  • Understand the extension framework of PostgreSQL, and leverage it in ways that you haven’t even invented yet
  • Write functions, create your own data types, all in your favourite programming language
  • Step-by-step tutorial with plenty of tips and tricks to kick-start server programming

PostgreSQL Server Programming

Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and then extending that right on to the database server. With this knowledge in hand, you will be able to respond to the current demand for advanced PostgreSQL skills in a lucrative and booming market.

This book will take you from learning the basic parts of a PostgreSQL function, then writing them in languages other than the built-in PL/PgSQL. You will see how to create libraries of useful code, group them into even more useful components, and distribute them to the community. You will see how to extract data from a multitude of foreign data sources, and then extend PostgreSQL to do it natively. And you can do all of this in a nifty debugging interface that will allow you to do it efficiently and with reliability. CLICK TO DOWNLOAD

QlikView for Developers Cookbook

eBook Details:

  • Paperback: 290 pages
  • Publisher: WOW! eBook (June 24, 2013)
  • Language: English
  • ISBN-10: 1782179739
  • ISBN-13: 978-1782179733

eBook Description:

QlikView for Developers Cookbook

  • Learn beyond QlikView training
  • Discover QlikView Advanced GUI development, advanced scripting, complex data modelling issues, and much more
  • Accelerate the growth of your QlikView developer ability
  • Based on over 7 years’ experience of QlikView development
  • Written in a handy Cookbook style with each recipe as a self-contained learning module

QlikView for Developers Cookbook

QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access.

QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions.

Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise. CLICK TO DOWNLOAD

Oracle Data Guard 11gR2 Administration Beginner’s Guide

eBook Details:

  • Paperback: 404 pages
  • Publisher: WOW! eBook (June 24, 2013)
  • Language: English
  • ISBN-10: 1849687900
  • ISBN-13: 978-1849687904

eBook Description:

Oracle Data Guard 11gR2 Administration Beginner’s Guide

  • Understand the essentials and components of Oracle Data Guard
  • Configure your Data Guard environment using practical examples
  • Find solutions to the most common real-world Data Guard issues
  • Dedicated chapters for Data Guard best practices and Data Guard patching
  • See how Data Guard is integrated with the existing Oracle database cluster and backup environment
  • An easy to read, comprehensive guide with clear, step-by-step instructions

Oracle Data Guard 11gR2 Administration Beginner’s Guide

Data Guard is the high availability, disaster recovery and data replication solution for Oracle Databases.

With the huge growth of Data Guard it’s getting harder to encounter an Oracle DBA not dealing with Data Guard. Since it’s a common DBA task to provide high availability of databases, Data Guard is a must-know topic for every Oracle Database Administrator.

Oracle Data Guard 11gR2 Administration Beginner’s Guide is a practical guide that provides all the information you will need to configure and maintain Data Guard. This book will show you what Data Guard can really do. CLICK TO DOWNLOAD

Learning SQL Server Reporting Services 2012

eBook Details:

  • Paperback: 566 pages
  • Publisher: WOW! eBook (June 24, 2013)
  • Language: English
  • ISBN-10: 184968992X
  • ISBN-13: 978-1849689922

eBook Description:

Learning SQL Server Reporting Services 2012

  • Build applications using the latest Microsoft technologies: SSIS 2012, SSDT, WPF, and SharePoint 2010
  • Reach out to the cloud and master Windows Azure Reporting Services
  • Learn the ins and outs of SQL Server Reporting Services 2012 for Native and SharePoint Integrated modes
  • Step-by-step learning, guided by a large number of screenshots in every chapter makes it a simple

Learning SQL Server Reporting Services 2012

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012, native and fully integrated with SharePoint Server 2010 including new features like Power View and Data Alerts.

Learning SQL Server Reporting Services 2012 will get you started right from installation and then move on to configuration of SQL Server Reporting Services 2012. Start learning right from Chapter 1 and build your skill to create reports using the latest tools and deploy them to the latest servers, both Native and SharePoint. No guessing; you will learn all Power View, Data Alerts, SQL Azure Reporting, the latest Reporting Services Gadgets, and more. CLICK TO DOWNLOAD

Oracle SOA BPEL Process Manager 11gR1 – A Hands-on Tutorial

eBook Details:

  • Paperback: 330 pages
  • Publisher: WOW! eBook (June 20, 2013)
  • Language: English
  • ISBN-10: 1849688982
  • ISBN-13: 978-1849688987

eBook Description:

Oracle SOA BPEL Process Manager 11gR1 – A Hands-on Tutorial

  • Learn by doing, with immediate results
  • Create, integrate, and troubleshoot BPEL services with Oracle BPEL Process Manager and JDeveloper step by step
  • Design, develop, test, deploy, and run a full SOA composite application using industry leading practices

Oracle SOA BPEL Process Manager 11gR1 – A Hands-on Tutorial

BPEL, Business Process Execution Language is the definitive standard in writing and defining actions within business processes. Oracle BPEL Process Manager R1 is Oracle’s latest offering, providing you with a complete end-to-end platform for the creation, implementation, and management of your BPEL business processes that are so important to your service-oriented architecture.

Oracle SOA BPEL Process Manager 11gR1 – A Hands-on Tutorial is your guide to BPEL design and development, SOA Suite platform troubleshooting, and engineering in a detailed step-by-step guide working real-world examples and case studies.

Using industry-leading practices you will start by creating your first BPEL process and move onto configuring your processes, then invoking, orchestrating, and testing them. You will then learn how to use architect and design services using BPEL, performance tuning, integration, and security, as well as high availability, troubleshooting, and modeling for the future. CLICK TO DOWNLOAD