Database development

SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

11:04 Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become...
Read More

SQL JOINs Tutorial with Examples

10:18 Database development, Statements

In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax,...
Read More

SQL Server Triggers – Part 2 DDL & LOGON Triggers

14:26 Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
Read More

SQL Server Triggers: DML Triggers

11:20 Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens...
Read More

Drop Temp Table in SQL Server and PostgreSQL

12:01 Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

What is SQL Server? (Definition, Versions, Editions)

16:37 Database administation, Database development

Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You...
Read More

The Easy and Practical SQL Server Tutorial for Beginners

13:47 Database development

Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast!...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

09:43 Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Read More

SQL Server Resumable Index: Is it good for you?

07:02 Database development, Indexes

SQL 2017 introduced the ability to pause and resume index rebuild operations during database maintenance. This feature offers more...
Read More

Is SQL DISTINCT Good for Removing Duplicates in Results?

05:57 Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Read More