This book is best for the beginners who want to learn MySql from beginning. This book will help us in guiding the essential Sql skills.Thank you murach's for bringing such a nice book of MySql that will help us a lot in learning MySql. If you’re new to MySQL, it will teach you everything from coding SQL statements to designing databases to using stored programs that save you time and effort. If you have MySQL experience, the “paired-pages” format will make it easy for you to focus on the MySQL features and coding skills that are new to you. This book is also a good choice for anyone who wants to learn standard SQL. In fact, 90% of what you learn here can be transferred to another database management system such as Oracle or SQL Server. Finally, this is the right first book for anyone who wants to become a database administrator. Although it doesn't cover all the issues that DBAs have to deal with, it gives you the solid foundation in database design and management that you need to build on. What are the prerequisites for using this book? Section 1
In this section you learn about the introduction of relational databases and SQL.You will learn also How to use MySql Workbench and other development tool.
Section 2
In this section you will learn about how to retrieve data from a single table, data from two or more tables. This section help you to code summary queries and subqueries,how to insert, update and delete data. Also help to work with data types and how to use functions.
Section 3
In this section you will learn how to design a database, how to create databases, tables and indexes. This section also helps you how to create views.
Section 4
In this section you will learn about the Language skills for writing stored programs and also how to use transactions and locking. Here you will also learn how to create stored procedures and functions, triggers and events.
Section 5
In this section you will be introduced to the database administration. Here you will learn how to secure a database and how to back up and restore a database.
Conclusion
In this section we learn basic as well as advance MySql concepts which include from the insert,update,delete statements till handling administrative tasks. In this book also helps you in the end how to install the software for this book on Windows and on Mac OS X.