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.

As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options come in the form of clauses ...

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

I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report ...

Learn more about the Relational Database Basics course here including a course overview, cost information, related jobs and more.

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.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.