24 Database Design Mistakes and How to Avoid Them
Creating a database is easy.
Designing an effective database, the right way, using good practices, is hard.
In this article, I’ve listed 24 different database design mistakes that you should try to avoid.
SQL Views and Materialized Views: The Complete Guide
By the end of this article, you’ll know all about views, materialized views, how to create them, their advantages, and much more.
SQL DISTINCT: The Complete Guide
The SQL DISTINCT keyword lets you find unique rows.
By the end of this article, you’ll know how to use it, what it can do, and understand several different examples.
SQL Set Operators: The Complete Guide to UNION, INTERSECT & MINUS
Are you wondering what set operators are?
Have you seen keywords like UNION or MINUS and want to know what they do and why they are used?
In this article, you’ll learn all about set operators such as these, why they are used, and see some examples.
SQL Operators: The Complete Guide
Do you want to know the different ways of comparing data in SQL, using operators?
SQL operators include EXISTS, IN, LIKE, BETWEEN, and many more. We’ll look at each of them in this guide.
By the end of the guide, you’ll have a solid understanding of these operators and will be able to use them in your own SQL code.
SQL Stored Procedures: The Complete Guide
Do you want to know what a stored procedure is, how it can help your SQL, and how to create one?
Read this guide to find out all of those, and more.
Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)
Natural key, surrogate key, composite key.
What do these terms mean? And why should you know what they are?
In this article, you’ll learn what these terms are, so you can communicate better with other developers and understand other online tutorials that use these terms.
Oracle Merge: The Complete Guide
Do you need to insert or update data depending on if it already exists?
You can do this with the MERGE statement in Oracle SQL.
SQL Joins: The Complete Guide
An SQL join is a concept that allows you to retrieve data from two or more tables in a single query.
It’s what makes databases so useful, and allows for data to be stored in separate tables and combined when it is needed.
Let’s take a look at what SQL joins are, how to use them, and see some examples.
50 SQL Experts Reveal Their Top 3 Tools for SQL Development and Administration
There are a large number of tools available for Oracle SQL developers and DBAs to use. It’s hard to know which tools are useful, will help you get the job done, and are widely used so you can get support easily.
However, there are people who have a lot of experience working with SQL, and I’ve asked 50 of them to share their answers to this question:
If you could only use 3 tools as an SQL developer or DBA, what would they be?
Let me tell you, the insights I received from these 50 database experts were nothing short of amazing. I’ve listed them all below, along with a summary of these tools at the end.
Ben Brumm
DatabaseStar
Popular Posts
