SQL Server: Operations on Joins

Level : Beginner
Mentor: Shailendra Chauhan
Type : GuidedLab
Points : 10
Duration : 00:35:00

Lab Details

Description

In SQL Server, UPDATE and DELETE statements can use JOINs to perform operations on multiple tables simultaneously based on specified conditions, updating or deleting records as needed.

In this lab, you will learn how to update and delete Joins in SQL Server.

Based on this Schema, generate the solutions to the respective queries listed below:

  1. Increase the unit price by 10% for all products that have been sold before.
  2. Discontinue products that have not sold.
  3. For customer Paul Henriot change the unit price to $25 for Queso Calibres in their order.
  4. Remove products that have not sold.
  5. For order number 542379 remove the Tofu.

Lab Objective

Upon completion of this lab, you will be able to:

  • Gain Hands-On Experience on how to update and delete Joins.

Prerequisites

  • You should have a conceptual understanding of Joins.
  • You must have SQL Server Installed on your systems.


Self-paced Membership
  • 24+ Video Courses
  • 825+ Hands-On Labs
  • 400+ Quick Notes
  • 125+ Skill Tests
  • 10+ Interview Q&A Courses
  • 10+ Real-world Projects
  • Career Coaching Sessions
  • Email Support
Upto 60% OFF
Know More
Still have some questions? Let's discuss.
CONTACT US
Accept cookies & close this