Microsoft SQL training exercises | Basic joins

Showing exercises 1-8 (out of 8)

Category: SQL
Topic: Basic joins
Level: Relatively easy
Course: Introduction to SQL
Exercise: Use an inner join to link two tables together in a query.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a query using the designer, joining 2 tables, then tidy it up and comment its SQL.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Average difficulty
Course: Introduction to SQL
Exercise: Join two tables together in SQL, using alias table names.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Average difficulty
Course: Introduction to SQL
Exercise: Link the continent, country and event tables with inner joins, and then filter by fields from 2 tables.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create an inner join in a query, then change it to an outer join to show categories having no events.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Average difficulty
Course: Introduction to SQL
Exercise: Use inner joins to link four tables to show Dr Who enemies by author.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Harder than average
Course: Introduction to SQL
Exercise: Use inner joins to link lots of tables together, with a WHERE clause.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Harder than average
Course: Introduction to SQL
Exercise: Use an outer join and criterion to list out the countries which have no corresponding events.

Go to exercise ...

This page has 0 threads Add post