Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
This page lists the 12 exercises about Basic joins in SQL on our website:
Software: | SQL |
Topic: | Basic joins |
Level: | Relatively easy |
Exercise: | Create a query containing a join to list out those films whose source is NA. |
Software: | SQL |
Topic: | Basic joins |
Level: | Relatively easy |
Exercise: | Create a query using the designer, joining 2 tables, then tidy it up and comment its SQL. |
Software: | SQL |
Topic: | Basic joins |
Level: | Relatively easy |
Exercise: | Use an inner join to link two tables together in a query. |
Software: | SQL |
Topic: | Basic joins |
Level: | Relatively easy |
Exercise: | Use the Query Designer in SQL Server Management Studio to join multiple tables in a database of music. |
Software: | SQL |
Topic: | Basic joins |
Level: | Average difficulty |
Exercise: | Create an inner join in a query, then change it to an outer join to show categories having no events. |
Software: | SQL |
Topic: | Basic joins |
Level: | Average difficulty |
Exercise: | Join two tables together in SQL, using alias table names. |
Software: | SQL |
Topic: | Basic joins |
Level: | Average difficulty |
Exercise: | Link the continent, country and event tables with inner joins, and then filter by fields from 2 tables. |
Software: | SQL |
Topic: | Basic joins |
Level: | Average difficulty |
Exercise: | Use basic inner joins to list music albums and their genres before applying filters to the list. |
Software: | SQL |
Topic: | Basic joins |
Level: | Average difficulty |
Exercise: | Use inner joins to link four tables to show Dr Who enemies by author. |
Software: | SQL |
Topic: | Basic joins |
Level: | Harder than average |
Exercise: | Add joins to SQL queries to return values from multiple tables in a database of music. |
Software: | SQL |
Topic: | Basic joins |
Level: | Harder than average |
Exercise: | Use an outer join and criterion to list out the countries which have no corresponding events. |
Software: | SQL |
Topic: | Basic joins |
Level: | Harder than average |
Exercise: | Use inner joins to link lots of tables together, with a WHERE clause. |
You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.