Database Star: Home

SQL COUNT Function Explained with Examples

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

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.

SQL DROP TABLE: The Complete Guide

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

Share on:

Learn how to drop tables in SQL.

SQL CASE Statement Explained with Examples

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

Share on:

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.