Learn SQL with MySQL
Retrieve and Manipulate Data Using SQL Commands with Ease
1st Edition
Published on 1. August 2020
132 pages
978-93-89898-13-2 (ISBN)
Description
No detailed description available for "Learn SQL with MySQL".
More details
Other editions
Additional editions
Ashwin Pajankar
Learn SQL with MySQL
Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition)
Book
07/2020
BPB Publications
€37.32
Available (delivery time upon request)
Content
- 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
