PHP Database Books

Database Management Systems: A Business-Oriented Approach Using ORACLE, MySQL and MS Access

More and more, the advance of enterprise computing and cloud technologies means that managers are responsible for retrieving data ad-hoc and constructing business reports for decision-making and storytelling. The technical competencies necessary for such tasks can be daunting, and most database teaching methods do little to mitigate the confusion. They tend to follow traditional computer science methods that …

Learn more

Introducing InnoDB Cluster: Learning the MySQL High Availability Stack

Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. Introducing InnoDB Cluster teaches you about the …

Learn more

Mastering MySQL 8: Discover the full potential of MySQL and keep your database at high performance

Master MySQL for designing cost-efficient database solutions, scaling enterprise operations, reducing overhead business cost and improving customer experience.Key FeaturesTake advantage of new and advanced features of MySQL 8.0, including transactional data dictionary, resource management, group replication and index optimizer. Solve performance issues and optimize MySQL performance using advanced index techniques, optimized queries and advanced server settings.Quick and simple practical …

Learn more

Migrating to MariaDB: Toward an Open Source Database Solution

Mitigate the risks involved in migrating away from a proprietary database platform toward MariaDB’s open source database engine. This book will help you assess the risks and the work involved, and ensure a successful migration. Migrating to MariaDB describes the process and lessons learned during a migration from a proprietary database management engine to the MariaDB open source solution. …

Learn more

Practical Guide to Large Database Migration

It is a major challenge to migrate very large databases from one system, say for example, to transfer critical data from Oracle to SQL Server. One has to consider several issues such as loss of data being transferred, the security of the data, the cost and effort, technical aspects of the software involved, etc. There a very …

Learn more

SQL All In One For Dummies

The latest on SQL databasesSQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.With the ballooning amount of …

Learn more

Data Modeling: A Beginner’s Guide

Essential Skills–Made Easy! Learn how to create data models that allow complex data to be analyzed, manipulated, extracted, and reported upon accurately. Data Modeling: A Beginner’s Guide teaches you techniques for gathering business requirements and using them to produce conceptual, logical, and physical database designs. You’ll get details on Unified Modeling Language (UML), normalization, incorporating business rules, handling …

Learn more

Cyber Operations: Building, Defending, and Attacking Modern Computer Networks

Cyber Operations walks you through all the processes to set up, defend, and attack computer networks. This book focuses on networks and real attacks, offers extensive coverage of offensive and defensive techniques, and is supported by a rich collection of exercises and resources.You’ll learn how to configure your network from the ground up, starting by setting up your …

Learn more