Sequence | Serial data types in Postgresql | Full Course | Source Code

Sequence and Serial data types: Postgresql Full Course | PSQL | Screencasts | #psql #postgresql

The best way to learn the concept is to watch the video, use the links below and take notes and then solve the homework added in the description. You can find a solution on teachmedatabase.com once the video has been live for a week. But also comment your solutions here.

Homework:
Create a sequence called auction_logs which starts from 100 and has an increment of 50. Use it to log auction activity on a hypothetical Laptop on ebay (hint: insert in to ebay_auction table). Alter the sequence to increment by 60. At the end drop the sequence (table) and make sure it is not available in pg_sequences table.

Ω Donate: If you appreciate the value of what I provide and would like to make a donation use the link here: https://www.teachmedatabase.com/donate/

? teachmedatabase.com is focused on helping you become a pro when it comes to databases and become a strongly skilled backend/full-stack engineer. Subscribe for full access to full code contents, homework answers, and newsletters: https://www.teachmedatabase.com/

This screencast will take deep dive at sequences and series in PostgreSQL/PSQL. Through the video, we explore all about sequences, series data type, sequence-related PostgreSQL system information tables, and also go through the source code in detail to understand how it all works behind the scene.

Thanks for watching, if you like what you saw, give the video a like, and don't forget to subscribe! It inspires me to keep going.

Contents:
00:00 Introduction
00:44 teachmedatabase.com
01:33 What is a Sequence
04:40 Create Sequence (and Numeric Ranges)
20:57 Alter Sequence
22:29 Drop Sequence
24:04 Sequence C Source Code
27:43 pg_sequences C Source Code
29:29 Serial Data Type
35:22 Serial functions and Source Code
44:46 pg_get_serial_sequence
46:05 Recap
48:13 Your Homework
49:18 Thank you

Important Links:
? psql sequence: https://www.postgresql.org/docs/9.5/sql-createsequence.html
? PSQL sequence errors definitions github: https://github.com/postgres/postgres/blob/c30f54ad732ca5c8762bb68bbe0f51de9137dd72/src/test/regress/expected/sequence.out
? Doxygen Postgresql sequence.c source code: https://doxygen.postgresql.org/sequence_8c_source.html#l00079
?Numeric Data Type: https://www.postgresql.org/docs/9.5/datatype-numeric.html#DATATYPE-FLOAT
?Sequence Manipulation Functions: https://www.postgresql.org/docs/9.5/functions-sequence.html
?pg_sequence: https://www.postgresql.org/docs/10/view-pg-sequences.html
? Datagrip IDE: https://www.jetbrains.com/datagrip/