Sunday, February 27, 2022

What is Primary key in SQL? How to choose Primary key in table? Example

If you've ever dealt with databases, you've almost certainly come across the term - primary key (PK). And if you're following this series to learn about databases, this piece should help you understand what the PK is all about. Even if you're a database specialist, you could learn something new or improve your skills. So sit back, relax, and let's get started with the PKs.

Sunday, February 20, 2022

How to use WHERE , LIKE, and BETWEEN in SQL for Filtering Rows? Example Tutorial

You may be thinking why is the filtering of data needed? Because you utilize the WHERE clause when changing data with DELETE and UPDATE statements, if you've been following these Database Fundamentals posts, you've already seen it. It's also been used to restrict the values returned from a SELECT operation multiple times in this series.