SQL & Database Fundamentals - Dot Curve Designers

About Course

Learn SQL and relational database fundamentals through practical queries, database design and data management. This beginner-friendly course focuses on building practical database skills.

Course Content

Module 02 — SQL Fundamentals

Introduction to SQL
Creating Databases
Creating Tables
SQL Data Types
INSERT Statements

Module 03 — Reading Data

Module 04 — Updating & Deleting Data

Module 05 — SQL Functions

Module 06 — Relationships & Joins

Module 07 — Database Design

Module 08 — Advanced SQL Fundamentals

Module 09 — Practical Database Project

Module 01 — Database Foundations

Student Ratings & Reviews

No Review Yet

About Course

Course Content

Module 02 — SQL Fundamentals

Introduction to SQL

Creating Databases

Creating Tables

SQL Data Types

INSERT Statements

Module 03 — Reading Data

SELECT Statements

WHERE Clause

ORDER BY

DISTINCT

LIMIT

Filtering Data

Module 04 — Updating & Deleting Data

UPDATE Statements

DELETE Statements

Safe Data Modification

Working with NULL Values

Module 05 — SQL Functions

COUNT

SUM

AVG

MIN & MAX

GROUP BY

HAVING

Module 06 — Relationships & Joins

Understanding Relationships

INNER JOIN

LEFT JOIN

RIGHT JOIN

Multiple Table Queries

Module 07 — Database Design

Database Planning

Normalization Fundamentals

Keys & Constraints

Designing Relational Tables

Module 08 — Advanced SQL Fundamentals

Subqueries

Views

Indexes

Transactions

Query Optimization Basics

Module 09 — Practical Database Project

Project Requirements

Database Design

Creating the Database

Writing Queries

Testing the Database

Module 01 — Database Foundations

What is a Database?

Relational Databases

Tables, Rows & Columns

Primary & Foreign Keys

Setting Up a SQL Environment

Student Ratings & Reviews