You have learned SQL, are proficient in using it, and trying to land a job that requires strong SQL knowledge. Now, you have to prove your knowledge and skills, and you are searching for some good projects that will boost your resume by showing what you can actually do with SQL and relational databases.

Typically, the type of projects you should have on your portfolio are ones that can clearly show a few things:

• You know relational database theory, and how to create good database schemas
• You know how to connect your entities in the best possible way

• You can write complex queries to get the required data

  Bonus:

• You can create stored procedures, views, and aggregators

• You can create complex database schemas

The same goes if you are only trying to learn, train yourself, and get the most out of your practices to gain new knowledge and become more proficient in SQL.

The best way to test and show your knowledge of any computer science subject is through projects. Some projects involve different levels of SQL complexity and expertise, can be very interesting, and give you the chance to understand and practice the language thoroughly.

Let us begin! We created a few examples and ideas for your next projects, that will help you prove your SQL skills, help you gain new knowledge by creating them, and show the employers you can do anything with SQL. Along with these ideas, we are going to illustrate their respective ER diagrams, so you can have a better overview of the idea behind the examples.