Description
BPB Publications Php Beginner'S Practical Guide by Pratiyush Guleria
This book starts with the concepts in RDBMS (relational database management systems) and SQL (structured query language). The first few chapters cover the definitions and a brief explanation of all the important concepts. They also cover the installation of mariadb and MySQL on Windows and Raspberry Pi as well as the setup of various tools used to connect to MySQL and mariadb server processes. We will also understand how to install Sample schemas and how to use basic SQL queries. Then we move on to the select query in detail. The book explores the data retrieval aspect of SQL queries in detail with the where clause and null handling in detail. The book also explores the functions available in MySQL. Those are single row and group functions. Then we explore how to combine the data from multiple sources. The technique is known as joins