My Favorite SQL References

Here are some references I’ve found particularly useful when developing or debugging SQL code.  When trying something new, I like to have a user’s guide open at my left elbow, a language reference guide open at my right elbow, and a cup of dark coffee steaming above the keyboard.  When debugging, I like to have a debugger reference on the left, and a large unloaded revolver at my right.  (The bugs find the revolver intimidating, and I find that snapping sound more rewarding than admitting my programming errors.)

SQL Reference Guides

These provide encyclopedic reference on the details of function and syntax.

https://www.w3schools.com/sql/sql_quickref.asp

MariaDB SQL Language Reference:

https://mariadb.com/kb/en/mariadb/basic-sql-statements/

PostgreSQL Language Reference:

https://www.postgresql.org/docs/current/static/sql-syntax.html

MySQL Language Reference:

https://dev.mysql.com/doc/refman/5.7/en/sql-syntax-data-manipulation.html

T-SQL Language Reference:

https://msdn.microsoft.com/en-us/library/dn198336.aspx

https://msdn.microsoft.com/en-us/library/bb510741.aspx

https://msdn.microsoft.com/en-us/library/aa833212(v=vs.100).aspx

SQL Glossary

https://www.codecademy.com/articles/sql-commands

SQL Tutorials

The better organized on-line tutorials easily serve as user’s guides.

https://www.w3schools.com/sql/default.asp

http://www.tutorialspoint.com/sql/

https://www.khanacademy.org/computing/computer-programming/sql


(Image courtesy of David Castillo Dominici at FreeDigitalPhotos.net)

Advertisements