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 is SQL?
What are the different subdivisions of SQL?
What are the elements of a SQL statement?
What are the reasons to normalize a database?
What are the levels of database normalization?
What is data integrity?
What are the different ways you can enforce data integrity?
What types of RDMS exist?
What is the main advantage of MySQL?
What is the main disadvantage of Oracle and SQL Server?

You have been reading a chapter from

Learn SQL Database Programming

Published in: May 2020

Publisher: Packt

ISBN-13: 9781838984762

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 AU $24.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