{"product_id":"learn-sql-with-mysql-retrieve-and-manipulate-data-using-sql-commands-with-ease-english-edition-paperback-1","title":"Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition) - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eAshwin Pajankar\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003cb\u003e A step-by-step guide that will help you manage data in a relational database using SQL with ease \u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eKey Features\u003c\/b\u003e\u003c\/p\u003e\u003cli\u003eUnderstand the concepts related to relational databases. \u003c\/li\u003e\u003cli\u003e Learn how to install MariaDB and MySQL on Windows, Linux and tools to access it. \u003c\/li\u003e\u003cli\u003e Learn how to connect Python and Pandas to MySQL\/MariaDB.\u003c\/li\u003e\u003cbr\u003e\u003cb\u003eDescription\u003c\/b\u003e\u003cbr\u003e 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. \u003cbr\u003e\u003cbr\u003eThe 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. \u003cbr\u003e\u003cbr\u003e\u003cb\u003eWhat will you learn\u003c\/b\u003e\u003cbr\u003e \u003cli\u003e Understand the basics of MySQL and MariaDB.\u003c\/li\u003e\u003cli\u003eGet familiar with MySQL Arithmetic Operators, DDL, DML, DCL \u0026amp; TCL commands.\u003c\/li\u003e\u003cli\u003eUnderstand the concept of Single-Row Functions and Group Functions in detail.\u003c\/li\u003e \u003cli\u003eRetrieve data from multiple sources using the Joins. \u003c\/li\u003e\u003cbr\u003e \u003cb\u003eWho this book is for\u003c\/b\u003e\u003cbr\u003eThis 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. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e 1. Introduction and Installation\u003cbr\u003e2. Getting Started with MySQL\u003cbr\u003e3. Getting Started with SQL Queries\u003cbr\u003e4. The WHERE clause in detail\u003cbr\u003e5. Single Row Functions\u003cbr\u003e6. Group Functions\u003cbr\u003e7. Joins in MySQL\u003cbr\u003e8. Subqueries\u003cbr\u003e9. DDL, DML, and Transactions\u003cbr\u003e10. Views\u003cbr\u003e11. Python 3, MySQL, and Pandas \u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e \u003cb\u003eAshwin\u003c\/b\u003e 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.\u003cbr\u003e\u003cbr\u003e 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.\u003cbr\u003e Outside work, Ashwin volunteers his spare time as a STEM Ambassador, helping, coaching, and mentoring young people in taking up careers in technology.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eYour Blog links: \u003c\/b\u003e https: \/\/www.youtube.com\/ashwinpajankar\u003cbr\u003e\u003cbr\u003e\u003cb\u003eYour LinkedIn Profile: \u003c\/b\u003e https: \/\/www.linkedin.com\/in\/ashwinpajankar\/\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 134\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.29 x 9 x 6 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e July 17, 2020\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47214982824185,"sku":"9789389898088","price":30.98,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/uqDiLv-3fx9789389898088_492cd25d-1947-4544-805f-91cf74c14bea.webp?v=1768116626","url":"https:\/\/bookscloud.io\/products\/learn-sql-with-mysql-retrieve-and-manipulate-data-using-sql-commands-with-ease-english-edition-paperback-1","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}