Sql | Database Star: Home

Sep 17, 2018 · 25 min read · sql ·

Learn how to use the PIVOT feature in Oracle.

Jul 26, 2018 · 21 min read · sql ·

By the end of this article, you’ll know all about views, materialized views, how to create them, their advantages, and much more.

Jul 24, 2018 · 8 min read · sql ·

Learn what the SQL DISTINCT keyword is in this guide.

Jul 19, 2018 · 12 min read · sql ·

In this article, you’ll learn all about set operators such as these, why they are used, and see some examples.

Jul 17, 2018 · 23 min read · sql ·

SQL operators include EXISTS, IN, LIKE, BETWEEN, and many more. We'll look at each of them in this guide.

Jul 12, 2018 · 22 min read · sql ·

Do you want to know what a stored procedure is, how it can help your SQL, and how to create one? Find out in this guide.

May 22, 2018 · 12 min read · sql ·

Learn how to use the MERGE command in SQL.

May 14, 2018 · 31 min read · sql ·

Let's take a look at what SQL joins are, how to use them, and see some examples.