PostgreSQL Practice Daily @PostgreSQLDaily
Joined December 2022-
Tweets99
-
Followers14
-
Following28
-
Likes4
Answer to Question 42: ROLLBACK #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 42: What SQL command is used for reverting changes performed by a transaction? #sql #sqlpracticedaily #postgresql #database #dataanalyst
Python Question; Can you answer this question about Python classes? What is the output of this code, and why?🤔
Answer to Question 41: select revenue_stream,month,sum(revenue) from orders join revenue using(order_id) group by revenue_stream,month #sql #dataanalyst #PostgreSQL
Question 41: There are two tables, orders and revenue, which share a common column, order_id. Within the orders table, there is also revenue source and month columns. Write a query to find the total amount of revenue by revenue stream by month #sql #sqlpracticedaily #dataanalyst
Answer to Question 40: Parent Table #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 40: What is the name of the table the foreign key references is called? #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 39: UNION ALL Operator #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 39: What operator allows the user to stack together 2 separate queries, only if the output queries have the same amount of columns & similar data types. This operator also allows duplicates. #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 38: with cte1 as ( select salary, percent_rank() over (order by salary asc) as perc_rank from table) select salary from cte1 where perc_rank >= 0.95 #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 38: Write a query to find the top 5% salaries in a table. #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 37: CASE function #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 37: What function can be used to create a pivot table without using the pivot function? #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 36: ~ symbol #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 36: What is the symbol used for SIMILAR TO in a query? #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 35: 1. using the concat() function 2. using || Example: 'hello'||' '||'world' ---> 'hello world' #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 35: What are the two ways to concatenate data? #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 34: ALTER TABLE table_name ALTER COLUMN column_name TYPE int using column_name::int #sql #sqlpracticedaily #postgresql #database #dataanalyst
Question 34: Write a query to change a column data type from varchar to int. #sql #sqlpracticedaily #postgresql #database #dataanalyst
Answer to Question 33: SELECT column1 FROM table1 WHERE column1 IS NULL #sql #sqlpracticedaily #postgresql #database #dataanalyst
Shiv Iyer @thewebscaledba
1K Followers 4K Following Founder CEO @WebScaleDBA #MinervaDB @ChistaDATA #Entrepreneur #Investor #Startup #OpenSource #OLTP #OLAP #MySQL #PostgreSQL #ClickHouse #MariaDB #AzureSQL #DBA
Hakan Güray Şenel @hgsenel
34 Followers 571 Following Emekli öğretim üyesi, Elektrik-Elektronik-Bilgisayar Mühendisi, DevOps, PostgreSQL, Kubernetes, Konteyner teknolojileri uzmanı
Aditya Shrest @P0x80
22 Followers 221 Following
Chevine Miller @chevine2015
55 Followers 430 Following
__RA__ @agbojoraphael
370 Followers 719 Following
Good Gold Data @GoodGoldData
12 Followers 23 Following
gabe burchett @Gabeburchett
186 Followers 323 Following
shadesNFT @shadezNFT
30 Followers 151 Following shades NFT on Etherium Blockchain. One single NFT. One drop per day. Hue of NFT is directly correlated to Eth price at moment of minting.
gabe burchett @Gabeburchett
186 Followers 323 Following
__RA__ @agbojoraphael
370 Followers 719 Following
Good Gold Data @GoodGoldData
12 Followers 23 Following
Ergest Xheblati @ergestx
8K Followers 986 Following Data + Business | Author: Minimum Viable SQL Patterns | Newsletter: Data Patterns (see links below)
SQL Daily @sqldaily
25K Followers 4 Following Daily Oracle SQL tips from the Oracle Developer Advocates for SQL
MavenAnalytics @MavenBI
6K Followers 16 Following Launch your career in Data. Learn Excel, SQL, Power BI, Tableau, Python, & Machine Learning.
David Miller 🧮 @thedavescience
11K Followers 274 Following Former data science tweeter turned cleaning business lurker.
Sharyph @sharyph_
78K Followers 512 Following 📝Tech Writer | 👨💻Digital Creator | Growth Strategist | AI Content Marketer
Growth To Wealth | An.. @GrowthToWealth
14K Followers 361 Following I teach you how to break into the tech industry even if you’re not an expert
Brian Graves @NewPrediction
14K Followers 483 Following Data professional w/ 15+ years exp. I write about SQL, Tableau, Excel, & Python to help data analysts earn more in their careers, side hustles, and freelancing.
dushyant gadewal @dushyantgadewal
6K Followers 6K Following #BlackDemon India, #NextStruggle Blog, Tech Wizard, #Indian 🇮🇳, Gaming, AI, #Entrepreneur, NITRourkela Alumni, Biker, .
YK aka CS Dojo 📺�.. @ykdojo
143K Followers 497 Following - Senior AI Developer Advocate - CS Dojo on YT (1.9M+ subs) - Keynote speaking: https://t.co/eIGhFFMtMo
Nikki Siapno @NikkiSiapno
150K Followers 312 Following Engineering Manager at @Canva | Founder of Level Up Coding | — A big thank you to our partner @getpostman who keeps our content free to the community
Chris Staudinger @ChrisStaud
133K Followers 304 Following Founder of Level Up Coding | Educational software engineering content — A big thank you to our partner @getpostman who keeps our content free to the community
Medium @Medium
2.1M Followers 407 Following Everyone has a story to tell; find ours on https://t.co/3cf4z3Kf7e, Instagram/Threads (@medium), LinkedIn and https://t.co/zVH9KVi7kZ
PRESENTA @PresentaSw
229 Followers 14 Following Image Automation and Personalization. Figma to Dynamic Images. WP Plugin. https://t.co/x1NF8vX1Zb Follow to get a taste! 😉
Chimereze🚀 @ChimeXdata
6K Followers 148 Following BI Analyst • Quiet but very cool IRL • Guitarist 🎸
FrankFelixAI @FrankFelixAI
3K Followers 417 Following Data Scientist and ML Engineer || AWS Certified Solutions Architect || MLSA || 2x Hackathon Winner🏅|| ML Engineering @QuCoon_
Gabby @thenaijacarguy
41K Followers 937 Following Data Analyst - Session Lead @Udacity | | Register for the 5-week Data Analytics bootcamp starting April here: https://t.co/xVtFbeAYVA
Malcom Okonkwo #DATAF.. @malcom_okonkwo
9K Followers 562 Following Data Analyst 👨💻📊📉 Winner of DataFestAfrica 2022 (Team Nova) A chemical engineering graduate(B.eng), techie, a Chelsea fan, a lover of good things 💰🤑
𝗛𝗢𝗞𝗔𝗚�.. @Xionne_
7K Followers 7K Following @LFC ❤️ • Data 📊 • Audiophile × Melophile 🎧 • Polyjamorous 🎵 • Fit 🥷🏽 • @the_safecorner 🎙️ • Dog lover 🐶 • Anime 🇯🇵 • Hablo Español poco 🇪🇸
Alexa Ighodaro @Alexa_Ighodaro
30K Followers 496 Following Woman in Tech 👩🏽💻 | Data Engineer | Living for the audience of ONE
Data Community Africa @DataFestAfrica
24K Followers 19 Following The Number one community for Data practitioners and Enthusiasts in Africa - Subscribe - https://t.co/vQBq9FrueZ #DataFestAfrica2023 #DFA2023
Analytical Aakriti | .. @Aakriti_Sarma
72K Followers 139 Following Open for DevRel roles! Data Nerd | Technical Writer | SQL Obsessed | Python Possessed | Let's dig into data the simple, effective and no nonsense way 📊
Ezekiel @ezekiel_aleke
70K Followers 147 Following Data Analyst | Author | Tutor | Mentor | Best-selling Author of DATA ANALYSIS MADE EASY. Dm for Promotion/Collaboration. https://t.co/rMOX0NhISL
Alex Freberg @Alex_TheAnalyst
68K Followers 37 Following Alex The Analyst Official Twitter Account | YT Alex The Analyst | IG @Alex_The_Analyst | YouTube’s #1 Data Analyst Channel (don’t fact check that)Here’s a cool advanced SQL challenge. Refactor the query below. What would you tackle first and why? - Turn the nested subqueries into CTEs - Remove the repeated innermost subquery - Remove the unnecessary joins on lines 25 and 60 To see my answer check out the link below
The EPL is back!!. I carried out an analysis of the EPL from the 2000/01 season to 2021/2022 using python and created this dashboard with @canva I went on to build ML models to see how well teams in the EPL 2020/21 would perform in the 2021/22 season.
Trends for United States
You might like
