Rating: 0 out of 5 stars
0 ratings
Ebook244 pages1 hour
Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease
Rating: 0 out of 5 stars
()
About this ebook
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.
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.
LanguageEnglish
PublisherBPB Online LLP
Release dateJul 17, 2020
ISBN9789389898132
Read more from Ashwin Pajankar
Arduino Made Simple: With Interactive Projects Python 3 Image Processing: Learn Image Processing with Python 3, NumPy, Matplotlib, and Scikit-image Rating: 0 out of 5 stars0 ratingsRaspberry Pi By Example Rating: 0 out of 5 stars0 ratings
Related to Learn SQL with MySQL
Related ebooks
MySQL for Python Rating: 5 out of 5 stars5/5Python and SQLite Development Rating: 0 out of 5 stars0 ratingsPython For Data Science Rating: 0 out of 5 stars0 ratingsData Analysis with Python: Introducing NumPy, Pandas, Matplotlib, and Essential Elements of Python Programming (English Edition) Rating: 0 out of 5 stars0 ratingsThe 1 Page Python Book Rating: 2 out of 5 stars2/5Essential Python 3 Rating: 0 out of 5 stars0 ratingsBeginning Programming with Python For Dummies Rating: 3 out of 5 stars3/5PYTHON PROGRAMMING Rating: 4 out of 5 stars4/5Python Data Analysis - Second Edition Rating: 0 out of 5 stars0 ratingsPython: Advanced Guide to Programming Code with Python Rating: 0 out of 5 stars0 ratingsPython for Developers: Learn to Develop Efficient Programs using Python Rating: 0 out of 5 stars0 ratingsPython Machine Learning Illustrated Guide For Beginners & Intermediates:The Future Is Here! Rating: 5 out of 5 stars5/5The Ultimate Python Programming Guide For Beginner To Intermediate Rating: 4 out of 5 stars4/5Python for Beginners: Learn the Fundamentals of Computer Programming Rating: 0 out of 5 stars0 ratingsSQL in 30 Pages Rating: 4 out of 5 stars4/5SQL: For Beginners: Your Guide To Easily Learn SQL Programming in 7 Days Rating: 5 out of 5 stars5/5The SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5Practical SQL Rating: 4 out of 5 stars4/5Creating your MySQL Database: Practical Design Tips and Techniques Rating: 3 out of 5 stars3/5Learn SQLite in 24 Hours Rating: 0 out of 5 stars0 ratingsMastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks (English Edition) Rating: 0 out of 5 stars0 ratingsAdvanced SQL Queries: Writing Efficient Code for Big Data Rating: 5 out of 5 stars5/5
Computers For You
Alan Turing: The Enigma: The Book That Inspired the Film The Imitation Game - Updated Edition Rating: 4 out of 5 stars4/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 4 out of 5 stars4/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Elon Musk Rating: 4 out of 5 stars4/5The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 5 out of 5 stars5/5Computer Science I Essentials Rating: 5 out of 5 stars5/5The Self-Taught Computer Scientist: The Beginner's Guide to Data Structures & Algorithms Rating: 0 out of 5 stars0 ratingsThe Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5Standard Deviations: Flawed Assumptions, Tortured Data, and Other Ways to Lie with Statistics Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsQuantum Computing For Dummies Rating: 3 out of 5 stars3/5Fundamentals of Programming: Using Python Rating: 5 out of 5 stars5/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5Storytelling with Data: Let's Practice! Rating: 4 out of 5 stars4/5Data Analytics for Beginners: Introduction to Data Analytics Rating: 4 out of 5 stars4/5Tor and the Dark Art of Anonymity Rating: 5 out of 5 stars5/5Learning the Chess Openings Rating: 5 out of 5 stars5/5
Reviews for Learn SQL with MySQL
Rating: 0 out of 5 stars
0 ratings
0 ratings0 reviews
Book preview
Learn SQL with MySQL - Ashwin Pajankar
CHAPTER 1
Introduction and Installation
Irecommend all the readers to read the preface and the table of contents. It has a lot of information about what we can expect in the book. So, if you have not read it, I recommend going through it line by line.
In this chapter, we are going to start the exciting journey of learning SQL with widely used and adopted open-source database software MySQL and MariaDB. We will also have a look at a few essential concepts that are important before we start hands-on. Finally, we will learn in detail how to install MySQL and MariaDB on major OS platforms. So, let us start an incredible journey of learning SQL with MySQL and MariaDB.
Structure
We will learn the following topics in this chapter:
Basic concepts related to Databases, DBMS, and SQL
Hands-on with SQL using Tryit Online SQL Editor.
MySQL and its installation on Windows
MariaDB and installation on Windows and Linux
Objective
The objective of this chapter is to make the readers comfortable with the basic concepts related to the topic of the Database. Also, the readers will be able to install the MySQL and MariaDB on the different Operating Systems. Readers will also learn to use an online SQL Editor, the Tryit Online SQL Editor. All the software that we learn to install in this chapter will be used throughout the rest of the book.
Databases, DBMS, and SQL
A database is data collected and stored in an organized form. It can be stored, accessed, and processed in electronic format or in the paper-format too. Before the advent of computers, people and organizations used to store records in tabular forms in books and papers. These were precursors to modern relational database systems. Today, in the 21st century, we store and process almost all the databases in the electronic
Enjoying the preview?
Page 1 of 1