BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Learn SQL with MySQL

Learn SQL with MySQL

Learn SQL with MySQL
Stock photo: cover may vary

Learn SQL with MySQL Paperback - 2020

by Ashwin Pajankar

Add to wish list
  • New
  • Paperback
New

Description

BPB Publications, 2020. Paperback. New.
Ask the seller a question Add to wish list
A$14.65
A$22.00 Delivery to USA
Standard delivery: 20 to 30 days
More delivery options
Ships from Sanctum Books (Delhi, India)
The BIBLIO Guarantee

Details

  • Title Learn SQL with MySQL
  • Author Ashwin Pajankar
  • Binding Paperback
  • Condition New
  • Pages 134
  • Volumes 1
  • Language ENG
  • Publisher BPB Publications
  • Publication date 2020
  • Bookseller's Inventory # BPB-9789389898088
  • ISBN 9789389898088 / 9389898080
  • Weight 0.42 lbs (0.19 kg)
  • Dimensions 9 x 6 x 0.29 in (22.86 x 15.24 x 0.74 cm)
  • Category Computers - Languages / Programming
  • Quantity available 500

About Sanctum Books Delhi, India

Specialising in: Art, Archaeology, Art History, And Architecture, Dictionaries And Encyclopaedias, Indian History, Languages, Literature, And Linguistics, Music, Dance, Theatre, And Cinema, Numismatics, Philately, And Epigraphy, Philosophy & Philosophy Of Science, Religion (Buddhism, Jainism, Hinduism, Sikhism, And Islam)
Biblio member since 2010

We are leading publishers, booksellers, distributors, importers, and exporters. We carry a large selection of books on varied subjects. Do place your valued order or let us know your requirement via email.

Terms of Sale:

30 day return guarantee, with full refund including shipping costs for up to 30 days after delivery if an item arrives misdescribed or damaged.

�

Books are shipped by Registered Air Mail or DHL/FedEx/Aramex. Additional shipping charges may be required for multi-volume sets.

Browse books from Sanctum Books

Reader reviews for Learn SQL with MySQL

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

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.

    • 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

    Your LinkedIn Profile: https: //www.linkedin.com/in/ashwinpajankar/

    Please wait a moment while we load the requested page.

    tracking-