正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

A road map to mastering #SQL

J.A Olaoye

16,347 subscribers

27,027 次观看 • 9 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

Beaver 🦁

86,519 次观看 • 8 个月前

SQLFlow - a great tool to visualize SQL queries. #technology #sql #data #programming

SQLFlow - a great tool to visualize SQL queries. #technology #sql #data #programming

Dr Milan Milanović

255,785 次观看 • 2 年前

Road map to transform your body

Road map to transform your body

HolisticHealthHQ

94,855 次观看 • 7 个月前

They removed a road from a 1941 map. You gotta hear this.

They removed a road from a 1941 map. You gotta hear this.

Joe Rogan Podcast News

155,835 次观看 • 5 个月前

Built a spatial SQL explorer for my GIS students this week. Drop a GeoJSON, practice writing queries, see instant results on a map + linked table. All in-browser, nothing to install. Powered by DuckDB WASM + MapLibre. Try it out:

Built a spatial SQL explorer for my GIS students this week. Drop a GeoJSON, practice writing queries, see instant results on a map + linked table. All in-browser, nothing to install. Powered by DuckDB WASM + MapLibre. Try it out:

Kyle Walker

21,088 次观看 • 6 个月前

Omega did us Justice on this one Road map to #LegendInGold (🎥 BigEyeUG )

Omega did us Justice on this one Road map to #LegendInGold (🎥 BigEyeUG )

JOSE CHAMELEONE

34,824 次观看 • 2 年前

She nails it! Fellas, you wanna land that keeper, she is giving you that road map to a woman's heart.

She nails it! Fellas, you wanna land that keeper, she is giving you that road map to a woman's heart.

Chuckling Charlie

81,103 次观看 • 6 个月前

Introducing my SQL Agent: How to automate SQL with AI. Today I'll share how to make a SQL AI Agent that can automatically connect to databases, understand the tables and schema, and write and execute high-quality SQL queries. I'll guide you through setting up the SQL Agent, creating dozens of SQL queries, and returning the data from those queries. This AI is a huge help!! Table of Contents: 00:00 Introduction 01:30 How to Get The AI Data Science Agents 03:23 AI Tips Newsletter: Get The Code 04:00 Project Setup 06:30 Setting Up Your First SQL Agent 11:00 Running SQL Queries with the SQL Agent 14:25 Next Steps, Project Roadmap, & AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code by Joining my Python AI/ML Tips Newsletter: P.S. - Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, February 12th, I'm sharing one of my best AI Projects: SQL-Writing Business Intelligence Team Register here (570+ registered):

Introducing my SQL Agent: How to automate SQL with AI. Today I'll share how to make a SQL AI Agent that can automatically connect to databases, understand the tables and schema, and write and execute high-quality SQL queries. I'll guide you through setting up the SQL Agent, creating dozens of SQL queries, and returning the data from those queries. This AI is a huge help!! Table of Contents: 00:00 Introduction 01:30 How to Get The AI Data Science Agents 03:23 AI Tips Newsletter: Get The Code 04:00 Project Setup 06:30 Setting Up Your First SQL Agent 11:00 Running SQL Queries with the SQL Agent 14:25 Next Steps, Project Roadmap, & AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code by Joining my Python AI/ML Tips Newsletter: P.S. - Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, February 12th, I'm sharing one of my best AI Projects: SQL-Writing Business Intelligence Team Register here (570+ registered):

Matt Dancho (Business Science)

77,527 次观看 • 1 年前

Gain the Map of Alacrity and take the road less travelled to make all the difference.

Gain the Map of Alacrity and take the road less travelled to make all the difference.

Old School RuneScape

94,323 次观看 • 5 个月前

Sudhanshu Einstein BJP ka Road map explain karte hue…

Sudhanshu Einstein BJP ka Road map explain karte hue…

Arun Arora

24,171 次观看 • 7 个月前

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

Zach Wilson

79,681 次观看 • 1 年前

SQL-in-JS formatting 😍 This is possible thanks to prettier-plugin-embed by Sec-ant (Ze-Zheng Wu), prettier-plugin-sql by JounQin, sql-formatter by Rene Saarsoo Setup Guide:

SQL-in-JS formatting 😍 This is possible thanks to prettier-plugin-embed by Sec-ant (Ze-Zheng Wu), prettier-plugin-sql by JounQin, sql-formatter by Rene Saarsoo Setup Guide:

Karl Horky

45,068 次观看 • 2 年前

Fortnite have announced their 2026 FNCS Road Map - Going back to duos - Mid Season LAN - LAN back to Europe

Fortnite have announced their 2026 FNCS Road Map - Going back to duos - Mid Season LAN - LAN back to Europe

Jake Lucky

83,483 次观看 • 1 年前

A simple explanation of CASE expressions in SQL 🚨SQL Essentials for Data Analysis is now available. Link in Bio.

A simple explanation of CASE expressions in SQL 🚨SQL Essentials for Data Analysis is now available. Link in Bio.

Benjamin Bennett Alexander

19,772 次观看 • 8 个月前

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL

It's launch week . 5 days 5 launches Day 1: SQL Server Data Connector Now you can connect your SQL Server to Julius in just a few clicks and instantly explore your data. Track adoption, analyze performance, and access KPIs all without writing a single line of SQL

rahul

48,216 次观看 • 10 个月前

A free 30-minute guide to mastering Claude Code:

A free 30-minute guide to mastering Claude Code:

MIT CSAIL

21,469 次观看 • 3 个月前

Introducing Bird SQL, a Twitter search interface that is powered by Perplexity’s structured search engine. It uses OpenAI Codex to translate natural language into SQL, giving everyone the ability to navigate large datasets like Twitter.

Introducing Bird SQL, a Twitter search interface that is powered by Perplexity’s structured search engine. It uses OpenAI Codex to translate natural language into SQL, giving everyone the ability to navigate large datasets like Twitter.

Perplexity

3,589,871 次观看 • 3 年前

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

Zach Wilson

34,452 次观看 • 3 个月前