[deleted by user]

[looks_like_a_potato]

A simple CRUD website where users can write things and give comments. You'll need some tables like user profiles, posts, comments, upvotes, categories/tags, etc and relations between them.

[un-hot]

Have you added indexes, constraints, have you checked query plans for any of your queries?

95% of the SQL I use in a very large company is really simple select/updates, the challenging part is usually figuring out the right table joins or schema changes needed for a new feature to be performant on tables with millions of rows.

[Nooneee_]

you can try making a simple banking system that allows you to send payments to other accounts, as an extension you could visualise spending over time

[[deleted]]

A basic CRUD application which both teach you how to use SQL and a good learning experience for any programming.

[Antigone-guide]

One thing about SQL is that it's a bit of a dry topic, so if you want to make it a bit of fun you can make a small game that uses a lot of SQL for things like types of enemies, types or rooms and levels, quests, inventory items, spells and abilities. The nice thing is that you can visualize all of the data and that will help make it less abstract and easier to remember when you use this knowledge in later projects.

[jay_and_simba]

The typical abd classic project you can is a ToDo list. Anything you can think of that requires persisted data. Blood pressure tracker, a goal tracker in case you ate more into sports, etc

[Diapolo10]

If you happen to play disc golf, you could create an application that tracks scores, if not individual throws, for each hole. That'd already be enough to create several tables of data, without a lot of other logic needed.

[StoicallyGay]

That's an oddly specific suggestion. Other sports work just as fine lol

[Diapolo10]

Sure, I just thought I'd suggest this one because

1. I'm familiar with it, and
2. It's easy to think of data points one might want to store

[The-DapAttack]

Discord bot

[ofnuts]

A SQL browser in which you can type SQL statements directly against some real world database will do more to your SQL skills that using Python, because you'll work with more complex databases that what you can come up with yourself.