SQL Constraints

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

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

Great! Now that you remember how to deal with primary and foreign keys, we can move forward.

Let's waste no more time!

Next exercise

19/19 Congratulations

1. Welcome

2. Creating tables with single-column primary keys

3. Creating tables with multi-column primary keys

4. Adding primary keys to existing tables

5. Adding primary keys with custom names to existing tables

6. Deleting primary keys

7. Creating tables with foreign keys

8. Adding foreign keys to existing tables

9. Deleting foreign keys

10. Inserting rows with foreign key constraints

11. Updating rows with foreign keys

12. REFERENCES explained

13. Database behavior with CASCADE – Updating rows

14. Database behavior with CASCADE – Deleting rows

15. Database behavior with various kinds of foreign keys

You've made it to the end of Part 1. Congratulations!

In the next part, we'll talk about a new constraint type, UNIQUE. See you there!

Click Next exercise to finish this 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.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Great job!

Instruction

Exercise

Need assistance?