One of the hardest parts about learning Oracle SQL is getting the database connection working.
After you download Oracle (either Oracle Express or the full database), and an IDE of your choice (such as SQL Developer), it should be easy to set up a new connection and log in.
However, it’s not.
By far, the most common question I receive in my Introduction to Oracle SQL course is how to connect to the database. There were quite a few steps involved in 11g, but now that Oracle Express has released 18c, there are a few more issues that appear.
This article explains what Oracle connection issues may occur and how to fix them.
When you’re learning SQL or database design, it’s helpful to use other databases as a reference.
For 2019, I am thankful for Oracle releasing the latest version of Oracle Express.
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.