This book teaches you how to work with MySQL – a popular relational database management system. You will learn how to download and install MySQL on your Windows or Linux system. You will learn how to access MySQL through the command line or GUI, how to create a database, how to query a database, sort results, and much more. We will also guide you through some more advanced MySQL topics, such as MySQL functions, aliases, keys, and such.
Here is a list of topics covered in this book:
- Chapter 1 – Introduction – you will learn what MySQL is and how to install it on Windows or Linux.
- Chapter 2 – SQL command syntax – we will start working with SQL, a special-purpose programming language used for managing data held in MySQL. We will show you the SQL syntax and some basic commands: how to create a database, how to create a table, and how to create a user.
- Chapter 3 – Important SQL commands – we will show you some common SQL command used to manage a database. We will describe how you can insert new records in a table, modify a table, update the contents of a field…
- Chapter 4 – Advanced usage – we will show you some advanced MySQL topics. You will learn how to define primary keys, how to work with MySQL functions, what aliases are and how to combine multiple SELECT statements.