BeginCodingNow.com

for data analysts & software developers

transaction

ACID Databases

ACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even […]

April 20, 2020 in Database tagged transaction / ACID / database by Mike

SQL Server Burton’s Database
There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […]

February 24, 2018 in SQL Server tagged database / sql / transaction / burton / diagram / relationship / department / employee by Mike

SQL Server Exception Handling Part 14

This post is a continuation of our SQL Server project that uses exception handling, except that here we […]

October 13, 2017 in SQL Server tagged transaction / exception / try / catch / tran / simple / simplified / boilerplate / error / SQL Server Exceptions by Mike

SQL Server Constraints Introduction

SQL Server has several types of constraints. But what is a constraint? Why do you need them? Which […]

May 23, 2017 in SQL Server tagged validation / constraints / unique / null / key / transaction / primary / surrogate by Mike