miniguide

SQL Cheatsheet: Essential Commands for Database Administration

Introduction

This cheatsheet provides common SQL commands useful for database creation, management, and troubleshooting. It is intended for DevOps personnel managing SQL databases on-premises or in the cloud.

Table of Contents

• SQL Cheatsheet: Essential Commands for Database Administration
  • Introduction
  • Table of Contents
    • 1. Create Database
    • 2. Drop Database
    • 3. Create Table
    • 4. Insert Data
    • 5. Select Data
    • 6. Update Data
    • 7. Delete Data
    • 8. Create Index
    • 9. Backup Database
    • 10. Restore Database

1. Create Database

CREATE DATABASE MyDatabase;

2. Drop Database

DROP DATABASE MyDatabase;

3. Create Table

CREATE TABLE Employees (
    Id INT PRIMARY KEY,
    Name VARCHAR(100),
    Department VARCHAR(50)
);

4. Insert Data

INSERT INTO Employees (Id, Name, Department) VALUES (1, 'Alice', 'IT');

5. Select Data

SELECT * FROM Employees;

6. Update Data

UPDATE Employees SET Department = 'HR' WHERE Id = 1;

7. Delete Data

DELETE FROM Employees WHERE Id = 1;

8. Create Index

CREATE INDEX idx_department ON Employees (Department);

9. Backup Database

BACKUP DATABASE MyDatabase TO DISK = 'C:\Backups\MyDatabase.bak';

10. Restore Database

RESTORE DATABASE MyDatabase FROM DISK = 'C:\Backups\MyDatabase.bak';