FB
How to Install Oracle on a Mac (2020)

How to Install Oracle on a Mac (2020)

In this post, you’re going to learn the exact steps to take to install Oracle on your Mac computer.

This guide includes:

  • step-by-step instructions on downloading and setting up the required software
  • screenshots at each stage
  • explanations of the configurations you need to set (such as connecting to the database)

So if you want to set up Oracle on your Mac computer, you’ll love this guide.

Let’s get right into it.

read more…

The Ultimate Guide to Database Version Control, CI/CD, and Deployment

The Ultimate Guide to Database Version Control, CI/CD, and Deployment

Using a source code repository for your application code is common practice.

Automated testing and build, commonly known as Continuous Integration and Deployment, is something a lot of organisations are working towards.

Version control and deployments often only focus on application code, with database changes following a separate process.

In this guide, I'll explain that there's a better way to handle changes to your database and how to get it under version control, tested, and deployed along with application code.

Continue Reading
SQL Comments: A How-To Guide

SQL Comments: A How-To Guide

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

read more…

42 ETL Tools: The Definitive List

42 ETL Tools: The Definitive List

Are you looking for an ETL or data integration tool? Look no further. This list has all of the currently available ETL tools. Use this for your research to help you decide which tool to use.

read more…

PostgreSQL vs MySQL: An Analysis

PostgreSQL vs MySQL: An Analysis

Are you considering using either MySQL or PostgreSQL for your next project? Read this article to find out the differences between these two databases and help decide which one to use.

read more…