Getting started with SQL: Exercises with PhpMyAdmin and MySQL

English | 2023 | ISBN: 978-2385180379 | 105 Pages | EPUB | 10 MB

SQL (Structured Query Language) is a query language for relational database management. In this book, you will discover the basics of its organization and its characteristics. Using the PhpMyAdmin environment, you will learn how to create a database, tables, columns, constraints, keys (primary and foreign), joins and many other specificities.

SQL has a small set of statements and enables you to select records from one or more tables using the universal SELECT command.

Other expressions like UPDATE, INSERT or DELETE will help you to update, insert or delete records. You will also study several functions that manipulate text, dates and numbers.

Thanks to the exercises in this book, you will understand how a small set of statements can perform accurate actions and enhance your skills.