Course Highlights
  • Concepts and principles that underpin how databases work.
  • Plan and execute a simple database development project.
Curriculum

28 Topics
Introduction to the program
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
What do you hope to learn?

33 Topics
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
Exercise: Working with numbers
Exercise: Working with strings
Working with default values 
Choosing the right data type for a column 
Exercise: Create Database create table and insert data
Exercise: Practicing table creation
Exercise: Record deletion

18 Topics
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
ORDER BY and WHERE

28 Topics
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
Database schema examples

6 Topics
Course Recap: Introduction to databases
Congratulations you have completed Introduction to databases
About the final graded quiz assessment
Next steps after Introduction to Databases
Final graded quiz: Intro to databases
What are your thoughts on working with databases?

  Write a Review

Introduction to Databases

Go to Free Course