Introduction to Databases-Course Introduction
Introduction to the program
()
Introduction to databases
()
A day in the Life of a Database Engineer
()
Course syllabus: Introduction to databases
How to be successful in this course
Introduction to Databases-Databases and data
What is a database?
()
How is data related?
()
Relational data example charts
Alternative types of databases
()
Database Evolution
Additional resources
Introduction to Databases-Intro to SQL
What is Structured Query Language?
()
SQL usage
()
Advantages of SQL
()
SQL syntax introduction
()
Common SQL Commands
Additional resources
Introduction to Databases-Basic database structure
What are tables in databases?
()
Tables overview
Database structure overview
Types of keys in a database table
()
Module summary: Introduction to Databases
()
Additional resources
Create, Read, Update and Delete (CRUD) Operations-SQL data types
Numeric data types
()
String data types
()
Default values
()
Additional resources
Create, Read, Update and Delete (CRUD) Operations-Create and read
CREATE and DROP database
()
CREATE TABLE statement
()
ALTER TABLE statement
()
INSERT statement
()
Creating tables
SELECT statement
()
INSERT INTO SELECT statement
()
Additional resources
Create, Read, Update and Delete (CRUD) Operations-Update and delete
Updating data
()
Deleting data
()
Module summary: Create, Read, Update and Delete (CRUD) Operations
()
Additional resources
SQL Operators and sorting and filtering data-SQL operators
SQL Arithmetic Operators
()
SQL Arithmetic Operator Examples
Operators in use
()
SQL Comparison operators
()
SQL Comparison operator examples
Additional resources
SQL Operators and sorting and filtering data-Sorting and filtering data
ORDER BY clause
()
Types of ordering / sorting
WHERE clause
()
WHERE Clause uses
SELECT DISTINCT clause
()
SELECT DISTINCT clause in use
Module summary: SQL operators and sorting and filtering data
()
Additional resources
Database design-Designing database schema
Database schema
()
Exploring database schema
Schema in use
()
Types of database schema
()
Building a schema
Additional resources
Database design-Relational database design
Table relationships
()
Relational model
Primary key
()
Foreign key
()
Keys in depth
Finding entitites
()
Entity relationship diagrams (ERD)
Additional resources
Database design-Database normalization
What is database normalization?
()
Data normalization
First normal form 1NF
()
Second normal form 2NF
()
Third normal form 3NF
()
Module summary: Database design
()
Additional resources
Graded assessment-Graded Assessment
Course Recap: Introduction to databases
()
About the final graded quiz assessment
Graded assessment-Course wrap-up
Congratulations, you have completed Introduction to databases
()
Next steps after Introduction to Databases