

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
Brand, Ashwin Pajankar
Pages, 134
Language, English
Count , 1
Edition, 1
Author, Bpb Publications
Brand
Ashwin Pajankar
Pages, 134
Pages
134
Language, English
Language
English
Count , 1
Count
1
Edition, 1
Edition
1
Author, Bpb Publications
Author
Bpb Publications
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
Brand
Ashwin Pajankar
Pages
134
Language
English
Count
1
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
Enjoy and learn Arabic language استمتع و تعلم ا&, (Paperback) $7.99
$799current price $7.99Enjoy and learn Arabic language استمتع و تعلم ا&, (Paperback)
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)
7004.6 out of 5 Stars. 700 reviews4.6 out of 5 starsSerie 1 Parcours d'Apprentissage - Colle Verset "Al Kursi" mots-mêlés & labyrinthes Parcours d'apprentissage Collection "Les Indispensables" Apprendre en s'amusa, (Paperback) $11.44
$1144current price $11.44Serie 1 Parcours d'Apprentissage - Colle Verset "Al Kursi" mots-mêlés & labyrinthes Parcours d'apprentissage Collection "Les Indispensables" Apprendre en s'amusa, (Paperback)
In 200+ people's carts, Harry Potter Advanced Coloring Book – 64 Pages of Intricate Designs for Teens & Adults – Bendon Art Activity Book, Paperback $3.00
In 200+ people's carts
$300current price $3.00Harry Potter Advanced Coloring Book – 64 Pages of Intricate Designs for Teens & Adults – Bendon Art Activity Book, Paperback
2564.7 out of 5 Stars. 256 reviews4.7 out of 5 starsChakra Book: Learn.Color.Align, (Paperback) $18.99
$1899current price $18.99Chakra Book: Learn.Color.Align, (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)
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)
Pâques - Livre d'activités pour enfants: 70 jeux et activités amusants spécial Pâques pour enfants de 4 à 7 ans - L, (Paperback) $11.74
$1174current price $11.74Pâques - Livre d'activités pour enfants: 70 jeux et activités amusants spécial Pâques pour enfants de 4 à 7 ans - L, (Paperback)
Für Dummies Segeln für Dummies, (Paperback) $21.71
$2171current price $21.71Für Dummies Segeln für Dummies, (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)
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)
Een andere Wiskunde [kleur], (Paperback) $17.47
$1747current price $17.47Een andere Wiskunde [kleur], (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)
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)
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)
Connection: English Akan My First Akan Bible: Colour and Learn, Book 3, (Paperback) $10.01
$1001current price $10.01Connection: English Akan My First Akan Bible: Colour and Learn, Book 3, (Paperback)
Arctic Land Binary Code: Fun and Educational Binary Code Coloring Game for Kids Parties and Classroom Activities, Learn , (Paperback) $12.00
$1200current price $12.00Arctic Land Binary Code: Fun and Educational Binary Code Coloring Game for Kids Parties and Classroom Activities, Learn , (Paperback)
Landeskunde des Karolinen-Archipels (Paperback) $22.90
$2290current price $22.90Landeskunde des Karolinen-Archipels (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 Sat, Nov 21
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 Beginner's Guides To Java Programming
- Best Sellers In Books Beginners Guides Java Programming
- Best Sellers In Books Computer Algorithms
- Sql Queries For Mere Mortals
- Word Processing Books
- JavaScript Programming Language Books
- Mathematical & Statistical Software Books
- SQL Programming Language Books
- Computers & Information Technology Industry Books
- Desktop Applications Databases Books
