Learn how databases work and how to start designing one of your own.
- [Voiceover] Hello, my name is Adam Wilbert, and I'd like to welcome you to Relational Database Fundamentals. This course is all about getting started storing your real world data in a database, using a relational model. In this course, I'm going to give you an overview of the planning steps that you should move through before you start development, in order to ensure that your system works as expected. I'll start with an overview of what exactly a relational database is, and how its structure differs from the spreadsheets you might be used to working with, and I'll outline some of the hidden difficulties that can arise if the structure of your data isn't fully considered before development begins.
Then we will discover the database development life cycle, and use it as a guide for moving through the process of thinking about our specific data storage needs. Finally, we'll talk about taking all the rules that we've identified, about how the database needs to function, and start translating them into the components that will make up the actual relational database. And along the way, we'll discuss design considerations that will make your database easier to construct, and easier to maintain. So, I'd like to thank you for joining me in Relational Database Fundamentals.
Now let's get started.
- 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.