Top Tweets for #sqlshortreads
Learn the use cases of common SQL character functions https://t.co/83NUIW4km9.
#SQL #SQLShortReads #DataAnalytics #DataEngineering
SQL's FULL JOIN leaves many new learners thinking, "when will I possibly need this?"
Learn more about the FULL JOIN and its use cases at https://t.co/28ebeXfCQx
#SQL #SQLShortReads #DataAnalytics #DataEngineering
Need to capture hierarchal relationships or data existing across multiple rows in a single table within a single row using SQL? This is a job for the SELF JOIN.
Learn through real-world examples at https://t.co/6GlmWvAVdk
#SQL #SQLShortReads #DataAnalytics #DataEngineering
Over the past two years or so, I have been quietly working on https://t.co/OS2rO5Bk6w. I have finally published the blog and SQL learning portal this evening.
I look forward to further developing SQL Short Reads and hearing from its readers.
#SQL #SQLSHORTREADS
I hope you find this helpful!
Follow me for more on SQL and data visualization.β
π
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 39
#SQL Realistic Practice Question
The link below can be used to view the image in better resolution and provides the ability to copy/paste the code.
https://t.co/rbujlJTqIN
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 32
Today I came across a post on LinkedIn where the user was having trouble understanding #SQLβs PARTITION BY clause, specifically, when used in analytical functions. So...I provided an example.π§π
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 30
Need Tableauβs Custom SQL feature to make use of a #SQL common table expression (CTE)? Methods differ depending on the database connector youβre using with your #Tableau workbook.π§΅
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 29
Refactoring your #SQL code? Use SET operators to ensure your newly refactored code returns the same data as the old code and vice-versa.
Example. π§π
Image 1: Original Task
Image 2: Result set check.
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 26
Realistic #SQL Practice Question
See image for question.
I've solved my hypothetical problem using multiple approaches. How would you solve it?π§π
#SQLShortReads #Data #DataScience #DataAnalytics #DataFam
SQL Short Reads 21
In #python, random.choice() can be used to return a randomly chosen value from a sequence. Using #SQL, you can achieve similar results using DECODE in conjunction with DBMS.RANDOM.VALUE().
ππ§
#SQLShortReads #Analytics #DataScience #DataAnalytics #DataFam
SQL Short Reads 20
You can solve many problems with fundamental #SQL concepts.
Letβs look at an example that relies on knowledge of subqueries and CASE statements to conditionally apply a salary increase. π
1/
#SQLShortReads #Analytics #DataScience #DataAnalytics #DataFam
SQL Short Reads 19
Need to sort your data to in a custom way other than typical ways of A-Z, least to greatest, etc.?
Using #SQLβs ORDER BY clause in conjunction with a CASE statement could be your solution. ππ§
#SQLShortReads #Analytics #DataScience #DataAnalytics #DataFam
SQL Short Reads 16
One of my favorite #SQL functions is LISTAGG. This function makes it possible to concatenate values found across several rows within a single row, seamlessly.
Letβs look at an example.ππ§΅
#SQLShortReads #Analytics #DataScience #DataAnalytics #datafam
1/
Letβs look a coding example that tackles our hypothetical scenario's task.π
An explanation follows.
#SQLShortReads #Analytics #DataScience #DataAnalytics #DataFam
5/
I hope you find this helpful!
Follow me for more tips on SQL and data visualization.β
8/
#SQLShortReads #Analytics #DataScience #DataAnalytics #DataFam
Last Seen Hashtags on Sotwe
ζη¬γγδΈη·γ«
Seen from United States
incestofamilia
Seen from United States
traditionalAfricanprint
Seen from United States
minichat()********filter:native_video
Seen from Mexico
γΎγ€ζ―γ΅γγ³δΈιη
Seen from United States
Cute femboy
Seen from United Kingdom
倩主ζ倧ι±ε€§ζεΊεΊ
Seen from United States
γͺγ³
Seen from Japan
ηγγγ£γ¦γγ¨
Seen from United States
minichat
Seen from United States
Most Popular Users
Elon Musk 
@elonmusk
241.7M followers
Barack Obama
@barackobama
119M followers
Cristiano Ronaldo
@cristiano
114.6M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107.2M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.4M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90.1M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.3M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.3M followers
CNN
@cnn
61.8M followers
X
@x
60.7M followers