Do you need to store a boolean value in your SQL database? Does the data type even exist? Read this article and find out.
Have you ever heard of an SQL temp table or a temporary table? Wondering what it is? Learn all about them in this guide.
In this article, we’ll look at one of the statements you’ll use a lot in SQL: the SELECT statement.
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.
String concatenation is the process of joining two string values together. Let’s see how to do it in several different databases.
Wildcards are a useful technique when working with strings in SQL. Learn all about them and see some examples in this article.
Transactions are an important part of SQL and the databases they run on. Learn all about SQL transactions in this guide.
The term “database schema” has a few different meanings.
Let’s look further into these definitions.
Are you interested in getting the Oracle Certified SQL Associate certification, and passing the 1Z0-071 exam?
If so, then this is the guide for you.
I recently achieved this certification, so in this guide, I’ll explain all there is to know about it.
Keep reading to learn all about this certification and exam.
What is an alias in SQL?
It’s a name you give to a column or a table in your SQL query to make it easier to display the results or to write your query.
SQL aliases are a useful feature and are available in all major database vendors, including Oracle, SQL Server, MySQL, PostgreSQL.
There are two types of aliases in SQL: column aliases and table aliases.