How to Connect MySQL Workbench to MariaDB
To use MySQL Workbench as a GUI for MariaDB? If you’re filled with disbelief right now, you’re...
SQL Aggregate Functions: Easy Tips for Newbies
SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these...
What is SQL Server? (Definition, Versions, Editions)
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...
The Easy and Practical SQL Server Tutorial for Beginners
Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast!...
SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro
Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips
MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You set these permitted values during the...
SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases
This post has “strings attached: for a good reason. We are going to explore deep into SQL...
