Skip to main content

SQL

PostgreSQL

My best experience with SQL data bases have been PostGres by far. It is open source, works splendidly and is fast and simple to learn and use and has a lot of awesome functionality.

Links

Thoughts

  • There are two types of people in business, those who know SQL and those who do not. Be the former.
  •  Common Table Expression (CTE) using the WITH clause. A CTE is a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. Here's a breakdown of what the code does: