FB
SQL Wildcards

SQL Wildcards

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

read more…

Oracle 1Z0-071 Exam Guide and FAQ (OCA Certification)

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.

read more…

SQL Alias: A Guide to the SQL Aliases and the SQL AS Keyword

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.

read more…

Get Your SQL Cheat Sheets Now: