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.

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

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 ...

TL;DR: Learn how to manage data more effectively with the Complete 2021 SQL Master Class Bundle, on sale for 98% off. As of July 9, get the full course bundle for only $19.99.