Channel Avatar

The Magic of SQL @UCWeOtlakw8g01MrR8U4yYtg@youtube.com

28K subscribers - no pronouns :c

Hi, I'm Chris Saxon, part of Gerald Venzl's Oracle Developer

Videos Shorts Posts Playlists
Split rows into equal groups with NTILE #sql #sqltips Number rows in SQL with ROW_NUMBER, DENSE_RANK, & RANK #SQL #sqltips Get values from the previous or next rows #sql #sqltips Define calculated columns #sqltips Group rows into N minute intervals #oraclesql Dynamic data validation #sqltips #oraclesql Create enums in Oracle SQL #sqltips #oraclesql Custom rules for sorting & showing values in SQL Linking domains to columns #SQLtips #oraclesql Case insensitive search in Oracle #SQL #sqltips Describe common values with usecase domains #sql #oraclesql Faster PL/SQL in SQL #SQL #sqlperformance Merry SQLmas! #sql Outer joins ON vs WHERE clause #SQL #sqltips Combining tables UNION vs UNION ALL #sqltips #sqlforbeginners Avoid type conversion errors #sqltips #oraclesql Check data type conversions #sqltips #oraclesql Change the next value for identity columns #sqltips #oraclesql Autoincrementing columns with identities & sequences #sqltips #oraclesql ORDER BY & NULL #sqltips #sqlforbeginners Group by != order by #sqltips #sqlforbeginners Index only scans #sqltips #sqlperformance Indexes and sorting #sqltips #sqlperformance Query CSV files with inline external tables #SQL #oraclesql Multicolumn foreign keys and null #SQL #SQLtips Index column order #SQL #SQLtips #sqlperformance Function based indexes #SQL #SQLtips #sqlperformance Unique constraint vs index #SQL #SQLtips Create foreign keys #SQL #SQLtips Estimate the size of an index before creating it Defining mandatory database columns How to create check constraints How to create primary keys Free guess the SQL statement quizzes NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds #shorts Inner joins vs IN/EXISTS - SQL in 60 seconds #shorts IN & EXISTS Semijoins - SQL in 60 seconds #shorts Window functions ORDER BY PRECEDING & FOLLOWING - SQL in 60 seconds #shorts Window functions ORDER BY - SQL in 60 seconds #shorts Window functions PARTITION BY - SQL in 60 seconds #shorts CROSS and OUTER APPLY joins - SQL in 60 seconds #shorts ON vs USING for joins - SQL in 60 seconds #shorts Cross joins - SQL in 60 seconds #shorts Partitioned outer join - SQL in 60 seconds #shorts Outer join filtering - SQL in 60 seconds #shorts Outer joins - SQL in 60 seconds #shorts Inner joins - SQL in 60 seconds #shorts