GETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL

Remy Lentzner

mars 2023 · Éditions Remylent

À propos de cet e-book

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.

Enjoy your reading!


ABOUT THE AUTHOR

Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.