Join Adam Wilbert for an in-depth discussion in this video What is a database management system (DBMS)?, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…In this course, we're going to be moving towards…storing our data inside of a database management system.…Before we can understand what a database management system…is, we first need to understand what a database is.…At its most basic level, a database is a collection of individual data items…that are stored in a highly structured way that represents a model of reality.…This collection of data items can be stored in a single location or…hard drive or distributed across large…networks with components in many physical locations.…Regardless of where the data is physically stored, the database acts as…a single entity to anyone or any system that makes use of it.…
In order to make use of the database, we…need a way to perform what are called CRUD tasks.…That is to say we need a way to create new data items, read and…find existing data items, update data items…with new information, and delete outdated data items.…This is the responsibility of a database engine.…A collection of programs that are able to sift…through the database items and perform the required tasks.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.