Analytics Demo Scripts

Video 2: Ranking rows

https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7

Video 3: More options for ranking rows

https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn

Video 4: Using the Tabibitosan method for grouping sets of rows

https://livesql.oracle.com/apex/livesql/s/cljrgh80cczwjtptlpk2e5081

Video 5: CUME_DIST, PERCENT_RANK and NTILE

https://livesql.oracle.com/apex/livesql/s/clq6jmj1jzju4k23v3tnbzo8u

Video 6: Dealing with NULLS

https://livesql.oracle.com/apex/livesql/s/cokpdete3hiy3jo0yzoa4eerz

Video 7: Analytics as predicates

https://livesql.oracle.com/apex/livesql/s/cokv9220ffzt8iqs7udqsv5vm

Video 8: The partition clause

https://livesql.oracle.com/apex/livesql/file/content_ERYV6B909XK196IAKLBUQIJSN.html

Video 9: Aggregation with partitions

https://livesql.oracle.com/apex/livesql/file/content_CPWDPU6R5I13KQG8EFUO5OPPZ.html

Video 11: The window clause

https://livesql.oracle.com/apex/livesql/file/content_CQXSUXL3JBUOBC82NO9SKKGLE.html

Video 12: More on the window clause

https://livesql.oracle.com/apex/livesql/file/content_CQXSUXL3VBUVDY45G4ASDXXI6.html

Video 13: The RANGE option in the Window clause

https://livesql.oracle.com/apex/livesql/file/content_CR93UBGK2U7OAW6K1EHTBBYHD.html

Video 14: FIRST_VALUE / LAST_VALUE for Windows

https://livesql.oracle.com/apex/livesql/file/content_CTQ60ECMLQDBA256F79UY1YZ5.html

Video 15: NTH_VALUE for Windows

https://livesql.oracle.com/apex/livesql/file/content_CVLPCO2ZHLLF15JGHXMCJ0FIL.html

Video 16: Handling nulls in Windows

https://livesql.oracle.com/apex/livesql/file/content_CW352GZBQYPMETRF31HG2Z034.html

Video 17: Dynamic windows

https://livesql.oracle.com/apex/livesql/file/content_CYAE37SZBU2770BVYW2OT1Q4I.html

Video 18: Lag and Lead

https://livesql.oracle.com/apex/livesql/file/content_CZUCT0MCOQZMJM7TI553HC8S9.html

Video 19: Lag and Lead extensions

https://livesql.oracle.com/apex/livesql/file/content_C0SXW1PG37G8REE0VTQH5LXJ8.html

Video 20: Removing the duplicates

https://1drv.ms/u/s!Aifh7VuM9I2xgQDClpz16T2QvAFo

Video 21: TOP-N queries

https://1drv.ms/u/s!Aifh7VuM9I2xgQm8eqdtQ1ZykvVJ

Video 22: Grouping ranges re-visited

https://livesql.oracle.com/apex/livesql/file/content_C35KKE5TX8H1O3M2Z5TLAGAON.html

Video 23: In-list processing

https://livesql.oracle.com/apex/livesql/file/content_C40G9LF09VJ8W43VGG7ZXDAMO.html

Video 24: Concatenating strings

https://livesql.oracle.com/apex/livesql/file/content_C5NPSOT3UKM9D7BG5J75SPQ2D.html

Video 25: A closer look at LISTAGG

https://livesql.oracle.com/apex/livesql/file/content_C8VCZCTSTJH9A2U9ZMYE10K1Y.html

Video 26: The KEEP clause

https://livesql.oracle.com/apex/livesql/file/content_C85WW581KIH95H1QKH08H8H5G.html

Video 27: Hypothetical analytics and ratios

https://livesql.oracle.com/apex/livesql/file/content_DBCCAWYD3M9R9SVS21SUGK1Q5.html

Video 28: PIVOT and UNPIVOT

https://livesql.oracle.com/apex/livesql/file/content_DCC032IJONO8467JXDM2X9I7T.html

Video 29: Partitioned outer join

https://livesql.oracle.com/apex/livesql/file/content_DDWIGFEMAI346G037QIRDJS8D.html

Video 30: Frequent itemsets

https://1drv.ms/u/s!Aifh7VuM9I2xfJvMsuP5A6hCEa0