Learn Advanced SQL

@sundaskhalidd

74.6K followers · usually 2.2K views a post

Views

20.1K

Likes

1.7K

Comments

14

Shares

92

SoundTikTok sound · original sound - sundaskhalidd

Promoted product

—

Why it worked

The video provides valuable, actionable information on a sought-after skill (advanced SQL) in a clear, structured format. The creator's credibility is established by mentioning her experience at major tech companies, and the content is presented in a native, non-salesy way that aligns with typical TikTok educational content.

Summary

The creator outlines five essential advanced SQL skills for data professionals: Windows functions, CTEs, complex JOINs, performance optimization, and advanced SQL logic. She explains how each skill is crucial for tasks like ranking data, simplifying queries, combining datasets, optimizing performance, and building complex reports.

Structure

1Introduction to advanced SQL skills
2Windows Functions
3CTEs (Common Table Expressions)
4Complex JOINs
5Performance Optimization (Indexes, Execution Plans)
6Advanced SQL Logic (Case When, Subqueries, Conditional Aggregation)
7Conclusion and call to action

Original caption

This is exactly how I'd master advanced SQL if I had to start over 👇🏻 ㅤ I still remember how overwhelming these advanced skills felt at first. ㅤ If I had to do it all over again, this is the exact order I'd learn them in. ㅤ I wish someone had told me that sooner. ㅤ Which one are you starting with? Let me know in the comments. ㅤ #sql #dataanalytics #datascience #dataengineering #techcareers

More from @sundaskhalidd

Product placement

The video discusses advanced SQL skills, listing five specific areas: Windows Functions, CTEs, Complex JOINs, Performance Optimization, and Advanced SQL Logic. The creator also shows images of herself working at Google and Amazon, implying her experience in these roles.

Call to action

Let me know what I should cover next.

On-screen text

Learn Advanced SQL 5 skills you need to learn SQL If you want SQL skills you need to master I spent about Data Scientist, a Data Analyst, Data Engineer and these are the advanced SQL skills I used Number one is Windows Functions ROW_NUMBER RANK LAG SUM OVER LEAD you rank customers calculate running totals and compare current versus previous rows without losing the details answers are some of the most common business questions you will face as a Data Scientist No. 2 is CTEs break complex queries into smaller readable your SQL becomes easier to debug Maintain Delegate work it off to your teammates when it's time No. 3 complex JOINS real business multiple tables so mastering joins helps you combine data set correctly without creating duplicates or missing records I use regardless of which SQL No. 4 is Performance Optimization and this becomes SQL skill when you're writing advanced SQL so you hundred learn indexes Execution Plans and how to reduce unnecessary scans performance tuning and optimization of your SQL hard requirement when you work with big No. 5 is Advanced SQL Logic this includes case CASE WHEN Correlated Subqueries Conditional Aggregation when correlated, subqueries and conditional aggregation which lets you build reports, Reports Segment Customers segments customers and calculated KPIs directly in SQL this is again you will get Business Product Stakeholders product or your stakeholders and of course this because you let me know

Transcript

If you want to learn advanced SQL skills, here are five skills you need to master. I spent about 12 years working as a data scientist, data analyst, data engineer at these big companies and these are the advanced SQL skills I used every single day. Number one is Windows functions. For example, functions like row_number, rank, lag, lead and sum_over let you rank customers, calculate running totals and compare current versus previous rows without losing the details. These answers are some of the most common business questions you will face as a data analyst, data scientist. Number two is CTEs. CTEs let you break complex queries into smaller, readable steps. Your SQL becomes easier to debug, maintain and hand off to your teammates when it's time. Number three, complex JOINs. Real business data lives across multiple tables, so mastering JOINs helps you combine data set correctly without creating duplicates or missing records. This is one of the skills I use regardless of which SQL I wrote. Number four is performance optimization, and this becomes a core advanced SQL skill when you're writing advanced SQL. So you 100% need to learn indexes, execution plans and how to reduce unnecessary scans. Performance tuning and optimization of your SQL is a hard requirement when you work with big data. Number five is advanced SQL logic. This includes case when, correlated subqueries and conditional aggregation, which lets you build reports, segment customers and calculated KPIs directly in SQL. This is again one of the core assets that you get from business or product or your stakeholders over and over again. And of course, you already knew this because you follow me. Let me know what I should cover next.