What is it?
Microsoft SQL Server is a Relational Database Management System (RDBMS) that stores and retrieves data
Commands
There are many keywords in SQL:
- SELECT - extracts data from a database
- UPDATE - updates data in a database
- DELETE - deletes data in a database
- INSERT INTO - inserts new data into a database
- CREATE DATABASE - creates a new database
- ALTER DATABASE - modifies a database
- CREATE TABLE - creates a new table
- ALTER TABLE - modifies a table
- DROP TABLE - deletes a table
- CREATE INDEX - creates an index (search key)
- DROP INDEX - deletes an index