SQL exercises on BASIC JOINS

This page lists the 8 exercises about Basic joins in SQL on our website:

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
Topic: Basic joins
Level: Average difficulty
Course: Introduction to SQL
Exercise: Join two tables together in SQL, using alias table names.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

Software: SQL
Version: Any version of SQL Server
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 ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post