Learn how to use the Apache Hadoop projects, including MapReduce, HDFS, Apache Hive, Apache HBase, Apache Kafka, Apache Mahout, and Apache Solr. From setting up the environment to running sample applications each chapter in this book is a practical tutorial on using an Apache Hadoop ecosystem project. While several books on Apache Hadoop are available, most are based on the main projects, MapReduce and HDFS, and none discusses the other Apache Hadoop ecosystem projects and how they all work together as a cohesive big data development platform. What You Will Learn: Set up the environment in Linux for Hadoop projects using Cloudera Hadoop Distribution CDH 5 Run a MapReduce job Store data with Apache Hive, and Apache HBase Index data in HDFS with Apache Solr Develop a Kafka messaging system Stream Logs to HDFS with Apache Flume Transfer data from MySQL database to Hive, HDFS, and HBase with Sqoop Create a Hive table over Apache Solr Develop a Mahout User Recommender System Who This Book Is For: Apache Hadoop developers. Pre-requisite knowledge of Linux and some knowledge of Hadoop is required.

The Language of SQL, Second Edition Many SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors. For SQL beginners, it’s more important for a book to focus on general concepts and to offer clear explanations and examples of what various SQL statements can accomplish. This is that book. A number of features make The Language of SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to grow your understanding as you encounter new terms and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle. Special “Database Differences” sidebars clearly show you any differences in syntax among these three databases, and instructions are included on how to obtain and install free versions of the databases. This is the only book you need to gain a quick working knowledge of SQL and relational databases. Learn How To... Use SQL to retrieve data from relational databases Apply functions and calculations to data Group and summarize data in a variety of useful ways Use complex logic to retrieve only the data you need Update data and create new tables Design relational databases so that data retrieval is easy and intuitive Use spreadsheets to transform your data into meaningful displays Retrieve data from multiple tables via joins, subqueries, views, and set logic Create, modify, and execute stored procedures Install Microsoft SQL Server, MySQL, or Oracle Contents at a Glance 1 Relational Databases and SQL 2 Basic Data Retrieval 3 Calculated Fields and Aliases 4 Using Functions 5 Sorting Data 6 Selection Criteria 7 Boolean Logic 8 Conditional Logic 9 Summarizing Data 10 Subtotals and Crosstabs 11 Inner Joins 12 Outer Joins 13 Self Joins and Views 14 Subqueries 15 Set Logic 16 Stored Procedures and Parameters 17 Modifying Data 18 Maintaining Tables 19 Principles of Database Design 20 Strategies for Displaying Data A Getting Started with Microsoft SQL Server B Getting Started with MySQL C Getting Started with Oracle

This book introduces the problems facing Internet of Things developers and explores current technologies and techniques to help you manage, mine, and make sense of the data being collected through the use of the world’s most popular database on the Internet - MySQL. The IoT is poised to change how we interact with and perceive the world around us, and the possibilities are nearly boundless. As more and more connected devices generate data, we will need to solve the problem of how to collect, store, and make sense of IoT data by leveraging the power of database systems. The book begins with an introduction of the MySQL database system and storage of sensor data. Detailed instructions and examples are provided to show how to add database nodes to IoT solutions including how to leverage MySQL high availability, including examples of how to protect data from node outages using advanced features of MySQL. The book closes with a comparison of raw and transformed data showing how transformed data can improve understandability and help you cut through a clutter of superfluous data toward the goal of mining nuggets of useful knowledge.

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.

Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you’re an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference. Essential SQLAlchemy includes several sections: SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen

MariaDB Essentials is an approachable yet comprehensive guide to mastering SQL with MariaDB, an advanced open-source database server compatible with MySQL. Through this book, you'll gain a solid foundation in both the basics of database management and the unique features that make MariaDB stand out, all while using practical examples to enhance your learning experience. What this Book will help me do Understand how to install, configure, and start using MariaDB efficiently. Learn how to structure and manage your data using databases, tables, indexes, and SQL queries. Master key advanced features of MariaDB such as virtual columns, dynamic columns, and full-text search. Explore practical operations including importing, exporting, and manipulating data using MariaDB. Gain the skills to work with MariaDB's community tools and innovative storage engines like CONNECT. Author(s) None Kenler is a dedicated technology author and instructor who specializes in database systems and services. With a passion for making complex technical concepts approachable, None has crafted a variety of learning materials that empower readers to fully utilize their tools. None's experience with real-world database management enriches this book, providing readers with both theoretical and practical expertise. Who is it for? This book is perfect for database enthusiasts ranging from beginners unfamiliar with SQL to seasoned users looking to deepen their understanding of MariaDB. It's ideal for working professionals transitioning from MySQL to fully appreciate the unique capabilities of MariaDB. Whether you're a student, developer, or database administrator, this book will guide you in achieving your goals.

Dive into the world of MariaDB with this comprehensive beginner's guide. From installation and configuration to advanced data handling, this book provides hands-on instructions on using MariaDB effectively. Tailored for newcomers, it ensures you can learn and apply database management in a practical way. What this Book will help me do Install MariaDB on various platforms like Windows, Mac OS X, and Linux to start working with databases. Optimize MariaDB for better performance by utilizing the advanced features available in version 10. Secure your databases effectively, ensuring sensitive data is protected from unauthorized access. Learn techniques to analyze and retrieve data efficiently using operators and sorting mechanisms. Perform database maintenance to ensure MariaDB functions optimally in the long run. Author(s) Daniel Bartholomew has extensive experience with open-source databases and has been a key advocate for MariaDB. With years of hands-on practice, Daniel helps simplify complex topics, making learning straightforward for beginners while ensuring robust coverage of advanced capabilities. Who is it for? This book is an excellent choice for those new to databases and wishing to start with MariaDB. Whether you're aiming to learn database basics or looking to expand your technical skillset, this guide provides the foundational knowledge you need. For IT learners or aspiring database managers, it's a perfect first step into database systems. Previous database experience is not necessary.

Get a Jump Start on working with MySQL today! MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers. In just one weekend with this hands-on tutorial, you'll learn how to: Get started with MySQL Store, modify, and retrieve data Work with multiple tables Connect to your database through code Program the database Back up your data

If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines. Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned. Create and alter MySQL tables and specify fields and columns within them Learn how to insert, select, update, delete, join, and subquery data, using practical examples Use built-in string functions to find, extract, format, and convert text from columns Learn functions for mathematical or statistical calculations, and for formatting date and time values Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data Use APIs to connect and query MySQL and MariaDB with PHP and other languages

Learning Apache Cassandra is your comprehensive guide to mastering one of the most popular distributed databases for building scalable, fault-tolerant data layers. Through step-by-step examples and clear explanations, this book will help you understand Cassandra's architecture and how to use its features to design efficient applications. What this Book will help me do Successfully install and set up Apache Cassandra in your environment. Develop highly scalable data models for various application scenarios. Implement efficient query designs using Cassandra's specialized APIs. Maintain data consistency and handle concurrent updates in distributed systems. Apply best practices for securing Cassandra deployments and managing distributed data. Author(s) None Brown is an experienced software developer with a focus on database systems and distributed architectures. With years of hands-on experience working with SQL and NoSQL databases, they bring practical insights and clear instructions to their readers. Their writing aims to demystify complex topics and provide practical learning paths. Who is it for? This book is intended for software developers and database administrators looking to expand their knowledge of distributed databases. If you are familiar with SQL databases like MySQL or PostgreSQL and want to transition to Cassandra, this guide will help you. No prior experience with distributed databases is assumed. By following this book, you'll quickly become proficient in using Cassandra for your distributed application needs.

Essential Skills—Made Easy! PHP and MySQL Web Development: A Beginner's Guide takes you from building static web pages to creating comprehensive database-driven web applications. The book reviews HTML, CSS, and JavaScript and then explores PHP--its structure, control statements, arrays, functions, use with forms, and file handling capabilities. Next, the book examines MySQL, including SQL, the MySQL command set, and how to use it with PHP to create a relational database and build secure, databasedriven web applications. This practical resource features complete, step-by-step examples with code that you can use as templates for your own projects. Designed for Easy Learning Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter Try This--Hands-on exercises that show you how to apply your skills Notes--Extra information related to the topic being covered Tips--Helpful reminders or alternate ways of doing things Cautions--Errors and pitfalls to avoid Self Tests--End-of-chapter quizzes to reinforce your skills Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated Ready-to-use code at www.mhprofessional.com

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you have only basic HTML knowledge. With this popular hands-on guide, you’ll tackle dynamic web programming with the help of today’s core technologies: PHP, MySQL, JavaScript, jQuery, CSS, and HTML5.

In 'Mastering MariaDB', you'll explore advanced techniques for managing, optimizing, and maintaining your MariaDB database servers. This book teaches you how to analyze query performance, implement best practices for security, and ensure data durability and availability through robust configurations and procedures. What this Book will help me do Learn to analyze query performance to optimize database efficiency. Gain expertise in implementing secure and organized role-based access controls. Achieve effective database backups with reliable recovery strategies. Set up replication environments to enable high availability of data. Explore clustering and sharding techniques for powerful scalability solutions. Author(s) None Razzoli is an experienced database administrator and author, specializing in MariaDB and other open-source database solutions. With an extensive career in database optimization and troubleshooting, None has helped businesses achieve greater performance and reliability with their systems. As a writer, they focus on clear, precise instruction and practical, real-world applications of database technology. Who is it for? This book is ideal for database administrators and system engineers who are already familiar with the basics of MariaDB and want to elevate their expertise. Intermediate MariaDB users looking to optimize their systems, ensure data security, and set up advanced configurations will find this book immensely helpful. It's written for professionals who actively manage database systems and require advanced knowledge to improve performance and reliability. If you're seeking deeper insights into MariaDB's features and scalability techniques, this book is for you.

Learn how to optimize your MariaDB installations for performance, scalability, and reliability. This comprehensive guide teaches you advanced replication techniques, clustering, sharding data, and optimizing engines. By the end of the book, you'll have the tools to build complex, high-performing database infrastructures. What this Book will help me do Master the setup of advanced replication models such as master/slave and dual-master setups. Implement a Galera Cluster to enhance your database's write scalability and reliability. Configure the Spider engine for effective data sharding across multiple nodes. Identify and mitigate performance bottlenecks through in-depth engine optimization. Deploy and maintain a disaster recovery solution using advanced database strategies. Author(s) Pierre Mavro is an experienced database administrator with years of expertise in MySQL and MariaDB systems. Having worked on numerous high-scale projects, he brings practical insights into creating robust, high-performance database solutions. Pierre enjoys sharing his knowledge and helping developers and administrators navigate complex database challenges. Who is it for? This book is perfect for database administrators and system architects who already have working experience with MariaDB or MySQL. If you're looking to enhance your skills and develop solutions for high traffic applications, this book is for you. Ideal for those comfortable with Linux-based infrastructures and eager to learn. Whether maintaining high-availability systems or scaling databases, you'll find this work essential.

MySQLâ??s popularity has brought a flood of questions about how to solve specific problems, and thatâ??s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who donâ??t have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, youâ??ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you only have basic HTML knowledge. With this popular hands-on guide, you’ll tackle dynamic web programming with the help of today’s core technologies: PHP, MySQL, JavaScript, CSS, and HTML5. Explore each technology separately, learn how to use them together, and pick up valuable web programming practices along the way. At the end of the book, you’ll put everything together to build a fully functional social networking site. Learn PHP in-depth, along with the basics of object-oriented programming Explore MySQL, from database structure to complex queries Create dynamic PHP web pages that tailor themselves to the user Manage cookies and sessions, and maintain a high level of security Master the JavaScript language and use it to create interactive web pages Use Ajax calls for background browser/server communication Acquire CSS2 & CSS3 skills for professionally styling your web pages Implement all the new HTML5 features, including geolocation, audio, video, and the canvas

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.

Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

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. 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

Master Oracle GoldenGate 11 g Enable 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 GoldenGate Implement Oracle GoldenGate one-way replication Configure multitarget and cascading replication Use 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 Clusters Use Oracle GoldenGate with MySQL and Microsoft SQL Server Perform near-zero-downtime upgrades and migrations Use Oracle GoldenGate Monitor and Oracle GoldenGate Director Ensure data quality with Oracle GoldenGate Veridata Implement nondatabase integration options