Learn SQL with MySQL

Learn SQL with MySQL

Retrieve and Manipulate Data Using SQL Commands with Ease

person icon Ashwin Pajankar

ebook icon BPB Publications

language icon Language - English

updated on icon Updated on Jan, 2021

architecture icon Development,Databases,MySQL


This eBook includes

Formats : EPUB, PDF (Downlodable)

Pages : 132

ISBN : 9789389898088

Language : English

About the Book

Book description

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

Key Features

● Understand the concepts related to relational databases.
● Learn how to install MariaDB and MySQL on Windows, Linux and tools to access it.
● Learn how to connect Python and Pandas to MySQL/MariaDB.


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.

What will you learn

● Understand the basics of MySQL and MariaDB.
● Get familiar with MySQL Arithmetic Operators, DDL, DML, DCL & TCL commands.
● Understand the concept of Single-Row Functions and Group Functions in detail.
● Retrieve data from multiple sources using the Joins.

Who this book is for

This book is designed for beginners as well as professionals alike. The book will also be useful to Data Scientists, Data Analysts, Database Administrators, and Data Engineers.

Table of Contents

1. Introduction and Installation
2. Getting Started with MySQL
3. Getting Started with SQL Queries
4. The WHERE clause in detail
5. Single Row Functions
6. Group Functions
7. Joins in MySQL
8. Subqueries
9. DDL, DML, and Transactions
11. Python 3, MySQL, and Pandas

Learn SQL with MySQL

eBook Preview

Author Details

BPB Publications

BPB Publications

BPB is Asia's largest publishers of Computer & IT books. For the last 63 years BPB has been a friend, philosopher and guide for programmers, developers, hardware technicians, IT Professionals who have made things happen in the IT World.

Our students work
with the Best

Related eBooks

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us