SQL DATEDIFF Function Guide and Examples
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.
read more…
SQL Data Types: Oracle, SQL Server, MySQL, PostgreSQL
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.
This article applies to Oracle, SQL Server, MySQL, and PostgreSQL.
SQL Server CONVERT Function Guide
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
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
Are you looking for an ETL or data integration tool? Look no further. 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
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
The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide.
Ultimate Guide to Data Warehouses
Data warehouses are an important part of a business.
As a developer, you’ll be involved in the data warehouse in one way or another: creating it, designing it, accessing it, or working on software that provides data to it.
Learn all about data warehouses in this guide.
SQL DROP TABLE: The Complete Guide
How can you delete a table in SQL? Learn how to do this by using the SQL DROP TABLE statement in this article.
SQL COUNT Function Explained with Examples
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.
read more…
