Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course will help you overcome these hurdles. Adam Wilbert teaches the basics of relational database design, regardless of whether you are using Access, FileMaker, Open Office, or SQL Server. Learn common database mistakes to look out for, discover how to diagram use cases and requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views.
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 it's 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 of 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.
There are currently no FAQs about Relational Database Fundamentals.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.