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
Updatable View in SQL Server: A How-To Guide
Reading Time: 10 minutes A proper understanding of Views in SQL Server will definitely help you become a better database developer. Views allow us to basically save a query as an object in the database, and make it very easy to run the query with simple commands. But what if we want to make Continue Reading
Cannot update an IDENTITY column? Here’s why
Reading Time: 7 minutes The IDENTITY property is an extremely useful tool we can use in SQL Server to automate the values in a column. It can be especially useful for primary key columns. This property will automatically add a new integer value to a column when a new row is inserted into the Continue Reading
How to change a column name in SQL Server: Explained for Beginners
Reading Time: 6 minutes So you need to change a column name in your database. Maybe you messed up the name from the start, or your team decided the name needs to change for business reasons. Either way, it’s got to change. Luckily, the process to change a column name is not too difficult Continue Reading
UPDATE statement with JOIN: How it’s done
Reading Time: 8 minutes One of the more tricky things I learned early in my career was how to do an UPDATE statement with a JOIN. This is a very interesting task to think about. There may be situations when we want to perform an UPDATE to the results of a JOIN query, such Continue Reading