What do you need to know in SQL?

Question

SQL

Hello!
The university database course passed by. What do you need to know about SQL to consider yourself human? Where to move after simple requests?
I will also be grateful for good literature on SQL in Russian

Answer 1

the first thing that comes to mind is:
PK / FK
JOIN
HAVING
UNION
CASE
all sorts of functions like sum, count, nvl, coalesce transaction
indexes query cost hints query plan. -------------------------------------------------- ----- Come up with a problem, for example: Create a database with musical instruments, come up with several tables, link them and check them as perversely as possible ("how many guitars with 12 strings have been released since 1986 in America")

Answer 2

3rd normal form to start with.

Answer 3

The most frequently required practices in real work: the use of all types of data joins and the speed of their processing on a specific server implementation.

Answer 4

+

1. Modeling.
   
2. Normalization.
   
3. Optimization.
   

Answer 5

SQL standards (88, 92, 99, 200x), analytical functions, hierarchical queries, use of text, spatial and other domain-specific indexes...