Loading course... / 正在打开课程...

Courses Pro Get Pro Login / Register

COURSES WITH PLAYABLE LABS

0 total views

0 this month

Database and SQL Basics

Start with the concrete ideas of tables, rows, and columns, then meet databases, SQL, and database management systems by building a small users-products-orders data model.

Table of Contents

Chapter 1: Database and SQL Basics

1.1 What Is a Database?

1.2 What Is SQL?

1.3 Preparing Your First Database

Chapter 2: Querying Data

2.1 Using SELECT to Query Data

2.2 Filtering Data with WHERE

2.3 Common Query Conditions

2.4 Sorting and Limiting Results

Chapter 3: Inserting, Updating, and Deleting Data

3.1 Using INSERT to Add Data

3.2 Using UPDATE to Modify Data

3.3 Using DELETE to Remove Data

3.4 A Safe Workflow for Changing Data

Chapter 4: Multi-Table Queries and Aggregation

4.1 Why Do We Need Multiple Tables?

4.2 Querying Multiple Tables with JOIN

4.3 Aggregate Functions

4.4 Grouping Data with GROUP BY

Chapter 5: Table Design and End-to-End Practice

5.1 Creating and Modifying Tables

5.2 Primary Keys, Foreign Keys, and Common Constraints

5.3 A Simple Database Design Example

5.4 A Complete SQL Practice Flow

SUITABLE AUDIENCE

Complete beginners learning databases and SQL, including future backend developers and data analysts

© 2026 Leaflet Make knowledge happen.