Название: Getting started with SQL: Exercises with PhpMyAdmin and MySQL
Автор: Remy Lentzner
Издательство: Remylent
Год: 2023
Страниц: 105
Язык: английский
Формат: epub (true)
Размер: 10.2 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.

Applications that enable you to store huge amounts of information are called databases. These are computer tools that manage information stored in many tables and linked together by relationships. In this way, data can be pooled, retrieved, queried or added to. The overall system is designed to secure the information. For instance, a bank manages all its customers by assigning them with an individual user number and a password. Each customer can consult his account, withdraw funds, make transfers and perform many other operations. Thanks to the Internet network from his phone, banking operations can be carried out at home, at the office or while travelling. Each operation is considered as a transaction that can succeed or fail. To manage these countless transactions, the computer application must be able to provide an extremely high degree of security. This is the purpose of a database that links numerous pieces of information and is called a RDBMS or Relational Database Management System. There are several of them in the market such as Oracle, Sybase, SQL server, MySQL, PostgreSQL and many others.The common language used by all these information management applications is SQL (Structured Query Language). It has evolved over time with the development of operating systems. SQL is platform independent and has a small instruction set.

In this book, you will practice with the free MySQL language accessible to everyone and thanks to the PhpMyAdmin database management environment, you will be able to manipulate data. I have chosen the free local MAMP server which you can download on PC or Mac

The book is divided into 6 chapters:
Chapter 1 describes how to install the local MAMP server, the PhpMyAdmin relational database management feature and how to create a database with its different objects.
Chapter 2 shows how to create a table, enter data, search for information, and query it using advanced criteria or groupings. You will learn how to use the SELECT command, that enables you to select information from one or more tables. With the UPDATE command, you will perform updates and calculations. You will learn how to create views, stored procedures and triggers.
Chapter 3 explains the techniques that allow you to define relationships between tables. You will be able to define foreign keys and constraints.
Chapter 4 focuses on functions that manipulate text, dates, or numbers and can be used in SELECT queries. You will learn about the aggregate functions that are used with the GROUP BY clause.
Chapter 5 looks at more advanced SQL queries. You will discover how to integrate a SELECT command into another SELECT command. You will learn how to sort in substrings. You will manipulate several set queries with the UNION operator as well as the left and right outer joins between a primary key and a foreign key from two tables.
A glossary summarizes the principal key words of the language.

I hope that this book will interest you and enhance your SQL knowledge.

About the author:
Remy 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.