• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

if you know SQL syntax

What are the different databases that you can retrieve information from?

I know...

1) MySQL
2) PostgreSQL
3) MsSQL (I'm guessing)
4) Oracle (I believe?)
 
Virtually all of them. I don't think there are any non-sql databases still in anything close to common usage.

One of the big ones you forgot is IBM DB2
 
SQLite, which is used a lot in the Apple world.
Lots of iPhone apps use SQLite either directly, or indirectly, through Core Data.
 
If you know SQL you can use virtually any database out there. That said, there are usually slight differences between the different variants of SQL.
 
Using ODBC drivers you can even retrieve information using SQL from non-databases like txt files, excel files etc.
 
SQL is a standardized language.
SQL was adopted as a standard by the American National Standards Institute (ANSI) in 1986 as SQL-86[20] and International Organization for Standardization (ISO) in 1987. The original SQL standard declared that the official pronunciation for SQL is "es queue el".[1] Many English-speaking database professionals still use the nonstandard[21] pronunciation /ˈsiːkwəl/ (like the word "sequel"). SEQUEL was an earlier IBM database language, a predecessor to the SQL language.[22]

Until 1996, the National Institute of Standards and Technology (NIST) data management standards program certified SQL DBMS compliance with the SQL standard. Vendors now self-certify the compliance of their products.[23]

Three database query languages, off the top of my head, that do not conform to the SQL standards are IBM Nomad (mainframe/Cobal), SAP, and Ab Initio.

This webpage may be of interest.
Comparison of different SQL implementations
 
Back
Top