Analytic Functions A Developer’s Best Friend
Timothy Hall, DBA, Developer, Author, Trainer, oracle-base.com Oracle analytic functions are among the most powerful but least understood tools in the Oracle developer’s arsenal. During this presentation, you will be introduced to the analytic function syntax and see demonstrations of some of the most useful analytic functions.
▶︎
Real-Life SQL Tuning: From Four Minutes to Eight Seconds in an Hour
▶︎
Dynamic SQL in PL/SQL
▶︎
Ten SQL Tricks that You Didn’t Think Were Possible (Lukas Eder)
▶︎
Life As An Oracle DB Dev - 25 Million Lines Of Code
▶︎
Explaining Explain Plans
▶︎
SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
▶︎
The five-step guide to SQL tuning | CloudWorld 2022
▶︎
I Think They Are Lying To You
▶︎
How do nested loop, hash, and merge joins work? Databases for Developers Performance #7
▶︎
3 Tips to Help You Write Better SQL
▶︎
Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎
PL/SQL Collections
▶︎
Data Analytics for Beginners | Data Analytics Training | Data Analytics Course | Intellipaat
▶︎
When You Try To Be Microsoft…The Fall Of Salesforce
▶︎
Top PL/SQL Tips In Just One Hour
▶︎
Materialized Views and More SQL Stuff
▶︎
Expert Level SQL Tutorial
▶︎
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
▶︎
Co-Creator of Haskell: Useless vs Useful Languages, Rust vs C, Functional Programming | Simon Jones
▶︎