Join Adam Wilbert for an in-depth discussion in this video What you should know before watching this course, part of Learning Relational Databases (2014).
To get the most out of this course, I simply expect that you have some data needs and are looking for ways to improve the storage, retrieval, and maintenance of that data. Maybe you're starting a business and will need to track inventory and payroll. Perhaps you've already got a series of spreadsheets or other data tables and you've been told that you should move your data into a database for efficiency's sake. Or perhaps you've taken an introductory course in a particular database management system, such as SQL Server or Microsoft Access. And while you understand the workings of that particular system, you're having troubles bridging the gap from how you get your information about real world events into a database structure.
This is actually a really common problem and the solution is to take a step back and look at the fundamentals of how you model your data. I've prepared this informational course to be as software independent as possible, so that it's applicable to a wide variety of relational database software. In fact, most of the things that we're going to be talking about require little more than a pad of paper and a pencil to work out. This is because the initial steps of creating a database are common across a wide variety of platforms. Eventually, we'll all go our separate ways into a specific software package, and actually build a database.
Some will choose packages like SQL Server or MySQL or Oracle or Access or PostgreSQL. And for that we'll need specific training on the package of choice. But for now, just grab a pencil and be prepared to think about your data from a variety of angles.
- 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.