I am Learning SQL(mysql) in 2025.

1. Database & DBMS
2. Type of DB, SQL & non-sql / (RDBMS vs NRDBMS)
3. SQL
4. Tables, Columns(schema), Rows(individual data)
5. MY First Query

SQL is not Case-Senstive
semi-colon important at every line-end

CREATE DATABASE college;
DROPE DATABASE college;

create table students(
// column_name datatype constraint
id int primary key,
name varchar(50),
age int not null,
);

Comments

[david duymelinck]

I want to point out some errors:

• the sqlserver tag is short for Microsoft sql server.
• DROPE DATABASE college; should be DROP (probably a typo)

An improvement I would make is age int DEFAULT 0. All languages are using more typing for variables, so it is better to return a default result that matches the type. Null is seen as a lazy solution nowadays.

[Nevo David]

yeah learning sql can get kinda messy with all the weird details, tbh sometimes i still forget little syntax stuff - you ever catch yourself mixing up commands or does it all just click after some practice