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 constraints are.

Next, you will get to know what foreign keys are and how to use them.

36/36 Summary

1. Constraints - Introduction

2. UNIQUE - Introduction

3. UNIQUE - Adding new rows

4. UNIQUE - Adding rows with the same value

5. UNIQUE vs. PRIMARY KEY

6. UNIQUE - Playing around

7. UNIQUE on multiple columns

8. UNIQUE on multiple columns - Playing around

9. Multiple UNIQUE constraints

10. NOT NULL - Introduction

11. NOT NULL - Adding NULL values

12. NOT NULL - Creating tables

13. NOT NULL - default behavior

14. NOT NULL - default behavior continued

15. NULL columns

16. NULL or NOT NULL?

17. NULL in ERD diagrams

18. CHECK - Introduction

19. CHECK - adding new values

20. CHECK - updating rows

21. CHECK - creating tables

22. CHECK - complex conditions

23. CHECK - conditions using a few columns

24. CHECK - updating rows with complex contraints

25. CHECK - practice

26. DEFAULT - Introduction

27. DEFAULT - Inserting data

28. DEFAULT - NULL values

29. DEFAULT - Creating tables

30. DEFAULT - Sequences

31. DEFAULT - Sequences #2

32. DEFAULT - Sequences #3

33. Revision #1

34. Revision #2

35. Revision #3

You killed it! Amazing! So much for this part of the course. See you again soon!

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.