Microsoft SQL training exercises (page 1 of 6)

Showing exercises 1-20 (out of 115)

Category: SQL
Topic: Creating databases - overview
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create a new database of dates in history, consisting of 2 tables, setting the primary key for each and creating a database diagram linking them.

Go to exercise ...

Category: SQL
Topic: Creating databases - overview
Level: Harder than average
Course: Introduction to SQL
Exercise: Design a database to hold rental and membership information for a DVD library.

Go to exercise ...

Category: SQL
Topic: Simple Queries
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a simple query to list historical events, with the most recent first.

Go to exercise ...

Category: SQL
Topic: Simple Queries
Level: Relatively easy
Course: Introduction to SQL
Exercise: List the names of the Doctors in alphabetical order using SELECT.

Go to exercise ...

Category: SQL
Topic: Simple Queries
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create a query to list out the first half of countries (using TOP 50 PERCENT).

Go to exercise ...

Category: SQL
Topic: Simple Queries
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a query to list out details from a table to text, using the PRINT statement to create a header.

Go to exercise ...

Category: SQL
Topic: Simple Queries
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a single query to show the top and bottom 5 events in alphabetical order.

Go to exercise ...

Category: SQL
Topic: Setting criteria using WHERE
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a query listing all of the historical events which have happened in Germany in the 1940s.

Go to exercise ...

Category: SQL
Topic: Setting criteria using WHERE
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create a query to show all of the events which involved Concorde in the title which took place in France.

Go to exercise ...

Category: SQL
Topic: Setting criteria using WHERE
Level: Harder than average
Course: Introduction to SQL
Exercise: Create various simple queries, showing the use of IS NULL for criteria and date criteria.

Go to exercise ...

Category: SQL
Topic: Setting criteria using WHERE
Level: Harder than average
Course: Introduction to SQL
Exercise: Show all historical events for which either of two complicated combinations of criteria is true.

Go to exercise ...

Category: SQL
Topic: Outputting to Excel
Level: Average difficulty
Course: Introduction to SQL
Exercise: Create a query to output a results set of historical events to an Excel workbook.

Go to exercise ...

Category: SQL
Topic: Calculations
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a query to show for each event in history the length of the description entered.

Go to exercise ...

Category: SQL
Topic: Calculations
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a query to show the country and the continent id (or 0, if this is null) using ISNULL or COALESCE.

Go to exercise ...

Category: SQL
Topic: Calculations
Level: Average difficulty
Course: Introduction to SQL
Exercise: List out great events in history, using a CASE statement to show one of three regional areas for each.

Go to exercise ...

Category: SQL
Topic: Calculations
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a query combining text and numbers, using LEN to find the length of a word and CAST to convert this to string.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Relatively easy
Course: Introduction to SQL
Exercise: Format each date in a table, then show how long ago it was (in whole years) using DateDiff.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Average difficulty
Course: Introduction to SQL
Exercise: Show the closest events to your birthday, using DATEDIFF, CONVERT and ABS functions.

Go to exercise ...

Category: SQL
Topic: Calculations using dates
Level: Harder than average
Course: Introduction to SQL
Exercise: Create a query showing the full date in the format: dddd dd mmmm yyyy, using DatePart or DateName, then show all events happening on Friday 13th.

Go to exercise ...

Category: SQL
Topic: Basic joins
Level: Relatively easy
Course: Introduction to SQL
Exercise: Create a query listing countries and continents, using an inner join with table aliases.

Go to exercise ...

This page has 0 threads Add post