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

Modifying Data and Table Structures

In this chapter, you will learn how to modify data in tables. This includes learning how to use the INSERT, UPDATE, and DELETE statements. You will also learn about SQL transactions, which help to better control the modification of data. Finally, you will learn how to modify table structures.

In this chapter, we will cover the following topics:

Inserting data into tables
Deleting data from tables
Updating data in tables
Using transactions to save or revert changes
Modifying the table structure

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