Creating Tables in SQL | Interactive Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Now you know what foreign keys are and how to use them.

In the next part, you will learn about views.

27/27 Revision - Summary

1. Foreign Keys - Introduction

2. Referring to one table from another

3. JOIN - revision

4. Adding new data

5. Adding incorrect data

6. Adding incorrect data - explained

7. Creating tables with foreign keys

8. Inserting incorrect data with foreign keys

9. Updating incorrect data with foreign keys

10. Updating data in the table the foreign key points to

11. Creating tables with foreign keys on your own

12. Foreign keys in ERD diagrams

13. Creating multicolumn foreign keys

14. Playing around with multicolumn foreign keys

15. Creating multicolumn foreign keys on your own

16. Creating multiple foreign keys in one table

17. Foreign key columns as primary key columns

18. Foreign key columns as primary key columns - practice

19. Updating rows with foreign keys

20. REFERENCES explained

21. Database behavior with CASCADE - Updating rows

22. Database behavior with CASCADE - Deleting rows

23. Database behavior with various kinds of foreign keys

24. Revision - #1

25. Revision - #2

26. Revision - #3

27. Revision - Summary

Wow! You killed it!

That's all we've prepared for you in this part of the course. We're getting near the end of the course and you're getting smarter and smarter. Well, see you soon in part 7!

Click the Next exercise button to finish the part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.