SQL Practice: Deleting Data with DELETE Statements

Focused View

Walter Shields

32:05

0 View

01 - Introduction

01 - Course introduction.mp4

00:41

02 - What you should know.mp4

01:22

03 - How to use CoderPad.mp4

02:45

02 - 1. Introduction to Data Deletion

01 - Overview of DELETE statements.mp4

02:25

03 - 2. Basic DELETE Statements

01 - Solution Syntax and usage of DELETE.mp4

02:39

02 - Solution Deleting multiple rows.mp4

02:38

04 - 3. Conditional DELETE Statements

01 - Solution Conditional deletion.mp4

02:33

02 - Solution Using subqueries in DELETE.mp4

02:46

05 - 4. Advanced DELETE Statements

01 - Solution Deleting data based on categories.mp4

03:04

02 - Solution Handling constraints and dependencies in DELETE.mp4

03:16

06 - 5. Best Practices for Using DELETE Statements

01 - Solution Best practices for using DELETE.mp4

03:31

07 - 6. Practical Exercises and Assessments

01 - Solution Practical exercise 1 Basic DELETE.mp4

02:16

02 - Solution Practical exercise 2 Advanced DELETE.mp4

02:09

08 - Conclusion

Description

In this course, learn how to delete data from SQL tables effectively. The course covers the DELETE statement, using WHERE clauses to target specific rows, and verifying deletions with SELECT statements. If you’re looking to manage and clean up your database by deleting unnecessary data, this course is for you.

This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice alongside the course content to advance your programming skills.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Walter Shields

Instructor's Courses

Walter Shields is known as a Best-Selling Author, Mentor and SME in Data Analytics. He has over 25 years of experience training students and managing data systems for startups to Fortune 500 companies, from law to healthcare to big-box retail. Through his educational books and courses, Walter reaches a growing number of students and corporate organizations, training them to master skills and tools in data management, analysis, and visualization. An expert in data analysis training & solutions, Walter is a published and Best-Selling Author of “SQL Quickstart Guide”. Current partnerships include: • Manning Publishing - New Data Analytics book to be published in 2023 • LinkedIn Learning Course Author - SQL and Data Analytics course to be released in 2023 • Microsoft Learn Partner - Power BI Data Visualization courses With his passion for teaching, Walter continues to create simplified, uncomplex, fun and effective ways for his students to confidently command skills in data analytics.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.