This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who are not getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

PHP and MySQL are two of today's most popular, open-source tools for server-side programming. That means there's a continuing demand for web developers who know how to use PHP and MySQL at the professional level. And with this book, you can become one of them! In fact, in just the first 6 chapters, you will create a database-driven website that implements the MVC pattern, the way the best professionals do. Then, the rest of the book lets you build on that base to develop a full set of professional skills.

I cant count how many PHP books I have purchased over the years trying to learn the language. Murachs was the first book that helped me grasp the concepts and got me onto actually scripting in PHP. Thats what one developer posted on the first edition of Murachs PHP and MySQL. Now, this 3rd Edition does a better-than-ever job of delivering the skills you need to develop database-driven websites using PHP and MySQL, the way todays top web professionals do. Section 1 is a quick-start course that shows how to use the latest versions of PHP, MySQL (or MariaDB), and the Apache web server to build your first PHP applications. Right from the start, youll learn to create applications that conform to the MVC pattern, so theyll be easier to maintain as they grow. In addition, youll learn how to create applications that prevent SQL injection attacks and guard against XSS attacks. Section 2 takes you deeper into PHP by covering the skills youll use every day, like how to work with form data, dates, arrays, sessions, cookies, functions, objects, regular expressions, and exceptions. Likewise, Section 3 dives into MySQL, teaching you how to design and create a database, as well as how to access and maintain database data from your PHP programs. Finally, Section 4 teaches you important web programming skills like how to secure web pages, send email, upload files, and process images. Along the way, youll find out how to take advantage of PHP 7 enhancements like scalar data type declarations and improved error handling, as well as new operators and functions. Complete sample applications and chapter exercises provide training support throughout. A great choice for any developer who wants to master PHP without a lot of frustration and unnecessary expense.

If youre an application developer, or youre training to be one, this latest edition of Murachs classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that youll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature. The result? Youll be able to create database applications that are thoroughly professional. Youll be familiar with the DBA-related issues that let you work far more effectively than most of your colleagues. And youll have a handy reference at your side to answer questions and handle new challenges as they come up.

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

If you're developing applications that access Oracle databases, you can save time and trouble by having the database do more work for you. That's where this book comes in. It teaches you how to create effective SQL queries to retrieve and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use Oracle's procedural language, PL/SQL, to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer.

This is the latest edition of the book that application developers worldwide have used to master MySQL...now updated for MySQL 8.0 and beyond. It shows how to code all the essential SQL statements for working with a MySQL database. You'll use these statements every day to have MySQL do more of your work for you. It shows how to use classic MySQL features such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security. It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security. It shows how to design a database, including how to use MySQL Workbench to create and implement the design. It presents a starting set of skills for a database administrator (DBA) if you're interested in that career path or if you need to be your own DBA. In short, it's a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.