Channel Title: The Magic of SQL Channel Description: Hi, I'm Chris Saxon, part of Gerald Venzl's Oracle Developer Advocate team. It's our job to help you get the best out of Oracle technologies and (hopefully) have fun while doing so ;) Here we celebrate the Magic of SQL. We'll show how you can use it to solve problems and perform SQL "magic". These skills will help you build better, faster applications using Oracle Database. Subscribe to learn SQL, improve your skills and understand how Oracle Database works. Take SQL quizzes and classes at Oracle Dev Gym https://devgym.oracle.com Ask me your SQL questions on Ask TOM https://asktom.oracle.com Read SQL blog posts at https://blogs.oracle.com/sql Reach me on Twitter https://twitter.com/ChrisRSaxon My personal site https://www.chrissaxon.co.uk/ <video> Autoincrementing columns with identities & sequences #sqltips #oraclesql Description: Learn how to create autoincrementing columns in Oracle Database with identity columns or sequences -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Function based indexes #SQL #SQLtips #sqlperformance Description: Functions in the WHERE clause limit the optimizer's ability to use indexes You can create function-based indexes to overcome this But it's better to rewrite the expression! -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Multicolumn foreign keys and null #SQL #SQLtips Description: Take care with optional multicolumn foreign keys If you insert into null any column, values for other columns aren't checked = you can have values in the child not in the parent! --- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Outer joins ON vs WHERE clause #SQL #sqltips Description: Take care when filtering the joined table in outer joins Get it wrong and you make the query into an inner join! -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> ORDER BY & NULL #sqltips #sqlforbeginners Description: Control whether NULL appears at the top or bottom of sorted results with ORDER BY ... NULLS { FIRST | LAST } This overrides the default sorting behaviour ASC = NULLS LAST DESC = NULLS FIRST -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Indexes and sorting #sqltips #sqlperformance Description: B-Tree indexes are ordered data structures - see how creating them means the database can avoid sorting operations -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Check data type conversions #sqltips #oraclesql Description: Verify whether you can convert values to another data type with VALIDATE_CONVERSION -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Bluesky: https://bsky.app/profile/chrisrsaxon.bsky.social Daily SQL Twitter tips: https://bsky.app/profile/sqldaily.bsky.social https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Group by != order by #sqltips #sqlforbeginners Description: GROUP BY is not guaranteed to return sorted results Add ORDER BY to ensure the rows are ordered -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Change the next value for identity columns #sqltips #oraclesql Description: Set the nextvalue for identity columns to the maxvalue + 1 -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Avoid type conversion errors #sqltips #oraclesql Description: Oracle Database 12.2 added the DEFAULT ... ON CONVERSION ERROR clause to the TO_* functions. This enables you to return a value or null instead of getting an exception when you convert invalid values. -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Query CSV files with inline external tables #SQL #oraclesql Description: Read files on the DB server without creating an external table using the EXTERNAL clause -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Index only scans #sqltips #sqlperformance Description: If your query only accesses indexed columns, the optimizer only needs to read the index, not the table! -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Merry SQLmas! #sql Description: Merry SQLmas! Wishing you all the best over the festive season Hope you have a fantastic time We'll be back in 2025 with more #SQL tips In the meantime, enjoy this SQLmas tree! -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Index column order #SQL #SQLtips #sqlperformance Description: The order of columns in a composite index affects when the optimizer can use it in SQL queries See how the plans changed based on which columns are in the where & select clauses. -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video> <video> Combining tables UNION vs UNION ALL #sqltips #sqlforbeginners Description: UNION & UNION ALL combine rows from two tables into one dataset UNION all deduplicates UNION ALL doesn't -- Need help with SQL? Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/ =========================== The Magic of SQL with Chris Saxon </video>

Contacts and Links

Description

Hi, I'm Chris Saxon, part of Gerald Venzl's Oracle Developer Advocate team. It's our job to help you get the best out of Oracle technologies and (hopefully) have fun while doing so ;)

Here we celebrate the Magic of SQL. We'll show how you can use it to solve problems and perform SQL "magic". These skills will help you build better, faster applications using Oracle Database.

Subscribe to learn SQL, improve your skills and understand how Oracle Database works.

Take SQL quizzes and classes at Oracle Dev Gym https://devgym.oracle.com
Ask me your SQL questions on Ask TOM https://asktom.oracle.com
Read SQL blog posts at https://blogs.oracle.com/sql
Reach me on Twitter https://twitter.com/ChrisRSaxon
My personal site https://www.chrissaxon.co.uk/

Videos from channel