GETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL

✍ Scribed by Remy Lentzner

Publisher: Éditions Remylent
Year: 2023
Tongue: English
Leaves: 77
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

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.

📜 SIMILAR VOLUMES

Getting Started with SQL and Databases:

📁 Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

✍ Mark Simon 📂 Library 🏛 Apress 🌐 English

<p><span>Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite.<br></span></p><p><span>The book starts with a general introduction to

Getting Started with SQL and Databases :

📁 Getting Started with SQL and Databases : Managing and Manipulating Data with SQL

✍ Mark Simon 📂 Library 📅 2023 🏛 Apress 🌐 English

The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You w

Mastering phpMyAdmin 3.4 for Effective M

📁 Mastering phpMyAdmin 3.4 for Effective MySQL Management: A complete guide to getting started with phpMyAdmin 3.4 and mastering its features

✍ Marc Delisle 📂 Library 📅 2012 🏛 Packt Publishing 🌐 English

Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary tool - phpMyAdmin - and takes you a step ahead in taking full advantage of its potential. This book is filled with illustrative examples that

Mastering phpMyAdmin 3.3.x for effective

📁 Mastering phpMyAdmin 3.3.x for effective MySQL management : a complete guide to getting started with phpMyAdmin 3.3 and mastering its features

✍ Marc Delidle 📂 Library 📅 2010 🏛 Packt Pub 🌐 English

Mastering phpMyAdmin 3.3.x for Effective

📁 Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features

✍ Marc Delisle 📂 Library 📅 2010 🏛 Packt Publishing 🌐 English

Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutor

Getting Started with SOQL

📁 Getting Started with SOQL

✍ D., Magulan 📂 Library 📅 2014 🏛 Packt Publishing 🌐 English

<b>Revolutionize the use of simple query strings to make them more efficient using SOQL</b><h2>About This Book</h2><ul> <li>Write optimized SOQL statements</li> <li>Discover the standards to follow while writing SOQL statements</li> <li>Learn how to write SOQL statements without hitting the limits s