Database Star: Home

Aug 4, 2019 · 9 min read ·

In this article, we'll look at one of the statements you'll use a lot in SQL, the SELECT statement.

Jul 30, 2019 · 9 min read · database-design ·

Learn all about Entity Relationship Diagrams (ERDs), what they are used for, how to understand them, how to create them, and more in this guide.

Jul 24, 2019 · 3 min read · sql ·

String concatenation is the process of joining two string values together. Let's see how to do it in several different databases.

Jul 22, 2019 · 5 min read · sql ·

Wildcards are a useful technique when working with strings in SQL. Learn all about them and see some examples in this article.

Jul 18, 2019 · 20 min read ·

Transactions are an important part of SQL and the databases they run on. Learn all about SQL transactions in this guide.

Jul 14, 2019 · 4 min read ·

The term "database schema" has a few different meanings. Let's look further into these definitions.

May 28, 2019 · 9 min read · sql ·

Learn all about the 1Z0-071 exam.

Apr 23, 2019 · 9 min read · sql ·

Learn what an SQL alias is in this guide.

Apr 10, 2019 · 8 min read · sql ·

In this article, you'll learn what the WHERE clause is in SQL, how to use it, and see some examples.

Apr 1, 2019 · 20 min read · sql ·

In this article, you'll learn all about the Common Table Expression, what it's good for, and how to use it.