In this discussion, we’ll explore different ways records can be added to a table using the insert statement. The insert statement is the only statement that actually populates table with a record. Now, we saw the various constraints that can be imposed on a table in tutorial 1. This constraints must be obeyed when inserting […]
I’ve been discussing general information about database/sql development but l’m now going to concentrate on one flavour of SQL called TSQL, microsoft version of SQL. TSQL is used by all microsoft SQL servers, so knowing TSQL in general will allow you to program in all microsoft SQL servers with minimal changes. I’m going to base […]
In this tutorial, l’m going to quickly go over the languages that exist in SQL. SQL stands for Structured Query Language. It is made up of three components, Data Definition Language(DDL), Data Manipulation Language(DML) and Data Control Language(DCL). Let’s take a look at each of these languages and the general statements that fall under it […]
In this tutorial, l’m going to discuss the topic of normalization. normalization is the technique of minimizing redundancy and anomaly in the data. It leads to creation of more tables. There a many normal forms but l’m going to discuss only the first 3 normal forms because they are the most important. To begin with, let’s look at […]