Getting started with sql
Exercises with phpmyadmin and mysql
Rémy Lentzner
Résumé
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.
Caractéristiques techniques
| NUMERIQUE | |
| Éditeur(s) | Remylent |
| Auteur(s) | Rémy Lentzner |
| Parution | 09/03/2023 |
| Contenu |
ePub |
| EAN13 |
9782385180379 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
- Informatique Développement d'applications
- Informatique Bases de données
- Informatique Bases de données Bases de données objet et objet relationnelles
- Informatique Informatique d'entreprise Data warehouse et data mining
- Informatique Développement d'applications Techniques de programmation
- Informatique Développement d'applications Langages XML
