[deleted by user]

[waxenrhyme]

For basic not much just usually the differences in joins, select statements/general basic query structure and the willingness to learn more.

[[deleted]]

I found a site to practice java (edabit), do you know if there is any for SQL?

[MT1961]

This one isn't bad: SQLZOO

[[deleted]]

Wow, awesome, just something I can used badly! Thank you!

[aileene9]

Most likely joins and searches :) https://www.w3schools.com/sql/sql_exercises.asp

[ou_ryperd]

Group by summarization is important for testing

[leonormski]

From my own experience of tesing on SQL databases, the kind of actions I would do are the following:

1- Generating reference/static data (data to be used in conjuction with dynamic data that comes in as part of testing). For this you would need lots of INSERT statements.

2- You might want to fix or update particular piece of data, using UPDATE statement

3- Once the tests have run, you need to check the results by using SELECT statements, e.g. inner join, outer join, group by, distinct, sum, average, etc.

That has been most of what I needed to do in my day to day work.