Learn SQL with MySQL Ashwin Pajankar
- Autor:
- Ashwin Pajankar
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 132
- Dostępne formaty:
-
ePubMobi
Zostało Ci
na świąteczne zamówienie
opcje wysyłki »
opcje wysyłki »
Opis
książki
:
Learn SQL with MySQL
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
Your LinkedIn Profile: https://www.linkedin.com/in/ashwinpajankar/
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
Your LinkedIn Profile: https://www.linkedin.com/in/ashwinpajankar/
Ashwin Pajankar - pozostałe książki
-
BBC Micro:bit in Practice is a comprehensive guide for those looking to use the BBC Micro:bit to develop creative projects using MicroPython. It helps you to easily understand the essentials of MicroPython and explore the exciting hardware features of the Micro:bit such as radio, built-in accelerometer and compass with accelerometer, and GPIO.-
- PDF + ePub 107 pkt
(29,90 zł najniższa cena z 30 dni)
107.10 zł
119.00 zł (-10%) -
-
You will learn the basics of hardware and software required for image processing and computer vision with Raspberry Pi and Python 3. You will have a look at all the major image processing, manipulation, and computer vision techniques and algorithms in detail using engaging examples. You will build a lot of real-life computer vision applications.-
- PDF + ePub + Mobi 98 pkt
(29,90 zł najniższa cena z 30 dni)
98.10 zł
109.00 zł (-10%) -
-
Looking for inspiration for your next Raspberry Pi project? Not sure where to begin? This Learning Path is the perfect place to begin, providing you with an accessible yet comprehensive journey through Raspberry Pi. Following three modules, you’ll soon be confident and prepared to get creative with your microcomputer. Raspberry Pi by Example is the-
- PDF + ePub + Mobi 233 pkt
(29,90 zł najniższa cena z 30 dni)
233.10 zł
259.00 zł (-10%) -
-
Want to put your Raspberry Pi through its paces right out of the box? This tutorial guide is designed to get you learning all the tricks of the Raspberry Pi through building complete, hands-on hardware projects. Speed through the basics and then dive right in to development!Discover that you can do almost anything with your Raspberry Pi with a tast-
- PDF + ePub + Mobi 107 pkt
(29,90 zł najniższa cena z 30 dni)
107.10 zł
119.00 zł (-10%) -
Szczegóły książki
- ISBN Ebooka:
- 978-93-898-9808-8, 9789389898088
- Data wydania ebooka :
-
2024-12-12
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna
z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie.
Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- 1
- Rozmiar pliku ePub:
- 2.5MB
- Rozmiar pliku Mobi:
- 2.5MB
BPB Publications - inne książki
-
Description This book comprehensively covers essential topics ranging from the fundamentals of cybersecurity to advanced hacking concepts, cyber law, malware detection, wireless networking, and strategies for staying secure in the digital world. This book starts with networking and security basics, covering network models, communication protocols,-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Unlock the power of AWS and elevate your cloud expertise with "Mastering AWS for Cloud Professionals." This comprehensive guide illuminates the path to cloud mastery, offering a blend of theoretical knowledge and practical expertise. Dive deep into Amazon Web Services (AWS), exploring its vast potential to revolutionize business operati-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book explores how AI, blockchain, and the IoT can work together to build a more sustainable and efficient tech ecosystem. This book breaks down complex concepts, making them accessible to readers of all backgrounds. By focusing on the convergence of these technologies, it reveals how they are shaping a future where autonomous syste-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book offers a comprehensive overview of the Mendix platform from a developer's perspective. This powerful technology breaks down barriers, allowing anyone, with or without coding experience, to build custom applications quickly and efficiently with a solid foundation for platform evaluation. Key topics include Mendix's database des-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book will cover the entire System Center at the latest release of 2022. Here, we will cover various grounds by not only covering the purpose of each product within the System Center suite but also introducing all the latest features and updates that come with each product. Windows System Center 2022 is a complete toolkit for simpli-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Introducing "Salesforce Automation with Salesforce Flow and Apex", a practical guide designed for anyone wanting to learn Salesforce automation. Whether you are just starting out or looking to build on your existing skills, this book is here to help you navigate the world of Salesforce flow and automation techniques. This book provides-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Adopting AI for Business Transformation offers a comprehensive guide for businesses ready to transition into AI and automation and transform their operations and ways of working. The book focuses on various industries providing practical insights and step-by-step guides for AI adoption and integration. Through real-world examples, exper-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Mastering AWS Elastic Kubernetes Services" is your comprehensive guide to understanding and implementing AWS EKS. This book helps you master Kubernetes, the industry-standard container orchestration platform, on the robust and scalable Amazon Web Services (AWS) cloud. This book is a complete guide to Kubernetes and AWS EKS, starting wit-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications. Thi-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Get answers to frequently asked questions on Data Science and Machine Learning using R Key Features Understand the capabilities of the R programming language Most of the machine learning algorithms and their R implementation covered in depth Answers on conceptual data science concepts are also covered Description This book prepares you for the-
- ePub + Mobi 67 pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@ebookpoint.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Oceny i opinie klientów: Learn SQL with MySQL Ashwin Pajankar (0)
Weryfikacja opinii następuje na podstawie historii zamowień na koncie Użytkownika umiejszczającego opinię.