FB

Start Here

Looking for the right article to improve your knowledge or solve a problem you might be having?

Well, this is the place to start.

Here are some of the most important articles on the website.

 

New to SQL and Databases

Introduction to Oracle SQL tutorial: this page lists my free video series on getting started with Oracle SQL.

59 Best Resources for Learning SQL: this page lists a lot of other ways you can learn SQL: books, courses, videos, on different database vendors (SQL Server, Oracle, MySQL, PostgreSQL, etc).

What is a Database Schema?

A Guide to the Entity Relationship Diagram (ERD)

SQL Create Table: The Complete Guide

SQL ALTER TABLE: The Complete Guide

SQL DROP TABLE: The Complete Guide

SQL Select Statement

SQL INSERT: The Complete Guide

SQL UPDATE Statement: The Complete Guide

SQL DELETE Statement – The Complete Guide

SQL GROUP BY and HAVING: The Complete Guide

SQL ORDER BY – The Complete Guide

SQL Joins: The Complete Guide

How to Install Oracle on a Mac

Database Normalization: A Step-By-Step-Guide With Examples

The Definitive Guide to Becoming a Database Developer

 

Experienced

A Guide to the Oracle Data Types

SQL TRUNCATE TABLE Statement: The Complete Guide

Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

Singular vs Plural and Other Database Table Naming Conventions

Oracle SQL Indexes – The Definitive Guide

50 SQL Editors and IDEs Compared (2020): The Ultimate List

76 Data Modeling Tools Compared

SQL Views: The Complete Guide (including Materialised Views)

24 Database Design Mistakes and How to Avoid Them

PL/SQL Tutorial

 

General

SQL Roadmap – A guide to all of the SQL and database topics that database developers and administrators should aim to learn.

Sample Databases: a collection of all of the sample databases available on Database Star.