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

Introduction

Let's practice updating database records
Tour of CoderPad

Updating Database Records

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

Conclusion

Next steps in advanced SQL