Now you know the basics of SQL database commands SQL is the language of databases, and we’ve reviewed the most basic command statements used in data queries.

It’s a common mistake: a company puts a poorly performing database on larger and larger servers, throwing more and more money away while making the same mistakes, but the database never gets any ...

When it comes to slick, highly functional sites, web designers get most of the credit. But they couldn't do what they do without the programmers, the unsung heroes of the web. If you're someone who ...

Assuring optimal performance of database applications starts with coding properly formulated SQL. Poorly written SQL and application code is the cause of most performance problems. As much as 75% of ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

In the last article, we covered some database terminology and looked at the four basic data query types. ... congratulate yourself—you survived the second part of our series on SQL basics!

Multivalue databases handle certain data structures that are just a little too complex for conventional relational databases. This post is one of a series that introduces the fundamentals of NOSQL ...

When is a database not a database? When it is a spreadsheet. What do spreadsheets have to do with databases do you ask? Spreadsheets are actually very rudimentary databases and, while not advisable, ...

In particular, I often look up constraints in SQL*Plus. In this post, I look at the Oracle database views and queries that I use most to get an idea what constraints I am dealing with. Topics ...

Graph databases facilitate discovery and analysis closely connected facts. This post is one of a series that introduces the fundamentals of NOSQL databases, and their role in Big Data Analytics.