Data Wrangling with SQL

Table of Contents

Preface

Part 1: Data Wrangling Introduction

1

Database Introduction

Getting started

Establishing the foundation

Efficient data organization

Data integrity and consistency

Technical requirements

Decoding database structures – relational and non-relational

What is a database?

Types of databases

Tables and relationships

The SQL CREATE DATABASE statement

The SQL CREATE TABLE statement

SQL DROP TABLE versus TRUNCATE TABLE

SQL ALTER TABLE

SQL constraints

SQL keys

Database relationships

Comparing database normalization and denormalization

Normalization

Types of normalization

Denormalization

When to apply denormalization

Disadvantages of denormalization

Summary

Practical exercises

Practical exercise 1

Practical exercise 2

Practical ...