SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

Many beginners feel lost when first learning SQL and hesitate to run code.

We cover the three most fundamental database operations in SQL Server—creating a custom database, listing all databases on the server, switching to a specific database, and safely dropping a database—explaining the principle, typical scenarios, and providing copy‑paste commands.

#Target Audience : people with zero SQL background, career switchers, interns, backend developers.

#Difficulty : ★ (essential for beginners).

What is a database? A simple analogy: a massive folder that stores all tables and business data.

All CRUD, aggregation, and joins require an existing database.

SQL Server includes system databases, but in practice you should create your own business database.

Common work scenarios

Initializing a new project’s environment.

Setting up local or server test environments.

Inspecting all databases on a server.

Cleaning up obsolete test databases.

Practical code you can copy directly

1. Create a custom database

CREATE DATABASE TestDB;

GO

2. List all databases on the server SELECT name FROM sys.databases; 3. Switch to / use a specific database

USE TestDB;

GO

4. Drop a database (use with caution)

DROP DATABASE IF EXISTS TestDB;

GO

Pitfalls for beginners

DROP permanently deletes the database; never run it in production without certainty.

Adding IF EXISTS prevents errors when the database is absent, improving fault tolerance. GO is a SQL Server‑specific batch separator; each batch must end with it.