SQL Boolean Data Type
Do you need to store a boolean value in your SQL database? Does the data type even exist? Read this article and find out.
SQL Temp Tables: The Ultimate Guide
Have you ever heard of an SQL temp table or a temporary table? Wondering what it is? Learn all about them in this guide.
SQL Select Statement
In this article, we’ll look at one of the statements you’ll use a lot in SQL: the SELECT statement.
A Guide to the Entity Relationship Diagram (ERD)
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.
SQL Concatenate: A How-To Guide with Examples
String concatenation is the process of joining two string values together. Let’s see how to do it in several different databases.
SQL Wildcards
Wildcards are a useful technique when working with strings in SQL. Learn all about them and see some examples in this article.
SQL Transactions and Isolation Levels: The Ultimate Guide
Transactions are an important part of SQL and the databases they run on. Learn all about SQL transactions in this guide.
What is a Database Schema?
The term “database schema” has a few different meanings.
Let’s look further into these definitions.
Oracle 1Z0-071 Exam Guide and FAQ (OCA Certification)
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.
SQL Alias: A Guide to the SQL Aliases and the SQL AS Keyword
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.
