SQL(4)

SQL basics, from databases and the relational model to SELECT, WHERE, GROUP BY and JOIN

What Is a Database? How It Differs from an Excel Sheet

What Is a Database? How It Differs from an Excel Sheet

SQLExcel
Relational Database Structure: Tables, Rows, Columns, Schema

Relational Database Structure: Tables, Rows, Columns, Schema

SQLExcel
Primary Key vs Foreign Key: How Tables Connect

Primary Key vs Foreign Key: How Tables Connect

SQLExcel Functions
Database Normalization: Why Split Data into Multiple Tables?

Database Normalization: Why Split Data into Multiple Tables?

SQLData Cleanup

All Tags