Basics of the SELECT Statement
By Glen Orsburn
Learners use this Structured Query Language tutorial to gain an understanding of how a SELECT statement is built. This learning object has audio content.
What Is Normalization?
In this learning activity you'll examine how database normalization eliminates redundancy and helps maintain consistency within a relational database.
Normalization – 1st Normal Form
In this learning activity you'll explore and practice the first step in normalizing a database.
Database Naming Conventions
In this learning activity, you'll discover and then follow established rules when naming database objects.
Normalization – 3rd Normal Form
In this learning activity, you'll be introduced to Third Normal Form and you'll design a table following these rules.
Database Data Types
In this activity, you'll learn about the different data types associated with databases.
Normalization – 2nd Normal Form
In this activity you'll practice designing a table in second normal form.
Explore what referential integrity is, why it's important to reliable data organization, and learn how it enforces constraints.
JOINs (Inner, Left, Right, Full)
In this learning activity, you’ll explore four different types of JOINs and understand how they help programmers produce readable reports.
Data Manipulation Language
Explore what DML is including its main commands INSERT, UPDATE, DELETE, and SELECT.
Understanding Common DDL Statements
In this learning activity, you’ll explore the Data Definition Language (DDL) including its three main commands: CREATE, ALTER, and DROP.
What is Database Denormalization?
In this activity, the learner will understand what denormalization is and when it's an appropriate strategy.