.. Copyright (C)  Google, Runestone Interactive LLC
   This work is licensed under the Creative Commons Attribution-ShareAlike 4.0
   International License. To view a copy of this license, visit
   http://creativecommons.org/licenses/by-sa/4.0/.


How to Run SQL Outside of This Textbook
=======================================

In this section, you learned some basic SQL commands to analyze large datasets.
In the interactive version of this textbook, there was a SQL interpreter.
However, when using SQL outside of the textbook, including in your project, you
will need to run SQL somewhere else. In order to do this, there are many
options. If you are using SQL for just this course, you can use an online
interpreter, such as this one. When importing a .db file directly, select the
File drop drown from the top left of the webpage and select Open DB to use your
.db file.

- `SQL Online Interpreter`_

Ultimately, if you plan on using SQL for more robust purposes, you will want to
run SQL queries on your own machine. To do this, you will need to download a
Database Engine and set up a Database Client. There are many options for
database engines you can use. Some of the most popular ones are listed below.
Each link takes you to the setup documentation for the database engine. Pick
one that feels right to you and follow the instructions. If you would like more
explanation as to which database engine you should use, read about a `comparison
of relational database management systems.`_

- `SQLite`_
- `MySQL`_
- `PostgreSQL`_
- `BigQuery`_

.. _SQL Online Interpreter: https://sqliteonline.com/
.. _comparison of relational database management systems.: https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems
.. _SQLite: https://www.sqlite.org/quickstart.html
.. _MySQL: https://dev.mysql.com/doc/mysql-getting-started/en/
.. _PostgreSQL: https://www.postgresql.org/docs/10/tutorial-start.html
.. _BigQuery: https://cloud.google.com/bigquery/docs