As per @Richard-MacCutchan I would advise taking to your favourite search engine and look for ideas from the internet. I would avoid "interview questions" articles - but that is a very personal view - you might be able to answer all of the questions at the end of your research but you will be no further forward in mastering the topic.
For example: There are a lot of ideas on this site -
latest SQL Database project topics and ideas with source code for final year projects - kashipara[
^] - but avoid downloading their solutions - work it out for yourself.
Same with this one
Top 18 Database Projects Ideas for Students | Lovelycoding.org - We love Coding![
^]
You could have a look at
http://www.databaseanswers.org/data_models/[
^] - which is a great source for database schemas - but have a go at designing your own and use that site to "verify" your decisions.
Try to think of a topic that you are interested in or could expand on as your knowledge grows - e.g. your music / photo / book collection(s).
And be prepared to throw away your first attempts :-) Never be downhearted about mistakes - it's how we learn.
Finally - when you get comfortable with your knowledge be prepared to go over it all again - keep on top of the latest developments and techniques. Come to CodeProject often and try to answer for yourself some of the questions asked (if they are old posts though please don't resurrect them by posting your attempts).
I also use
SQLServerCentral – The #1 SQL Server community[
^] and
SQL Server Blog - Official News from Microsoft’s Information Platform - Microsoft[
^]