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

Section 3: Advanced SQL Querying

With the foundations of basic SQL now under your belt, you will learn about more advanced SQL techniques, including how to use expressions, aggregate functions, flow control statements, error handling, subqueries, and common table expressions. You will also learn how to create programmable objects such as views, triggers, stored procedures, variables, and temporary tables.

This section comprises the following chapters:

Chapter 9, Working with Expressions
Chapter 10, Grouping and Summarizing Data
Chapter 11, Advanced Querying Techniques
Chapter 12, Programmable Objects

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