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
Related courses
- PHP: Accessing Databases with PDO and MySQLi
- MySQL Database Administration
- SQL Practice: Deleting Data with DELETE Statements
- Advanced SQL Practice: Schema Changes
- Advanced SQL Practice: UPDATE Database Records
- Advanced SQL Practice: INSERT Operations
- Advanced SQL Practice: Manage Tables
- SQL Practice: Window Functions
Related learn paths
- Advance your Skills as a PHP Developer: Working with Data
- Data Engineering Foundations Professional Certificate by Astronomer
- Develop Your NoSQL Skills
- Build Your Ruby on Rails Skills
- Become a Full-Stack Web Developer
- Become a Software Developer
- Become a Corporate Financial Planning Analyst
- Explore a Career in Database Development