To create a lengthy question short, I know of the fundamentals of the Relational Database, Indexing ,Replication, Securing, Concurrency, etc, and SQL syntax (Choose,Place,UPDATE,Remove, CREATE,DROP,ALTER,TRUNCATE) when combined with simple expressions for example:

SELECT EventID,EventName FROM Events WHERE CustomerID=5 ORDER BY EventType

However I do not understand the "advanced" subjects in Relational databases, like:

  • Domain names
  • Constraints
  • Indices

Will anybody please produce a fast primer, approximately explanation on which these aspects do and just how they work?

You might lower-election and totally trash this, but please show me, roughly how these subjects work because I have to get up to date on Relational databases very rapidly. Thanks!

The Wikipedia articles on Relational Databases and the Relational Model make the perfect starting point. They've links with other articles around the specific subjects you mention which have good examples, for example:

I believe that certain problem you are likely to face with this particular is the fact that features vary broadly between different RDBMS implementations. Securing, consistency and concurrency are extremely different in Oracle to <insert random name of other system here>. If there's a specific RDBMS that you've got an interest in then I'd urge you to definitely investigate how that specific system implements them, since the demon is incorporated in the particulars, as the saying goes.

For instance, begin with the Oracle Concepts Guide, obtainable in HTML and PDF from http://docs.oracle.com for every version.