Database Star: Home

SQL DATEDIFF Function Guide and Examples

Jan 14, 2020 · 4 min read · sql-server ·

The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. Learn how to use it and see a range of examples in this guide.

SQL Data Types: Oracle, SQL Server, MySQL, PostgreSQL

Jan 11, 2020 · 16 min read · mysql oracle postgresql sql-server ·

Share on:

Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide.

SQL Server CONVERT Function Guide

Jan 10, 2020 · 5 min read · sql-server ·

Share on:

Do you need to convert data in SQL Server? Looking for the format codes for the CONVERT function? Learn all about the SQL Server CONVERT function in this guide.

SQL Comments: A How-To Guide

Jan 9, 2020 · 7 min read · mysql oracle postgresql sql-server ·

Share on:

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

42 ETL Tools: The Definitive List

Jan 8, 2020 · 2 min read ·

Share on:

This list has all of the currently available ETL tools. Use this for your research to help you decide which tool to use.

PostgreSQL vs MySQL: An Analysis

Jan 7, 2020 · 7 min read ·

Share on:

Are you considering using either MySQL or PostgreSQL for your next project? Read this article to find out the differences between these two databases and help decide which one to use.

SQL ALTER TABLE: A Complete Guide

Jan 7, 2020 · 10 min read · mysql oracle postgresql sql-server ·

Share on:

Learn all about the SQL Alter Table statement.

Ultimate Guide to Data Warehouses

Jan 6, 2020 · 14 min read · database-design ·

Share on:

Learn all about data warehouses in this guide.

SQL COUNT Function Explained with Examples

Jan 5, 2020 · 7 min read · mysql oracle postgresql sql-functions sql-server ·

Share on:

The SQL COUNT function is one of the most common functions used by SQL developers. I use it on a daily basis. Learn more about the COUNT function in this article.