SQL Basics

In this SQL tutorial, we will learn the basics concepts of SQL Server such as DDL and DML operations to select, insert, update, create, delete, retrieve and manipulate data in the SQL Server.

Mastering Database Normalization: Best Practices and Techniques

Database normalization is a technique used to organize data in a relational database. It involves breaking down a large table into smaller tables and defining relationships between them. The normalization goal is to eliminate redundant data and ensure that each piece of information is stored in only one place.

Relational databases are the backbone of many software systems. They allow us to store, manage, and retrieve data in an organized and efficient way. However, as the size and complexity of our data grow, so do the challenges of maintaining its integrity and consistency. This is where database normalization comes in. 

Database Normalization
Database Normalization

Read more >>

Mastering SQL Inner Join: A Comprehensive Guide With Practical Examples

SQL (Structured Query Language) is the standard language for managing relational databases. It is a powerful tool that allows us to store, manipulate, and retrieve data efficiently. One of the most commonly used operations in SQL is the JOIN operation, which allows us to combine data from two or more tables into a single result set.

The INNER JOIN clause is one of the most frequently used types of JOIN in SQL. It combines rows from two or more tables based on a related column between them. The INNER JOIN returns only the rows that have matching values in both tables, i.e., the intersection of the two tables. 

The following picture illustrates the Venn diagram of INNER JOIN. The shaded area in the diagram represents the common values shared between the two tables.

sql-inner-join
SQL Inner Join

Read more >>

SQL Server TRY_CAST() Function – Understanding TRY_CAST() in SQL with [Examples]

TRY CAST function in SQL belongs to the Conversions category of functions and resembles the CAST() function. Its purpose is to transform an expression from one data type to another. If successful, the result will be the expression in the expected data type, but if it fails, the function will return null.

This blog post will dive into the TRY_CAST() function in SQL Server, its syntax, and how it differs from the CAST() function. We will use a few code examples to make it easy to implement this function in our SQL Server database.

try_cast
Try_Cast() in SQL

Read more >>

Views in SQL Server with [Examples]

Last updated on February 14th, 2023 at 07:39 am

In SQL, Views are virtual tables that give a simplified and customized view of data from one or multiple database tables. They are similar to a table with rows and columns but do not store actual data.

This article will cover the different types of views in SQL Server with multiple examples. Also, we will learn about how to create, modify, update, and delete views in SQL Server.

View in SQL Server
Views in SQL Server

Read more >>

Triggers in SQL: Understanding Triggers and Trigger Examples in SQL Server

Last updated on February 10th, 2023 at 03:09 am

Triggers in SQL are special types of stored procedures that are automatically executed in response to specific events or changes within a database. In this article, we will explore triggers in SQL and provide a trigger example in SQL Server to help you understand how they work.

SQL Server Trigger Update, Insert, Delete
Triggers in SQL

Read more >>

Everything You Need to Know About Cascade in SQL Server: Syntax, Rules, and Examples

Last updated on March 8th, 2023 at 11:41 pm

As a database developer or administrator, you must have encountered the term Cascade in SQL Server. Cascading is a powerful feature that helps maintain data integrity by automatically propagating changes across related tables in a database. This article will explore the following:

  • What is cascade in SQL Server?
  • Why you should use it.
  • How to create a foreign key with delete and update cascade rules.

We will also provide examples and explanations to help you understand the concept better.

SQL-DELETE-CASCADE
SQL Delete Cascade

Read more >>

CREATE, ALTER, AND DROP DATABASE IN SQL SERVER

Last updated on April 23rd, 2020 at 08:57 am

In this article, we will discuss how to Create, Alter, and Drop a database in SQL Server.
In my previous article, we have discussed all about the Types of SQL Commands.

Database Introduction

 Database  : In the SQL server a database is a place to store the data in an electronic format. It is an organized collection of database objects such as tables, views, functions, stored procedures, triggers and so on.
It allows a user to easily access or manipulate the data.

SQL server database

Create Database In SQL Server

In SQL Server, there are two ways to create a user-defined database, either by using the Transact-SQL statements or by using SQL Server Management Studio.

Read more >>

5 Types of SQL Commands: DML, DDL, DCL, TCL, DQL with Query Example

Last updated on October 8th, 2023 at 05:53 am

SQL commands are a set of instructions used for interacting with relational database management systems (RDBMS).

SQL (Structured Query Language) is the standard language for managing and manipulating data in databases like SQL Server, MySQL, Oracle, Sybase, and Postgres.

Here, We will learn SQL commands like DML, DDL, DCL, TCL and DQL commands in SQL with examples.

image-types of SQL Commands
Types of SQL Commands

Read more >>