Learn SQL with MySQL

Name: Learn SQL with MySQL | Retrieve and Manipulate Data Using SQL Commands with Ease
Brand: De Gruyter
Price: 14.49 EUR
Availability: OnlineOnly

Retrieve and Manipulate Data Using SQL Commands with Ease

Ashwin Pajankar(Autor*in)

De Gruyter (Verlag)

1. Auflage

Erschienen am 1. August 2020

132 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-93-89898-13-2 (ISBN)

14,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Title Page
Copyright Page
Dedication
About the Author
About the Reviewer
Acknowledgement
Preface
Errata
Table of Contents
1. Introduction and Installation
Structure
Objective
Databases, DBMS, and SQL
A Bit of Hands-on with SQL
MySQL
Install MySQL on Windows
MariaDB
Installation on Windows
Installation on Debian and Raspberry Pi Raspbian Linux
Conclusion
Points to Remember
MCQ
Answers to MCQ
Questions
Key Terms
2. Getting Started with MySQL
Structure
Objective
Connecting to MySQL and MariaDB Server Instances
Connection with MySQL Workbench
Connecting with HeidiSQL
Connecting with Command Prompt
Connecting to a Remote Instance
A few Basic Queries
Exercise
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms
3. Getting Started with SQL Queries
Structure
Objective
Getting Started with Simple SQL Statements
Selection and Projection
Arithmetic Operators and Precedence
Column Aliases
NULL
DISTINCT
Conclusion
Points to Remember
MCQs
Answer to MCQ
Questions
Key Terms
4. The WHERE Clause in Detail
Structure
Objective
The WHERE Clause
The comparison operators
LIKE Operator
Comparing with NULL
Logical Operations
Sorting the Resultset
Working with Dates
Conclusion
Points to Remember
MCQs
Answer to MCQs
Questions
Key Terms
5. Single Row Functions
Structure
Objective
Single Row Functions
The Dual Table
The Case Manipulation Functions
The Character Manipulation Functions
Number Manipulation Functions
Date Manipulation Functions
Datetime to String and Vice Versa
NULL Handling
CASE Statement
Nested Single Row functions
Conclusion
Points to Remember
MCQs
Answer to MCQs
Questions
Key Terms
6. Group Functions
Structure
Objective
Group Functions
The GROUP BY Clause
HAVING
Conclusion
Points to Remember
MCQs
Answer to MCQs
Questions
Key Terms
7. Joins in MySQL
Structure
Objective
Concept of Joins
Cross Join
Simple/Inner and Natural Joins
Outer Joins
Multi-Condition and Multi-Source Join
Self-Join
Non-equijoin
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms
8. Subqueries
Structure
Objective
Subquery
Correlated Subquery
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms
9. DDL, DML, and Transactions
Structure
Objective
Tables and Data Dictionary
DDL Statements
Transactions and DML Statements
The Truncate Operation
Create Table As
Constraints
Drop a Database
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms
10. Views
Structure
Objective
Concept of Views
Simple Views
Complex Views
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms
11. Python 3, MySQL, and Pandas
Structure
Objective
Installation of Python 3
Running a Python 3 Program
MySQL and Python 3
MySQL and Pandas
Conclusion
Points to Remember
MCQ
Answer to MCQ
Questions
Key Terms

Systemvoraussetzungen

Als PDF speichern Als Link merken