Database Star: Home

Singular vs Plural and Other Database Table Naming Conventions

Jan 2, 2017 · 11 min read · database-design ·

Are you wondering if you should name your SQL database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article.

Oracle Certification Dumps Can Ruin Your Career

Dec 5, 2016 · 7 min read · sql ·

Share on:

Are you looking to get certified? Want to get your hands on some Oracle certification dumps for an exam to help you pass? That's a bad idea. I'll explain why in this article.

Oracle TO_DATE Function Usage, Tips & Examples

Nov 15, 2016 · 6 min read · sql-functions ·

Share on:

The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I'll explain how to use the TO_DATE function in this article.

A Guide to the Oracle Data Types

Oct 24, 2016 · 21 min read · sql ·

Share on:

In this article, I explain what the different data types are in Oracle database and everything you need to know about them.

Overview of Oracle Character Sets

Oct 3, 2016 · 2 min read · sql ·

Share on:

This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database.

How I Organise Email At Work To Keep Track Of It All

Sep 12, 2016 · 7 min read · work-performance ·

Share on:

I explain how I organise my email at work in this article.

What Does SQL PARTITION BY Do?

Aug 29, 2016 · 4 min read · sql ·

Share on:

Have you ever seen the PARTITION BY keyword used in SQL queries? If so, do you know what it does and how to use it? Learn about the SQL PARTITION BY keyword and see some examples in this article.

65 Business Jargon Phrases to Stop Using and What To Use Instead

Aug 22, 2016 · 21 min read · work-performance ·

Share on:

Learn a range of business jargon phrases in this article.

Oracle BFILENAME Function Explained with Examples

Aug 11, 2016 · 2 min read · sql-functions ·

Share on:

The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article.

Oracle 12c New Features for Developers

Aug 1, 2016 · 25 min read · sql ·

Share on:

Oracle 12c is Oracle's latest version of its database engine. Learn about all of the new Oracle 12c new features for developers in this massive guide.