Database Foundations: Data Structures
With Adam Wilbert
Liked by 390 users
Duration: 2h 56m
Skill level: Beginner
Released: 12/17/2020
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.
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.
LinkedIn Learning
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
-
MEGAN FONSECA
MEGAN FONSECA
Officer Customer Data Issue Management at Standard Bank
-
Jaffeth Alfaro Torres
Jaffeth Alfaro Torres
| Cybersecurity Engineer | Network Engineer | Technical Support |
-
L. Fernando García Barrero
L. Fernando García Barrero
Laboratorio SANILAB CALIDAD,S.L. - Grupo ANALIZA CALIDAD
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