Creating Tables in SQL | Online Course | Vertabelo Academy | Vertabelo Academy

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

Great job! Now you know how to create primary keys.

It's time to learn about foreign keys!

27/27 Summary

1. Primary keys – Introduction

2. Primary keys – Syntax

3. Primary keys – Missing values

4. Primary keys – adding new values

5. Primary keys – duplicated values

6. Primary keys – NULL values

7. Primary keys – summary

8. Syntax revisited

9. Primary key data type

10. Primary keys in ERD

11. There can only be one...

12. ...but one there should be!

13. Multi-column primary keys – introduction

14. Uniqueness with multi-column primary keys

15. Uniqueness with multi-column primary keys – continued

16. Uniqueness with multi-column primary keys – summary

17. Multi-column primary keys in ERD

18. NOT NULL – Adding NULL values

19. NOT NULL – Creating tables

20. NULLable columns – default behavior

21. NULLable columns – default behavior continued

22. NULL columns

23. NULL or NOT NULL?

24. NULL in ERD diagrams

Congratulations! You have successfully completed this section of the course. Primary keys and NULLs are no longer a mystery to you!

Click the Next exercise button to finish this part of the course.

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.