Database Star: Home

SQL CASE Statement Explained with Examples

Jan 4, 2020 · 12 min read · mysql oracle postgresql sql-functions sql-server ·

The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. Learn more about this powerful statement in this article.

SQL INSERT: The Complete Guide

Jan 4, 2020 · 26 min read · mysql oracle postgresql sql-server ·

Share on:

Learn how to use the SQL INSERT INTO command.

SQL DELETE Statement - The Complete Guide

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

Share on:

The SQL DELETE statement allows you to delete records from a table. I'll explain more about the SQL DELETE statement in this article.

SQL TRUNCATE TABLE Statement: The Complete Guide

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

Share on:

Learn all about the SQL TRUNCATE keyword.

SQL UPDATE Statement: A Complete Guide

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

Share on:

Have you ever needed to update data that was already in a table? Learn how to do this with the SQL UPDATE Statement.

SQL CREATE TABLE Syntax and Examples - The Complete Guide

Jan 1, 2020 · 17 min read · mysql oracle postgresql sql-server ·

Share on:

Creating database tables in SQL is one of the most common tasks a developer or DBA does in a database. Learn how to create tables, what the syntax is, and see some examples in this article.

SQL GROUP BY and HAVING: The Complete Guide

Jan 1, 2020 · 20 min read · mysql oracle postgresql sql-server ·

Share on:

The SQL GROUP BY clause and SQL HAVING clause are powerful clauses, especially when analysing large amounts of data. Learn what the GROUP BY and HAVING clause is and everything you can do with it in this article.

Why Use PostgreSQL?

Dec 30, 2019 · 9 min read · sql ·

Share on:

Some reasons why you should use PostgreSQL.

A Guide to SQL NULL (and SQL NOT NULL)

Dec 23, 2019 · 12 min read · sql sql-functions ·

Share on:

In this article, you'll learn all about NULL, what it is, why it's different, how you can check for it in different databases, and many examples.