77 Data Modeling Tools Compared
How to Install Oracle on a Mac
Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer.
If you’re running a MacBook (like I am), or any type of Mac, this article will be useful for you. You’ll see the step-by-step instructions to install Oracle on a Mac.
ODC Appreciation Day 2018: Oracle Live SQL
ODC Appreciation Day is a roundup of blog posts by Oracle database blog owners on their favourite features of SQL Developer and other Oracle technologies.
For this year, my appreciation is for Oracle Live SQL.
Oracle SQL PIVOT and UNPIVOT: The Complete Guide
Have you ever needed to convert a set of data from rows into columns? You can do this using the Oracle PIVOT feature (and the reverse using Oracle UNPIVOT).
JDBC in Java, Hibernate, and ORMs: The Ultimate Resource
As a Java developer, it’s very likely you’ll need to connect to a database.
There are several ways to do this in Java, from creating a simple connection using JDBC in Java to using a complete framework for managing data storage or persistence.
Improve your knowledge of Java and database connections with this collection of guides and resources.
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.
Ben Brumm
DatabaseStar
Popular Posts
