Reading Time: 8 minutes Normalization is a very important process of designing tables to improve data integrity and reduce data redundancy. We were introduced to the concept of Normalization in our previous tutorials about First Normal Form and Second Normal Form. If you missed those tutorials, you should definitely read up on them first! Continue Reading
Second Normal Form: A Beginner’s Guide
Reading Time: 9 minutes Normalization is a very important process of designing tables in such a way that they maintain data integrity and reduce data redundancy. We were introduced to the concept of Normalization in our previous tutorial about First Normal Form. If you missed that tutorial, definitely check it out! In this tutorial, Continue Reading
First Normal Form: An introduction to SQL table normalization
Reading Time: 8 minutes A proper understanding of First Normal Form (and normalization in general) is very important if you are looking to enter the field of database development and design. I have combed the internet and referenced several books I own on the topic of database development and design, and they all have Continue Reading
SQL Server Foreign Key: Everything you need to know
Reading Time: 16 minutes If you have been working with SQL Server for a while, you might have heard of something called referential integrity. This is basically the idea that references between tables are accurate. In SQL Server, there are plenty of times where we’ll need to reference data from one table in another table. Continue Reading
SQL Server Primary Key: How it works and 6 rules you need to know
Reading Time: 12 minutes If you are new to SQL Server and the process of database design, you’ve probably heard of the need to create a primary key column in your tables. You’ve likely been told that “every table needs a primary key“. But do you understand why we need a primary key constraint Continue Reading
John Sonmez Blogging Email Course: An Honest Review
Reading Time: 8 minutes In this week’s tutorial, we’re going to take a break from learning how to query and develop SQL Server databases and instead talk about something else that could definitely boost your career: A programming blog. There are several reasons why you should a programming blog. First, if you are writing Continue Reading