Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease - Ashwin Pajankar

Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease

By Ashwin Pajankar

  • Release Date: 2020-07-18
  • Genre: Computers

A step-by-step guide that will help you manage data in a relational database using SQL with ease

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, and we will learn ANSI style and the old-style syntax for all the types of Joins. 

The last part explores the DDL and DMLs in depth. We also learn the concepts of Transactions and Constraints. The book explores how we can run the SQL queries from a Python 3 program and load a pandas DataFrame with the data from a table in a schema in the MySQL database.

Comments:

12 Comments
Taylor Mackenzie
Amazing! I love this site
Aston Ayers
Only Signup is easy and free, finally I can read this book Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease with good quality. Thank you!
Ashley Ann
Been waiting to download this book for months. and finally came out too
Cheryl Lynn
This book Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease is very nice, with quick read and download
Erin Cochran Cole
Great selection and quality is better than many Book Store, no kidding.
Kyle Magner
yes, i am also through this to download books
Eric Mn
Yes this really works! Just got my free account
Terry Barnes
One of the best book I've seen this year!
Pastor Shahuano
Excited, Happy Reading guys !!!
Laura Velez Garcia
Thanks, I'm so glad to be reading this book
Wouter van der Giessen
Laura Velez Garcia yes same me too
Janet McCann
Sign up was really easy. Less than 1 minute I was hooked up