How to Resolve Oracle Connection Issues
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.
Sample Database: Movies (ERD and SQL)
When you’re learning SQL or database design, it’s helpful to use other databases as a reference.
OGB Appreciation Day: A New Version of Oracle Express
For 2019, I am thankful for Oracle releasing the latest version of Oracle Express.
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.
