June 6, 2021

0

SQL Window Functions

Duplicate Rows in SQL – Find using Window Functions

If you want to find duplicate rows in SQL, you can go two routes. The first is ...

Read More

May 8, 2021

58

Data Modeling

Database Normalization – in Easy to Understand English

Database normalization is a process used to organize a database into tables and columns. There are three ...

Read More

April 28, 2021

13

Data Types and Functions

Learn to use SQL Date Functions

SQL server’s date functions provide you a set of function that you can use to manipulate dates.  ...

Read More

April 25, 2021

1

Data Modification

SQL UPDATE Statement (Transact SQL)

Use the SQL UPDATE statement to change data within a SQL Server data table’s columns.  In this ...

Read More

April 11, 2021

29

Common Questions, Data Modeling

Foreign and Primary Key Values – What is the Difference?

This article will teach you the difference between a primary key and foreign key. This article will ...

Read More