Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Learn SQL Database Programming Query and manipulate databases from popular relational database servers using SQL

Product type Paperback

Published in May 2020

Publisher Packt

ISBN-13 9781838984762

Length 564 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Programming

Author (1):

Josephine Bush

View More author details

Table of Contents (24) Chapters

Preface

1. Section 1: Database Fundamentals

2. Introduction to Relational Database Management Systems FREE CHAPTER

3. Installing and Using MySQL Workbench

4. Understanding Data Types

5. Designing and Creating a Database

6. Importing and Exporting Data

7. Section 2: Basic SQL Querying

8. Querying a Single Table

9. Querying Multiple Tables

10. Modifying Data and Table Structures

11. Section 3: Advanced SQL Querying

12. Working with Expressions

13. Grouping and Summarizing Data

14. Advanced Querying Techniques

15. Programmable Objects

16. Section 4: Presenting Your Findings

17. Exploring and Processing Your Data

18. Telling a Story with Your Data

19. Section 5: SQL Best Practices

20. Best Practices for Designing and Querying

21. SQL Appendix

22. Assessments

23. Other Books You May Enjoy

Leave a review - let other readers know what you think

Questions

What operating systems can you install MySQL Workbench on?
How do you check the status of the MySQL service on Mac?
How do you connect to your or another instance of MySQL in MySQL Workbench?
How do you restore a database in MySQL Workbench?
How can you view the duration/fetch time for a query?
How can you view the column names and types for a table in MySQL Workbench?
How do you hide the secondary sidebar in MySQL Workbench?
Where can you find a history of the queries you've executed in MySQL Workbench?
How can you see how many rows a query returned in MySQL Workbench?
How do you select 1,000 rows from a table in MySQL Workbench?

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Josephine Bush

Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.

See other products by Josephine Bush