SQL Server: Views

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

Lab Details

Description

A view is a virtual table that acts like a regular table but doesn't store its own data. Instead, it relies on a predefined query to retrieve data from one or more underlying tables.

In this lab, you will be learning how to use Views in SQL Server.


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

  1. Create a View that lists customers from Sweden.
  2. Add a City Column to the existing SwedishCustomer View.

Lab Objective

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

  • Gain Hands-On Experience with SQL Server Views.

Prerequisites

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


Self-paced Membership
  • 22+ Video Courses
  • 800+ Hands-On Labs
  • 400+ Quick Notes
  • 55+ Skill Tests
  • 45+ 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