FB
SQL Joins: The Complete Guide

SQL Joins: The Complete Guide

An SQL join is a concept that allows you to retrieve data from two or more tables in a single query.

It’s what makes databases so useful, and allows for data to be stored in separate tables and combined when it is needed.

Let’s take a look at what SQL joins are, how to use them, and see some examples.

read more…

50 SQL Experts Reveal Their Top 3 Tools for SQL Development and Administration

50 SQL Experts Reveal Their Top 3 Tools for SQL Development and Administration

There are a large number of tools available for Oracle SQL developers and DBAs to use. It’s hard to know which tools are useful, will help you get the job done, and are widely used so you can get support easily.

However, there are people who have a lot of experience working with SQL, and I’ve asked 50 of them to share their answers to this question:

If you could only use 3 tools as an SQL developer or DBA, what would they be?

Let me tell you, the insights I received from these 50 database experts were nothing short of amazing. I’ve listed them all below, along with a summary of these tools at the end.

read more…

Oracle Constraints: The Complete Guide

Oracle Constraints: The Complete Guide

You want to avoid having bad data, right?

Data that doesn’t make sense, is missing when it should be populated, or refers to other data that does not exist.

We want to avoid these kinds of issues.

How can we do that?

We use constraints.

In this article, I’ll explain everything you need to know about constraints.

read more…

Introduction to Oracle SQL Course

Introduction to Oracle SQL Course

Do you want to learn SQL?

You’ve come to the right place.

On this page, you’ll find videos, links, and information for this Introduction to Oracle SQL course. It covers the beginner level topics in my SQL Roadmap.

So, keep reading to see what you’ll learn and watch the videos in this course.

(more…)

Oracle 18c Guide and FAQ

Oracle 18c Guide and FAQ

Oracle 18c has been released.

What’s included?

How does it impact you as a developer or a DBA?

How can you get access to it to play around with some of the new features?

Keep reading to find the answers to this, and more.

read more…

Ben Brumm
Ben Brumm
DatabaseStar

Oracle SQL Expert

Popular Posts

Database Normalisation
Introduction to Oracle SQL
SQL Joins
Database Developer

Get Your SQL Function Cheat Sheet Now: