Wow, we’ve covered many new topics, so let’s take a brief look at all you've learned.
We started on the relational database model and compared it to NoSQL and the circumstances where you might use a NoSQL database versus a traditional relational database.
Exploring the chosen database management system (DBMS), we looked at SQL Server Express Edition, along with many of the features available to you. We looked at tables, stored procedures, jobs, and triggers, as well as their roles within the DBMS.
Then we moved into data types, and how to use them, to store specific types of data like numbers, date/time, boolean, and text. Keeping the database together with the rules of entity integrity and referential integrity, rounded out our discussion.
Lastly, we explored the reasons for normalization and how to achieve each of the normal forms to reduce redundancy and improve the lifespan of the database as a whole.
Now that you’ve learned how to design the logical model for your relational database, you’re ready to construct an actual database! After you complete the final quiz and activity, head to the next course in this series, Implement a Relational Database with SQL, where I'll guide you through the process of constructing, populating, and maintaining your database with examples in SQL Server Express Edition. Hope to see you there!
