This course is for you if you're looking for ways to improve the storage, retrieval, and maintenance of some data. No specific software skills are necessary; just bring a pencil and paper.
- [Instructor] 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 Excel spreadsheets or other data tables, and you've been told that you should make 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 a 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 will all go our separate ways into a specific software package to 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.
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
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.