Learning Objects Authored

• Data Manipulation Language

  By jamiecchavez

  Explore what DML is including its main commands INSERT, UPDATE, DELETE, and SELECT.

  Watch Now

  150

  1,240

  More Less

• Database Data Types

  By jamiecchavez

  In this activity, you'll learn about the different data types associated with databases.

  Watch Now

  148

  1,094

  More Less

• Database Naming Conventions

  By jamiecchavez

  In this learning activity, you'll discover and then follow established rules when naming database objects.

  Watch Now

  140

  1,368

  More Less

• JOINs (Inner, Left, Right, Full)

  By jamiecchavez

  In this learning activity, you’ll explore four different types of JOINs and understand how they help programmers produce readable reports.

  Watch Now

  129

  1,578

  More Less

• Normalization – 1st Normal Form

  By jamiecchavez

  In this learning activity you'll explore and practice the first step in normalizing a database.

  Watch Now

  43

  7,736

  More Less

• Normalization – 2nd Normal Form

  By jamiecchavez

  In this activity you'll practice designing a table in second normal form.

  Watch Now

  29

  2,554

  More Less

• Normalization – 3rd Normal Form

  By jamiecchavez

  In this learning activity, you'll be introduced to Third Normal Form and you'll design a table following these rules.

  Watch Now

  33

  2,143

  More Less

• Referential Integrity

  By jamiecchavez

  Explore what referential integrity is, why it's important to reliable data organization, and learn how it enforces constraints.

  Watch Now

  143

  1,005

  More Less

• Understanding Common DDL Statements

  By jamiecchavez

  In this learning activity, you’ll explore the Data Definition Language (DDL) including its three main commands: CREATE, ALTER, and DROP.

  Watch Now

  139

  726

  More Less

• What is Database Denormalization?

  By jamiecchavez

  In this activity, the learner will understand what denormalization is and when it's an appropriate strategy.

  Watch Now

  146

  666

  More Less

• What Is Normalization?

  By jamiecchavez

  In this learning activity you'll examine how database normalization eliminates redundancy and helps maintain consistency within a relational database.

  Watch Now

  28

  2,512

  More Less