Types of Databases.

SQL Databases:

There are many different types of SQL databases designed for different purposes. Some of the most popular databases also include:

  1. MySQL.
  2. Access.
  3. Oracle.
  4. Microsoft SQL Server.
  5. Postgres, which is a popular open-source database with a very complete library of analytical functions.

(You can also write SQL within other programming frameworks like Python, Scala, and HaDoop).

Small Differences:

Each of these SQL databases may have subtle differences in syntax and available functions — for example, MySQL doesn’t have some of the functions for modifying dates as Postgres. Most of what you see with Postgres will be directly applicable to using SQL in other frameworks and database environments. For the differences that do exist, you should check the documentation.

(Most SQL environments have great documentation online that you can easily access with a quick Google search).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.