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.
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