Understanding MySQL TRUNCATE TABLE by Practical Examples
MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML...
Learn Database Design with SQL Server Management Studio (SSMS) – Part 2
It is the second part of the series focused on the SQL Server Management Studio usage. You will learn the database design core concepts and...
A Practical Use of the SQL COALESCE Function
This article talks about the practical use of the SQL COALESCE function regarding some professional life scenarios. It highlights the...
Database Design Concepts with SQL Server Management Studio (SSMS) Part 1
This article is primarily written for beginners. Still, it covers some interesting and often...
Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3
CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related publications. If you missed the previous two...
Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year using SQL Server. They said it was bad...
Add Columns to an Existing Table in SQL Server Database
Introduction A table is a two-dimensional logical structure and the fundamental means of storing...
