I’ve created this overview of basic SQL syntax for the interested developer and anyone who could benefit from a cheat sheet.

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

SQL SELECT statement The SELECT statement tells the query optimizer what data to return, what tables to look in, what relations to follow, and what order to impose on the returned data.

Assuring optimal performance of database applications starts with coding properly formulated SQL. Poorly written SQL and application code is the cause of most performance problems. As much as 75% of ...

SQL is used to interact with databases. Learning the language can take your Android development game to a whole new level. This primer will get you started.

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?

The following content is brought to you by Mashable partners. If you buy a product featured here, we may earn an affiliate commission or other compensation. Get started on your data science education.