Data Types in SQL | Online Course | Vertabelo Academy

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

Well done! You learned how a database can auto-generate primary keys and other values.

In the next part, you're going to practice how to store true/false information, and date and time information in your database.

17/17 Congratulations

2. GENERATED ALWAYS AS IDENTITY

3. GENERATED ALWAYS AS IDENTITY – insert rows

4. GENERATED ALWAYS AS IDENTITY – insert rows with identity

5. GENERATED ALWAYS AS IDENTITY – exercise

6. GENERATED BY DEFAULT AS IDENTITY

7. GENERATED BY DEFAULT AS IDENTITY – insert rows

8. GENERATED BY DEFAULT AS IDENTITY – create your own

9. IDENTITY with starting values and increment size

10. IDENTITY with starting values and increment size – exercise

11. Creating sequences

12. Getting values from sequences

13. Inserting rows with values from sequences

17. Congratulations

Perfect! That was the last exercise in this part of the course, and you got it. Congratulations!

In the next part, we'll focus on boolean, date and timestamp columns. 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.