正在加载视频...

视频加载失败

返回首页

WHERE 1 = 1 in SQL Explained! (And why you should use it) #dataanalyst #dataanalysis #sqltips #sql #sqlsyntax

imelijahbutler's profile picture

Elijah Butler

198,500 subscribers

227,800 次观看 • 3 个月前 •via TikTok

教育科学技术#dataanalyst#dataanalysis#sqltips#sql#sqlsyntax
LIVE

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

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

相关视频

Learn SQL can be easy! #learnsql #data #dataanalysis #datascience #dataanalyst #sqltips #learnontiktok
3:00

Learn SQL can be easy! #learnsql #data #dataanalysis #datascience #dataanalyst #sqltips #learnontiktok

mavenanalytics

916,600 次观看 • 4 年前

Everything you need to know about SQL for complete beginners! #clearsquare #dataanalyst #dataanalysis #sql #coding
2:12

Everything you need to know about SQL for complete beginners! #clearsquare #dataanalyst #dataanalysis #sql #coding

ClearSquare

960,500 次观看 • 1 年前

How to use the RANK() window function in SQL 🌟 #dataanalyst #dataanalytics #dataanalysis #data #analyst #sql #rank #windowfunction #windowfunctions #sqlcode #coding #programming #techjobs #breakintotech #techtok #wfh #workfromhome #wfhjobs #remotejobs #remotework
1:57

How to use the RANK() window function in SQL 🌟 #dataanalyst #dataanalytics #dataanalysis #data #analyst #sql #rank #windowfunction #windowfunctions #sqlcode #coding #programming #techjobs #breakintotech #techtok #wfh #workfromhome #wfhjobs #remotejobs #remotework

Mary | Data Analyst

51,800 次观看 • 1 年前

How to do a simple JOIN in SQL #dataanalyst #dataanalysis #dataanalytics #data #analyst #sql #joins #sqljoin #sqljoins #sqlcode #coding #programming #sequel #breakintotech #techjob #techjobs #techtok #datatok
2:31

How to do a simple JOIN in SQL #dataanalyst #dataanalysis #dataanalytics #data #analyst #sql #joins #sqljoin #sqljoins #sqlcode #coding #programming #sequel #breakintotech #techjob #techjobs #techtok #datatok

Mary | Data Analyst

80,600 次观看 • 2 年前

Seriously don’t apply #dataanalyst #dataanalysis #dataanalytics #data #analyst #techjob #techjobs #techlayoffs #sql #powerbi #tableau #excel #datascience #datascientist #wfh #workfromhome #wfhjobs #remotejob #remotejobs #remotework
1:51

Seriously don’t apply #dataanalyst #dataanalysis #dataanalytics #data #analyst #techjob #techjobs #techlayoffs #sql #powerbi #tableau #excel #datascience #datascientist #wfh #workfromhome #wfhjobs #remotejob #remotejobs #remotework

Mary | Data Analyst

738,400 次观看 • 2 年前

How I would become a data analyst in 2026? this is complete roadmap with step by step guide in 4 minutes. Watch till the end 📈 What role should I cover next? ##dataanalyst##datatok##dataanalysis##sql##python
4:31

How I would become a data analyst in 2026? this is complete roadmap with step by step guide in 4 minutes. Watch till the end 📈 What role should I cover next? ##dataanalyst##datatok##dataanalysis##sql##python

Sundas

331,000 次观看 • 1 年前

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips
0:26

Formatting is not an advanced SQL skill, but all advanced users have good SQL formatting 😉 If you have a SQL test in your data analyst interview, here are two formatting tricks that show you’ve actually used SQL on the job 👇 1️⃣ WHERE 1=1 Add this to your where clause and you can comment out and swap different conditions without breaking your query. Analysts do this every day and it is a small but real time saver when you are working with SQL queries constantly. 2️⃣ Comma before the column name Put each column on its own line with the comma in front. It makes it easy to remove or comment out columns you do not need without breaking anything. The way you format your code is important! If you do these two things, it is clear you have experience debugging SQL code. Want more? I made a free Data Analyst Interview Cheat Sheet with the exact SQL and Excel skills they test you on in interviews. Link in bio 🤓 ⚠️ Note: This applies to data analyst, marketing analyst, and business analyst roles. If you are interviewing for an engineering role, YMMV #sql #dataanalyst #interviewtips

brooke | learn coding + ai

139,100 次观看 • 5 个月前

IYour login form can be hacked with 1 line 💉👇 This is SQL Injection — the #1 backend attack that still owns companies in 2025. ' OR '1'='1 That's it. That's all it takes to dump your entire database if you do this: ❌ query = "SELECT * FROM users WHERE email = '" + input + "'" ✅ FIX IT LIKE THIS: Use prepared statements / parameterized queries. Always. I explained the full attack + how to prevent it in this reel. Save this before your next interview. Share with that friend who still concatenates SQL strings.
0:53

IYour login form can be hacked with 1 line 💉👇 This is SQL Injection — the #1 backend attack that still owns companies in 2025. ' OR '1'='1 That's it. That's all it takes to dump your entire database if you do this: ❌ query = "SELECT * FROM users WHERE email = '" + input + "'" ✅ FIX IT LIKE THIS: Use prepared statements / parameterized queries. Always. I explained the full attack + how to prevent it in this reel. Save this before your next interview. Share with that friend who still concatenates SQL strings.

codedevguy

19,300 次观看 • 3 个月前

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
1:32

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 次观看 • 1 年前

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?
0:40

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

Google for Developers

11,376 次观看 • 8 个月前

"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
0:27

"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,578 次观看 • 10 个月前

FREE DATA ANALYTICS CERTIFICATION BOOTCAMP #dataanalyst #dataanalytics #dataanalysis #techjobs #breakintotech
0:43

FREE DATA ANALYTICS CERTIFICATION BOOTCAMP #dataanalyst #dataanalytics #dataanalysis #techjobs #breakintotech

Elijah Butler

41,600 次观看 • 1 个月前

(includes partner resources) the links for the resources are listed here for easy access! the link is also in my bio! resources: learn SQL (beginner to advanced) in 4 hours: SQL toolkit for data engineering: SQL murder mystery: SQL scavenger hunt: ##learnsql##sql##learncoding##yay##softwareengineer
0:45

(includes partner resources) the links for the resources are listed here for easy access! the link is also in my bio! resources: learn SQL (beginner to advanced) in 4 hours: SQL toolkit for data engineering: SQL murder mystery: SQL scavenger hunt: ##learnsql##sql##learncoding##yay##softwareengineer

eggintech

288,600 次观看 • 9 个月前

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
5:48

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results

Alex Xu

23,200 次观看 • 2 个月前

Cleaning your data in Power Query—the basics 📝 #dataanalyst #dataanalysis #dataanalytics #powerbi #clearsquare
2:13

Cleaning your data in Power Query—the basics 📝 #dataanalyst #dataanalysis #dataanalytics #powerbi #clearsquare

ClearSquare

41,200 次观看 • 9 个月前

Установка серверов sql+1С (полное руководство) #server #sql #1С #sqlserver #сисадмин
6:06

Установка серверов sql+1С (полное руководство) #server #sql #1С #sqlserver #сисадмин

Yurik_switch

148,100 次观看 • 1 个月前

How hackers use SQL Injection to compromise a website
13:03

How hackers use SQL Injection to compromise a website

𝐇𝐚𝐦𝐳𝐚 | Networking Guy

18,935 次观看 • 1 个月前