Advanced SQL Practice: DELETE Operations
9mAdvanced2025-02-14
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
In this course, practice using advanced SQL delete operations. Removing data from a database is often handled by a component of an application, but as instructor Scott Simpson illustrates, as you learn to work with databases it’s useful to know how to code the primary types of SQL statements by hand. Scott uses the database of a sample chat application to frame a set of code challenges so you can work with data like contacts, messages, attachments, and more.
Learning objectives
Apply real-world task requests to an existing complex database.
Explain how a DELETE operation in SQL works, and what considerations to keep in mind when using DELETE.
Use DELETE operations safely.
Learning objectives
Apply real-world task requests to an existing complex database.
Explain how a DELETE operation in SQL works, and what considerations to keep in mind when using DELETE.
Use DELETE 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 delete operations
- 02 - CoderPad tour
1. Practicing DELETE
- 03 - Solution - Delete a message
- 04 - Solution - Delete a contact
- 05 - Solution - Delete messages from a specific conversation
- 06 - Solution - Delete a conversation
- 07 - Solution - Delete messages older than a specific date
Conclusion
- 08 - Next steps in advanced SQL