SQL on VS Code

Question

Hi All! Pardon my lack of understanding, but I am just starting out learning coding. I was wondering if there is a way to practice SQL at home. I am trying to practice R, Python, and SQL through Visual Studio code. FYI you may have to break down what you mean at first. Thanks!

Answer 1

SQL is a database query language, so you need a database to use it :) There are free options like MySQL or PostgreSQL, but the easiest way is to start with Sqlite. This is a file-based database engine and it is built into Python standard library. You just need to
import sqlite3
and all set. Check the standard doc pages and try the examples there:
https://docs.python.org/3/library/sqlite3.html
You can also find many sqlite examples on the code playground. Use search :)