562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
First (if you haven't already done so) run the script shown above to generate the Doctor Who training database.
Using the following tables, create a query to show all of the episodes which feature enemies containing the letters Dalek:
The tables you'll need for this query.
This query should return 16 rows when you run it:
The first few of the 16 episodes featuring Daleks, sorted by series and episode number.
Now change this query into a stored procedure called spEnemyEpisodes, which lists out all of the episodes featuring a given enemy. Here are some results you should get when you try running this stored procedure with different parameters:
|Procedure||Number of rows returned|
|spEnemyEpisodes 'ood'||4 (the episodes featuring the Ood)|
|spEnemyEpisodes 'auton'||1 (episode featuring the Auton)|
|spEnemyEpisodes 'silence'||5 (episodes featuring the Silence)|
Optionally, save this as Oodve thought it.sql, then close it down, reflecting on what a terrible pun this is.
25 Aytoun Street