Ultimate Guide to Becoming a Business Analyst

Ultimate Guide to Becoming a Business Analyst

Are you wondering what a business analyst is? Are you interested in becoming a business analyst? You’ve come to the right place. In this guide, you’ll learn all about this role on software projects: the business analyst. You’ll learn what they are, what they deliver,... Read more
Monthly Link Roundup – June 2017

Monthly Link Roundup – June 2017

In this roundup article, I share some of the best articles I’ve read recently on Oracle, database development, and software. Database Administration: Dead or Alive? https://oracle-base.com/blog/2017/05/06/database-administration-dead-or-alive/ Tim Hall wrote an... Read more
Oracle SQL Indexes – The Definitive Guide

Oracle SQL Indexes – The Definitive Guide

Indexes in SQL are an important part of the language. But why is that? What is an Oracle index? And why should you know about them? I’ll cover all of that in this guide. I’ll also show you the different types of indexes, and share many different sites that have... Read more
How to Escape Single Quotes in SQL

How to Escape Single Quotes in SQL

Do you need to escape special characters or escape a single quote in SQL? Learn how to do that in this article. What Is Escaping? When you are working with text values in Oracle SQL, you use single quote characters. This could be when you’re selecting them:... Read more
What Is a Self Join?

What Is a Self Join?

A self join is a common solution to a specific table design in databases. Learn what a self join is and how to write queries against it in this article. What Is a Self Join? A self join is a type of join in a database where you join a table to itself. It’s... Read more