Database

Database

06 December, 2020
💡 https://academy.zerotomastery.io/courses/1073491/

Database

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

SQL is a query language for navigating through a database. SQL is used to create, read, modify and delete records from a database.

Query

A query, in SQL, is a way to make database engines understand user’s instructions.

Example: SELECT * FROM Users WHERE role='manager

breakdown of above example:

Comments

In SQL, a line prefixed with == will be treated as a comment, and won’t be executed.

SQL is a Declarative Language.

TODO: Learn more about declarative and imperative language.

Original name of SQL is SEQUEL.

SELECT Statement

Used to print/get data from a database.

abdus s. azad
About the Author
Abdus is a Software Engineer working at Level. In his free time, he likes to play with Linux-based machines. Contact him at abdus@abdus.net.
GitHub