0. Look at a few simple sql queries (at most one join) and the corresponding schema. Internalise what the queries do and a rough idea as to the syntax
1. Have a database to query (or think of some project that is basically a frontend on a database and which you can give a reasonable amount of data)
2. Come up with questions for the database you want to answer
3. Look at the SQLite documentation. They have fantastic diagrams for the syntax of a sql query.
4. Write down the sql for your query (or work out what you can’t express and see if you can search on the internet to find out how to express it)
5. Look into relational algebra and try to work out how it corresponds to sql databases.
6. Repeat steps 2-4
7. Understand what different types of joins there are
8. Repeat steps 2-4
9. Read about more exotic things like nested queries, window functions, recursive queries, and so on (just look at the features of your database of choice and see what you can learn about). These might come in handy for future questions
10. Repeat steps 2-4 (repeatedly)
If you don’t know which database to use then start with SQLite. It’s basically fine for anything simple and manything complicated.
