TheTable Blog

The Table by DbVisualizer  is where we gather together to learn about and simplify the complexity of working with database technologies.

SQL Triggers: What They Are and How to Use Them

In this article, you will learn what an SQL trigger is, what types of triggers exist, why SQL triggers are useful, and how to use one in a complete example.

2023-01-26

JSON vs. JSONB in PostgreSQL: A Complete Comparison

JSON is one of the most popular human-readable data formats. PostgreSQL allows you to store JSON data and perform queries on it thanks to the json and jsonb data types. The introduction of these JSON data types represented a game changing moment for relational databases and opened up many new opportunities.

2022-12-02

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

In today's modern world, data has become more important than ever, making SQL the most widely used tool for managing and analysing this data. However, mastering all the SQL commands and queries can be daunting for beginners and even experienced developers. Therefore, I have created this SQL commands cheat sheet that provides the commonly used SQL statements for your reference.Download the PDF Cheat Sheet here.

2023-11-15

FILTER THE TABLE BY UPDATING THE query BELOW

1
2
3
4
SELECT * FROM Articles
-- WHERE Title LIKE %%
-- Tag LIKE %
%
ORDER BY

ARTICLES TABLE

Title Tags Length Date Author
title

SQL TRIM: Removing Extra Space Characters From a String

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 6 min 2024-05-16author Lukas Vileikis
title

PostgreSQL Full Text Search: The Definitive Guide

tags POSTGRESQL Search 11 min 2024-05-13author Lukas Vileikis
title

SQL UNION ALL: Keeping Duplicates When Combining Result Sets

tags MySQL ORACLE POSTGRESQL SQL UNION 8 min 2024-05-09author Lukas Vileikis
title

SQL UNION Operator: How To Combine Result Sets

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER UNION 9 min 2024-05-06author Lukas Vileikis
title

SQL CONVERT: The Handbook of Data Conversion in SQL

tags CONVERT Data Conversion MySQL SQL SERVER 7 min 2024-05-02author Lukas Vileikis
title

SQL CASE Statement: Definitive Guide

tags CASE ORACLE POSTGRESQL SQL SQL SERVER 5 min 2024-04-29author Lukas Vileikis
title

SQL REPLACE Function: A Comprehensive Guide

tags SQL 5 min 2024-04-25author Lukas Vileikis
title

SQL ORDER BY Clause: Definitive Guide

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 7 min 2024-04-22author Lukas Vileikis
title

Adding Dates in SQL: A Complete Tutorial

tags DATE DATETIME MySQL POSTGRESQL SQL SERVER 7 min 2024-04-15author Lukas Vileikis
title

Glossary of the SQL Commands You Need to Know

tags MySQL ORACLE POSTGRESQL SQL SQL SERVER 12 min 2024-04-11author Lukas Vileikis
The Table Icon
Sign up to receive The Table's roundup

The SQL Blog that Embraces Complexity

In a digital world where data drives decisions, understanding the intricacies of SQL and databases is crucial. Our blog is dedicated to demystifying the complexities of SQL, offering smart and accessible paths to navigate the vast landscape of database management. Whether you're a beginner or a seasoned professional, our in-depth articles, case studies, and tutorials are designed to provide clarity and insight into the often intimidating world of SQL.

Exploring the Depths of SQL and databases

SQL is more than just a query language; it's a fundamental tool that shapes how we interact with data. Our blog dives deep into the nuances of SQL, exploring advanced concepts, performance tuning, and the integration of SQL with other technologies. Whether you're dealing with massive datasets or intricate database designs, our blog provides the knowledge you need to excel.

A blog focusing on real-world SQL problems

This blog is your go-to resource for practical tips and tricks to tackle common and not-so-common challenges in SQL and database management. Our articles are crafted to address real-world problems, offering solutions that are both innovative and effective. From optimizing queries to understanding database architecture, we cover a wide range of topics to empower you in your SQL journey.

Using the SQL Blog to Stay Up to Date

The world of SQL is constantly evolving, and staying updated is key to success. Our blog offers a wealth of knowledge, keeping you informed about the latest trends, updates, and best practices in SQL. Don't miss out on our insightful content - sign up for our newsletter [link to newsletter] and stay ahead in the ever-changing landscape of database technologies.

FAQs

question
What is an SQL blog?

An SQL blog is an online platform dedicated to sharing knowledge, insights, and updates about SQL (Structured Query Language) and database management. It’s a resource for learning, sharing experiences, and discussing the latest in SQL technology.

View + Hide -
Can Beginners Benefit from This Blog?

Absolutely! Our blog is designed to cater to a wide range of skill levels, from beginners to advanced users. We provide foundational guides, step-by-step tutorials, and easy-to-understand explanations to help beginners gain confidence and skills in SQL.

View + Hide -
Why is This SQL Blog Called THETABLE

TheTable was chosen to reflect our commitment to providing clear, comprehensive, and expert insights into SQL. It represents our dedication to helping readers navigate the world of databases with ease and confidence.

View + Hide -
How Often Do You Post Articles on the Blog?

We strive to maintain a regular posting schedule, offering new and engaging content several times a week. Our goal is to keep our readers informed and up-to-date with the latest SQL trends and techniques.

View + Hide -
How Can I Add Suggestions on Topics I Want the Blog to Cover?

We welcome your suggestions! Feel free to reach out to us through marketing@dbvis.com.

View + Hide -
Do you have an exhaustive list of your published article

Yes, you can find them on this link.

View + Hide -
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗