Lesson 9 - MySQL Step By Step: Exercises to practise
In the previous lesson, MySQL Step By Step: More Queries And the M:N Relationship, we learned the M:N relationship, use
aliases in JOINs, and we created a new section table.
We won't learn anything new today, we're going to practice the knowledge we've
gained. We're going to come up with 10 different sample queries.
To learn something, reduce the height of your browser window so that you don't see the resulting query, but just the task description. Try to figure out the query on your own and then check it with the result.
Let's do it!
Examples
Example 1: Select the comments (their content and creation date) in the second quarter of 2012, sorted by date.
The query:
SELECT `content`, `created` FROM `comment` WHERE `created` BETWEEN '2012-3-1' AND '2012-6-30' ORDER BY `created`;
The result:
Great article! 2012-04-06 00:00:00 Good game! 2012-04-06 00:00:00 I died and... 2012-04-14 00:00:00 Great article in deed! 2012-05-06 00:00:00
Example 2:
...End of the preview...
Premium article
ict.social is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.
Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)
Article description
Requested article covers this content:
In this tutorial, we'll give you several exercises you can try to run on a MySQL database to practice and check the results with yours.
Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.
This article is licensed :Premium, by buying this article, you agree with the terms of use.
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.
You can get points immediately using:
 |
 |
 |
| Credit card | SMS | Wire transfer |
The author learned IT at the Unicorn College - a prestigious college providing education on IT and economics. 