Category Archives: SQL Fundamentals

SQL Server Architecture

This section will introduce you to the SQL Server architecture, the entities involved—SQL Server instances, databases, schemas, and database objects. SQL Server Instances A SQL Server instance is an installation of a SQL Server database engine/service. You can install multiple … Continue reading

Posted in SQL Fundamentals | Leave a comment

SQL Core Concepts (The Data Life Cycle)

In SQL Server database data is actually similar to a product in an assembly line moving from one environment to another and undergoing transformations along the way. Figure-1 illustrates the data life cycle. OnLine Transactional Processing Data is entered initially … Continue reading

Posted in SQL Fundamentals | Leave a comment

Database Normalization and Normal Forms

Database Normalization: If you are doing database work from some time, you possibly have heard about Normalization before. Normalization is basically a process that is applied on databases to make sure of minimum redundancy (1. No duplicate data) and more … Continue reading

Posted in SQL Fundamentals | Tagged , , , , | Leave a comment

SQL Core Concepts: Part 1 (RDBMS, SQL, T-SQL, Set Theory and Predicate Logic, Relational Model)

In this post I covered concepts of RDBMS, SQL, T-SQL, Set Theory and Predicate Logic, Relational Model. All these concepts are related to each other and knowledge of these basic concepts is I think very necessary before starting with the … Continue reading

Posted in SQL Fundamentals | Tagged , , , | Leave a comment