Database Foundations: Data Structures Preview

Database Foundations: Data Structures

With Adam Wilbert Liked by 390 users
Duration: 2h 56m Skill level: Beginner Released: 12/17/2020

Start my 1-month free trial

Course details

This course focuses on seven core concepts: data types, designing a normalized database, identifying rows with primary keys, linking data with foreign keys, formalizing data relationships, indexes, and constraints. Database expert Adam Wilbert describes techniques that database developers use to protect their data. He explains why data types are important in creating a consistent data storage environment, then walks you through several common data types. Adam shows you the three normal forms of good database design.

In order to work with the data stored in each row in a table, the table must contain a primary key column, or set of columns. Foreign keys provide the glue that the entire system is built on. Adam steps you through how to incorporate primary keys and foreign keys into the design of your database tables. He walks through data relationships, indexes, and constraints, then concludes with other courses you may find useful.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.8 out of 5

218 ratings
  • 5 star
    Current value: 182 83%
  • 4 star
    Current value: 31 14%
  • 3 star
    Current value: 4 1%
  • 2 star
    Current value: 0 0%
  • 1 star
    Current value: 1 <1%

Contents

What’s included

  • Practice while you learn 2 exercise files
  • Test your knowledge 7 quizzes
  • Learn on the go Access on tablet and phone
  • Stay up to date Continuing Education Units

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.