SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_2

2. Getting Your Database Ready

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

The best way to learn SQL is to practice writing the commands on a real relational database management system. In this book SQL is taught using either one of the following systems: PostgreSQL or SQLite. The reasons for choosing these DBMS systems are simple – they are free and open source, with availability on most major platforms. PostgreSQL is a full-features enterprise class database management system with a great community. SQLite is a small but robust system that is especially suited for learning purposes. Choose the latter if you are not comfortable with software installations.

However, ...