Tag: sql and nosql

Database Normalization

Even a good database design can't always protect against bad data. But there are plenty of occasions when a good database design helps us avoid the bigger of the possible bad data - database headaches. Thus, in this article I'll discuss database normalization: what it is, why we do it, and how we do it. I'll also discuss how we can determine when a database table is normalized 'enough' and what indications we can look for that suggest bad data might pose a problem for our database.

Structured Query Language - a primer part 3)

Part 3 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.

Structured Query Language - a primer (part 2)

Part 2 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.

Structured Query Language - a primer (part 1)

Part 1 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.