Advanced SQL Practice: UPDATE Database Records

8mAdvanced2025-01-28

Authors

Scott Simpson

Creating Technology Courses as a Senior Staff Author at LinkedIn

Course details

Discover the essential techniques for updating and managing records in a database with this immersive SQL code challenges course. Instructor Scott Simpson shows you how to manually execute SQL queries to modify different components of a text-based chat application, including messages, contacts, and reactions. Explore database interaction tasks such as marking messages as read, updating message content, and correcting misspelled contact names. Each challenge provides step-by-step instructions, a code editor, and immediate feedback on your solutions to reinforce your learning. Engage with practical scenarios that mirror real-world applications, enhancing your confidence and fluency in SQL. When you complete this course, you'll have a solid grasp of essential update operations and how to apply them to your own projects.

Learning objectives
Apply real-world task requests to an existing complex database.
Explain how an UPDATE operation in SQL works and what considerations to keep in mind when using UPDATE.
Use UPDATE operations safely.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Let's practice updating database records
02 - Tour of CoderPad

1. Updating Database Records

03 - Solution - Edit the text of a message
04 - Solution - Mark a message as read
05 - Solution - Edit a contact's name
06 - Solution - Mark a range of messages as unread
07 - Solution - Change a reaction on a message

Conclusion

08 - Next steps in advanced SQL