Microsoft SQL training exercises | Views

Showing exercises 1-6 (out of 6)

Category: SQL
Topic: Views
Level: Relatively easy
Course: Introduction to SQL
Exercise: Use the view designer to create a view, and change it in SQL.

Go to exercise ...

Category: SQL
Topic: Views
Level: Relatively easy
Course: Introduction to SQL
Exercise: Script a view in the query window to show all events occurring in 2000, then modify this in the view designer.

Go to exercise ...

Category: SQL
Topic: Views
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a simple view joining 2 tables together, then script a simple change to it.

Go to exercise ...

Category: SQL
Topic: Views
Level: Average difficulty
Course: Introduction to SQL
Exercise: Script a view in a query, then use the view designer to edit it.

Go to exercise ...

Category: SQL
Topic: Views
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create a view listing for each country the number of events (with various criteria), then turn this view into well-formatted SQL.

Go to exercise ...

Category: SQL
Topic: Views
Level: Harder than average
Course: Introduction to SQL
Exercise: Use views based on views to show Doctor Who episodes with only 1 enemy and 1 companion.

Go to exercise ...

This page has 0 threads Add post