Meta - Introduction to Databases for Back-End Development 

Introduction to databases

A day in the Life of a Database Engineer

What is a database?

How is data related?

Alternative types of databases

What is Structured Query Language?

SQL usage

Advantages of SQL

SQL syntax introduction

What are tables in databases?

Types of keys in a database table

Module summary: Introduction to Databases

Course syllabus: Introduction to databases

How to be successful in this course

Relational data example charts

Database Evolution

Additional resources

Common SQL Commands

Additional resources

Tables overview

Database structure overview

Additional resources

Knowledge check: Databases and data

Knowledge check: SQL syntax review

Knowledge check: Database structure

Module quiz: Introduction to Databases

Numeric data types

String data types

Default values

CREATE and DROP database

CREATE TABLE statement

ALTER TABLE statement

INSERT statement

SELECT statement

INSERT INTO SELECT statement

Updating data

Deleting data

Module summary: Create, Read, Update and Delete (CRUD) Operations

Additional resources

Creating tables

Additional resources

Additional resources

Self review: Working with numbers

Self review: Working with strings

Self review: Working with default values

Self review: Choosing the right data type for a column

Self-review: Create Database, create table and insert data

Self review: Practicing table creation

Knowledge check: Create, insert and select

Self-review: Record deletion

Knowledge check: Update and Delete

Module quiz: Create, Read, Update and Delete (CRUD) Operations

SQL Arithmetic Operators

Operators in use

SQL Comparison operators

ORDER BY clause

WHERE clause

SELECT DISTINCT clause

Module summary: SQL operators and sorting and filtering data

SQL Arithmetic Operator Examples

SQL Comparison operator examples

Additional resources

Types of ordering / sorting

WHERE Clause uses

SELECT DISTINCT clause in use

Additional resources

Knowledge Check: Operators

Self-review: ORDER BY and WHERE

Module quiz: SQL operators and sorting and filtering data

Database schema

Schema in use

Types of database schema

Table relationships

Primary key

Foreign key

Finding entitites

What is database normalization?

First normal form 1NF

Second normal form 2NF

Third normal form 3NF

Module summary: Database design

Exploring database schema

Building a schema

Additional resources

Relational model

Keys in depth

Entity relationship diagrams (ERD)

Additional resources

Data normalization

Additional resources

Knowledge check: Database schema

Knowledge check: Defining keys

Database relations and keys

Knowledge Check: Database normalization

Self-review: Database schema examples

Module quiz: Database design

Course Recap: Introduction to databases for back-end development

Congratulations, you have completed Intro to databases for back-end development!

About the graded assessment

Next steps after Introduction to Databases

Graded Assessment: Intro to databases