Master relational database design with practical concepts and examples applicable to all systems. Improve your skills in structuring tables and relationships confidently.
This course is all about designing relational databases in a fun and approachable way! You’ll learn how to structure data, understand relationships, and use SQL—all without needing any programming skills. Perfect for anyone looking to get a solid grip on database design.
Learn relational database Design with practical concepts and examples. This series works with any database system!
Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases:
MySQL
Oracle
Microsoft SQL Server
PostgreSQL
SQLite
MiariaDB
and MORE!
We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth.
Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish.
No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy.
After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!
Learn the definition of relations, tuples, attributes, and over one hundred other vocabulary words!
Learn all of the types of relationships and how to properly design them all within a database. This includes one to one, one to many, and many to many. You will also learn about the difference between a parent table and a child table
Learn about all of the types and categories of keys including superykeys, candidate keys, primary keys, alternate keys, natural keys, surrogate keys, simple keys, compound keys, composite keys, and foreign keys
11 Lectures
9 Lectures
12 Lectures
6 Lectures
4 Lectures
6 Lectures
1 Lectures
Hi! I'm Caleb. I have created over 1,500 tutorials on data, software development, cryptocurrency, etc. I believe that the way I teach is what matters. I don’t flash big words without explaining them and I don’t assume knowledge. I keep it simpleMy goal is to simplify complex problems for anyone to understand. I'm not your typical "teachers who can create...
Great curse and a very enthusiastic instructor, make the course easy to follow, the instructor present the topics in order to understand the purpose of this curse, either for an introductory level to a remainder to those with more experience, I definitely will recommend it.
This guy rocks and is very thorough
Bueno pero pierde bastante tiempo
It's easy and fun to follow. Concise but precise explanations. Thank you Caleb.
He does not take advantage that he can edit his videos and present fully prepared examples. All examples on his course are made at the moment and are very awful, like a bad teacher who does not prepare the class and take forever at the blackboard to show you a poor made up example. Course is very basic, so if you know next to nothing it will be helpful. Another thing, we paid for the course so we expect to avoid the annoying thing of "be sure to subscribe" at the end of every video, like if it was a free video you're watching on youtube.
This course is real fun and easy to understand for beginners even for intermediate level knowledge person also has some juice there in the course. GO ahead take the course !!
Informative, good humour. It would have been better if there quizzes, exercises to complete and check understanding.
The presenter is very enthusiastic and obviously knowledgable. There are several mispronunciations of important terms and this is obviously ported from Youtube.
It was a good experience by going through the lectures. Some exercises can be added with the lectures so the student can check his/her understanding of concepts. I would like to point out one more thing there is a time lag of 6-7 seconds in the video lectures of look up table.
Your email address will not be published. Required fields are marked *
Chris H.
Not a well put together video series so far. The instructor often repeats himself and rambles. Even if the content is technically presented, it's just hard to watch.