Skip to content
Tagged articles

Database Basics

3 articles · Page 1 of 1
liandk
liandk
Aug 8, 2026 · Databases

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

This tutorial walks SQL newcomers through the three essential database commands—creating a database, listing all databases, switching to a specific one, and safely dropping a database—providing copy‑paste code, practical scenarios, and beginner‑focused pitfalls.

Beginner TutorialDatabase BasicsSQL
0 likes · 3 min read
SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

SQL Fundamentals: CRUD, Joins & Execution Order Explained for Beginners

This tutorial explains SQL fundamentals including CRUD operations, the difference between SELECT * and explicit columns, table and column aliases, INNER/LEFT/RIGHT JOIN types with practical examples, and the SQL execution order (FROM/JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT) using a cooking analogy, plus beginner tips.

AliasesBeginner TutorialCRUD
0 likes · 13 min read
SQL Fundamentals: CRUD, Joins & Execution Order Explained for Beginners
ITPUB
ITPUB
Sep 26, 2021 · Databases

Master SQL Basics: From Zero to Simple Queries with Real Examples

This tutorial walks beginners through the fundamentals of SQL, explaining what it is, how to run simple SELECT statements, create tables, insert, update, delete records, use WHERE clauses, and even generate fun graphics like stars and calendars using advanced queries.

CRUDDatabase BasicsOracle
0 likes · 11 min read
Master SQL Basics: From Zero to Simple Queries with Real Examples