FB
Why Use PostgreSQL?

Why Use PostgreSQL?

PostgreSQL is a free and open-source database management system. It’s commonly referred to as an alternative to MySQL or MariaDB.

Are you thinking about using PostgreSQL for your own project? Or are you researching databases to use for a project at work? Are you trying to convince someone else why PostgreSQL is a good choice?

If so, read on to find out why using PostgreSQL is a good idea.

read more…

A Guide to SQL NULL (and SQL NOT NULL)

A Guide to SQL NULL (and SQL NOT NULL)

The concept of NULL is something you should know about when working with databases.

In this article, you’ll learn all about NULL: what it is, why it’s different, how you can check for it in different databases, and many examples.

read more…

19 Best Database Books

19 Best Database Books

If you work with databases, you’ll know that there’s a lot to learn.

New technologies are being released, new versions of databases are coming out.

There’s also a range of technical problems you need to work on and solve on your project or in your team. These problems can be solved in a variety of ways – some of which you know about, others you may not.

A great way of learning about databases, and programming in general, is through books.

(more…)

Sample Database: Olympic Games (ERD and SQL)

Sample Database: Olympic Games (ERD and SQL)

When you’re learning SQL or database design, it’s helpful to use other databases as a reference.

Many articles online refer to Oracle’s HR database, or SQL Server’s AdventureWorks database. These can be helpful, but often you’re looking for answers that these databases don’t help with.

Which is where this post comes in.

This post describes a sample database containing data about Olympic events and competitors.

read more…

Sample Database: Video Games (ERD and SQL)

Sample Database: Video Games (ERD and SQL)

When you’re learning SQL or database design, it’s helpful to use other databases as a reference.

Many articles online refer to Oracle’s HR database, or SQL Server’s AdventureWorks database. These can be helpful, but often you’re looking for answers that these databases don’t help with.

Which is where this post comes in.

This post describes a sample database containing data about video game sales.

read more…

How to Resolve Oracle Connection Issues

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.

read more…