DEV Community

Tahir Rafique
Tahir Rafique

Posted on

I am Learning SQL(mysql) in 2025.

#learning #sql #sqlserver #database
  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,
);
Enter fullscreen mode Exit fullscreen mode

Top comments (2)

Collapse
 
xwero profile image
david duymelinck • • Edited

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.

Collapse
 
nevodavid profile image
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