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 primary keys are.

Next, you will learn about constraints.

30/30 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. Multicolumn primary keys - introduction

14. Uniqueness with multicolumn primary keys

15. Uniqueness with multicolumn primary keys - continued

16. Uniqueness with multicolumn primary keys - summary

17. Multicolumn primary keys in ERD

18. New keyword IDENTITY

19. Auto-increment with IDENTITY

20. Creating columns with IDENTITY

21. IDENTITY parameters

22. IDENTITY parameters - continued

23. The AUTO_INCREMENT keyword

25. Retrieving data from sequences

26. Auto-numbering in various databases

27. Revision #1

28. Revision #2

29. Revision #3

Congratulations! You have successfully completed this part of the course. Primary keys 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.