DatabaseNotes are from a course on Zero to Mastery I am currently doing-->
It's a structured set of data which is structured in a certain way so that it can be scaled as and when required.
SQL is a query language for navigating through a database. SQL is used to create, read, modify and delete records from a database.
A query, in SQL, is a way to make database engines understand user's instructions.
SELECT * FROM Users WHERE role='manager
breakdown of above example:
SELECT: literal meaning.
*: identifier (can be any column name from a table).
*means select all available fields
FROM: literal meaning
Users: Name of the table
WHERE: literal meaning
roleis a column name. this essentially means, return record only is column
rolematches the value
In SQL, a line prefixed with
== will be treated as a comment, and won't be
SQL is a Declarative Language.
TODO: Learn more about declarative and imperative language.
Original name of SQL is SEQUEL.
Used to print/get data from a database.