Finding SQLTERMs and their definitions for [b]Oracle SQL[/b] & [b]SQL Server[/b]

I dug for about an hour last night on the subject of SQLTERMs and their definitions for Oracle SQL & SQL Server and a few others.

I noticed that some of the terms are generic then realized that some of the sites did not have even some of the basics. SELECT FROM WHERE  ORDERBY etc.

With that, I wondered if I was looking at terms and definitions of databases vs the CODE. So is there a really good site for finding out what specific code like functions or operations do in a SQL query?
This would be very helpful to me since I have been trying to breakdown many of the parts of the query and what each term means so I can decipher and create my own...?
Not this stuff. I understand this. https://raima.com/database-terminology/ 
What each type of code is and does....? Like Create Table or maybe it is insert table commands.

I figured you guys would know the best stuff. So rather than hope I hit a home run? I'll get on base and you can hit the home run.