

Hero image 0 of Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition), (Paperback), 0 of 1
Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition), (Paperback)
(No ratings yet)
Key item features
- Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition), (Paperback)
- Author: Bpb Publications
- ISBN: 9789389898088
- Format: Paperback
- Publication Date: 2020-07-17
- Page Count: 134
Specs
Publication date, July, 2020
Author, Bpb Publications
Book format, Paperback
Genre, Computing & Internet
Pages, 134
Age group, Adult
Publication date
July, 2020
Author, Bpb Publications
Author
Bpb Publications
Book format, Paperback
Book format
Paperback
Genre, Computing & Internet
Genre
Computing & Internet
Pages, 134
Pages
134
Age group, Adult
Age group
Adult
About this item
Product details
A step-by-step guide that will help you manage data in a relational database using SQL with ease
Key FeaturesUnderstand 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.
Description
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
10. Views
11. Python 3, MySQL, and Pandas
About the Author
Ashwin is an experienced veteran who, for the past 25 years, has been working with STEM (Science, Technology, Engineering, and Mathematics). In his career, Ashwin has worked for more than 7 years as an employee for various IT companies and Software Product Companies. He has written more than 2 dozen books on Arduino, Python programming, Computer Vision, IoT, databases, and other popular topics with BPB and other international publications. He has also reviewed many other technical books. He also creates courses for BPB and other platforms and teaches to 60000 students online.
He has been working as a freelancer since 2017. He got his first taste in writing in 2015 when he wrote his first book on Raspberry Pi. In his free time, Ashwin makes videos for his Youtube channel, which has 10000 subscribers now.
Outside work, Ashwin volunteers his spare time as a STEM Ambassador, helping, coaching, and mentoring young people in taking up careers in technology.
Your Blog links: https: //www.youtube.com/ashwinpajankar
&l
Key Features
Description
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
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
10. Views
11. Python 3, MySQL, and Pandas
About the Author
Ashwin is an experienced veteran who, for the past 25 years, has been working with STEM (Science, Technology, Engineering, and Mathematics). In his career, Ashwin has worked for more than 7 years as an employee for various IT companies and Software Product Companies. He has written more than 2 dozen books on Arduino, Python programming, Computer Vision, IoT, databases, and other popular topics with BPB and other international publications. He has also reviewed many other technical books. He also creates courses for BPB and other platforms and teaches to 60000 students online.
He has been working as a freelancer since 2017. He got his first taste in writing in 2015 when he wrote his first book on Raspberry Pi. In his free time, Ashwin makes videos for his Youtube channel, which has 10000 subscribers now.
Outside work, Ashwin volunteers his spare time as a STEM Ambassador, helping, coaching, and mentoring young people in taking up careers in technology.
Your Blog links: https: //www.youtube.com/ashwinpajankar
&l
- Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition), (Paperback)
- Author: Bpb Publications
- ISBN: 9789389898088
- Format: Paperback
- Publication Date: 2020-07-17
- Page Count: 134
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.
Specifications
Publication date
July, 2020
Author
Bpb Publications
Book format
Paperback
Genre
Computing & Internet
Warranty
Warranty information
Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.
Similar items you might like
Based on what customers bought
In 200+ people's carts, Color & Frame Large Print Easy Color & Frame - Stress Free (Adult Coloring Book), (Spiral-Bound) $6.42 Was $7.98
In 200+ people's carts
$642current price $6.42, Was $7.98$7.98Color & Frame Large Print Easy Color & Frame - Stress Free (Adult Coloring Book), (Spiral-Bound)
7124.6 out of 5 Stars. 712 reviews4.6 out of 5 stars100+ bought since yesterday, Harry Potter Advanced Coloring Book – 64 Pages of Intricate Designs for Teens & Adults – Bendon Art Activity Book, Paperback $3.00
100+ bought since yesterday
$300current price $3.00Harry Potter Advanced Coloring Book – 64 Pages of Intricate Designs for Teens & Adults – Bendon Art Activity Book, Paperback
2604.7 out of 5 Stars. 260 reviews4.7 out of 5 starsGrammaire De La Langue Fiote: Dialecte Du Kakongo, (Paperback) $20.95
$2095current price $20.95Grammaire De La Langue Fiote: Dialecte Du Kakongo, (Paperback)
Apprenez le cahier d'exercices japonais Kanji N5: Le guide d'étude facile et étape par étape et le livre de pratique d'é, (Hardcover) $19.99
$1999current price $19.99Apprenez le cahier d'exercices japonais Kanji N5: Le guide d'étude facile et étape par étape et le livre de pratique d'é, (Hardcover)
Leaders Time Management Skills, (Paperback) $21.99
$2199current price $21.99Leaders Time Management Skills, (Paperback)
Urdu Children's Book: Cute Animals to Color and Practice Urdu, (Paperback) $9.99
$999current price $9.99Urdu Children's Book: Cute Animals to Color and Practice Urdu, (Paperback)
Polish Children's Book: The Wonderful Wizard Of Oz, (Paperback) $6.99
$699current price $6.99Polish Children's Book: The Wonderful Wizard Of Oz, (Paperback)
Bulgarian Children's Book: The Wonderful Wizard Of Oz, (Paperback) $6.99
$699current price $6.99Bulgarian Children's Book: The Wonderful Wizard Of Oz, (Paperback)
Tweak-its: Disorderly (Paperback) $9.99
$999current price $9.99Tweak-its: Disorderly (Paperback)
Serve with Style: Il customer service nell'era dell'esperienza, (Paperback) $19.99
$1999current price $19.99Serve with Style: Il customer service nell'era dell'esperienza, (Paperback)
Méthode Pratique De Langage Et De Lecture, D'écriture, De Calcul, Etc: à L'usage Des Ãlèves Du Cours Préparatoire Des Ãc, (Paperback) $17.95
$1795current price $17.95Méthode Pratique De Langage Et De Lecture, D'écriture, De Calcul, Etc: à L'usage Des Ãlèves Du Cours Préparatoire Des Ãc, (Paperback)
Für Dummies Segeln für Dummies, (Paperback) $21.71
$2171current price $21.71Für Dummies Segeln für Dummies, (Paperback)
Connection: English Nzema Nzema Learner's Dictionary, Book 2, (Paperback) $9.60
$960current price $9.60Connection: English Nzema Nzema Learner's Dictionary, Book 2, (Paperback)
Frutas Em Chinês Para Colorir, Ler E Escrever, (Paperback) $19.85
$1985current price $19.85Frutas Em Chinês Para Colorir, Ler E Escrever, (Paperback)
Een andere Wiskunde [kleur], (Paperback) $17.47
$1747current price $17.47Een andere Wiskunde [kleur], (Paperback)
20 Must-Learn Pictographic Simplified Ch 20 Must-learn Pictographic Simplified Chinese Workbook - 3: Coloring, Handwriting, Pinyin, (Paperback) $7.95
$795current price $7.9520 Must-Learn Pictographic Simplified Ch 20 Must-learn Pictographic Simplified Chinese Workbook - 3: Coloring, Handwriting, Pinyin, (Paperback)
Arabic Children's Book: The Wonderful Wizard Of Oz, (Paperback) $6.99
$699current price $6.99Arabic Children's Book: The Wonderful Wizard Of Oz, (Paperback)
Russian Children's Book: The Wonderful Wizard Of Oz, (Paperback) $6.99
$699current price $6.99Russian Children's Book: The Wonderful Wizard Of Oz, (Paperback)
Connection: English Sinhala My First Sinhala Counting Book: Colour and Learn 1 2 3, Book 4, (Paperback) $9.99
$999current price $9.99Connection: English Sinhala My First Sinhala Counting Book: Colour and Learn 1 2 3, Book 4, (Paperback)
1000 Vocabulaire De Base Illustré J'Apprends à Lire Apprentissage Ecriture Maternelle Cp Niveau 1: Trilingue Anglais Fra, (Paperback) $14.99
$1499current price $14.991000 Vocabulaire De Base Illustré J'Apprends à Lire Apprentissage Ecriture Maternelle Cp Niveau 1: Trilingue Anglais Fra, (Paperback)
Customer ratings & reviews
0 out of 5 stars
This item does not have any reviews yet
Current price is USD$22.95
Price when purchased online
Free 90-day returns
How do you want your item?
Try 30 days for just $1! Choose a plan at checkout.
Ships to
Arrives by Wed, Dec 2
Sold and shipped by Walmart.com
Free 90-day returns
This item is gift eligible
More seller options (2)
Starting from $22.97
Try 30 days of Walmart+ for just $1!
T&C apply. Claim offer now
Related pages
- Blockchain Algorithms
- For Dummies Book Font
- Best Sellers In Books Beginners Guides Java Programming
- Best Sellers In Books Computer Algorithms
- Sql Queries For Mere Mortals
- Update Ms Word 2016
- Word Processing Books
- JavaScript Programming Language Books
- Mathematical & Statistical Software Books
- SQL Programming Language Books
- Computers & Information Technology Industry Books
- Desktop Applications Databases Books
