Discover and read the best of Twitter Threads about #Database
Most recents (24)
How to enhance paleoscience research, collaboration & application in #GlobalSouth? In the latest @PAGES_IPO Magazine, we share the philosophy, functioning & future of @INQUA-funded #pSESYNTH project, building collaborative approaches & communities.
doi.org/10.22498/pages… (1/n)
doi.org/10.22498/pages… (1/n)
The INQUA-funded multi-year #pSESYNTH project envisions the first multi-disciplinary #Holocene paleo #database through a collective vision for past #SocialEcologicalSystems in the #GlobalSouth, and their future sustainability.
(2/n)
(2/n)
We describe #pSESYNTH, an example of scientific community mobilization & collaboration focused on the #GlobalSouth, i.e. Latin America & the Caribbean, Africa, Asia, & parts of Oceania where researchers have been historically marginalized from international collaborations. (3/n) 
Hello Datafam,
So someone asked me where they can get to practice SQL so I would dropping links to platforms where you can practice SQL
Thread 🧵
So someone asked me where they can get to practice SQL so I would dropping links to platforms where you can practice SQL
Thread 🧵
1) Hackerrank @hackerrank
I have used this platform and I really loved using it. I also love that they reward with badges and stars as you make progress
check it out here: hackerrank.com/domains/sql
I have used this platform and I really loved using it. I also love that they reward with badges and stars as you make progress
check it out here: hackerrank.com/domains/sql
2) DataLemur @DataLemurHQ
I personally love this because they give standard interview questions that cuts across various industries. There are also level such as Easy, Medium and Hard so if you want to prepare for technical interviews, check it out
datalemur.com/sql-interview-…
I personally love this because they give standard interview questions that cuts across various industries. There are also level such as Easy, Medium and Hard so if you want to prepare for technical interviews, check it out
datalemur.com/sql-interview-…
Happy Sunday Everyone,
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
The Level 2 challenge was a murder mystery challenge to find who the killer is and we were to solve the challenge using SQL
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
My submission: drive.google.com/drive/folders/…
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
#Nuked Themsleves: “They will blame #Russia as always”: a sociologist on the growth of the background #radiation in #Khmelnytsky (160 nS) | May 15
-the Russian army #destroyed the #ammunition depot -shells with #DepletedUranium were stored at the facility.
theinteldrop.org/2023/05/15/nuk…
-the Russian army #destroyed the #ammunition depot -shells with #DepletedUranium were stored at the facility.
theinteldrop.org/2023/05/15/nuk…
RADIATION SITUATION TODAY
#Finland's background #radiation normally varies between 0.05 and 0.30 #microsieverts per hour (µSv/h)
CONTACT PERSON:
Tuomas Peltonen / Inspector general
tel. +358 975 988 508
stuk.fi/aiheet/sateily…
- #Loviisa NOW: 0.210 #microSieverts
#Finland's background #radiation normally varies between 0.05 and 0.30 #microsieverts per hour (µSv/h)
CONTACT PERSON:
Tuomas Peltonen / Inspector general
tel. +358 975 988 508
stuk.fi/aiheet/sateily…
- #Loviisa NOW: 0.210 #microSieverts
cc: @ ArthurM40330824
#Gamma radiation in #Khmelnytsky could actually indicate that a #DirtyBomb was stored in the warehouses.
Gamma radiation is characteristic of #enriched #uranium. Is it possible that were making "dirty bombs" at the Khmelnitsky #NPP
#Gamma radiation in #Khmelnytsky could actually indicate that a #DirtyBomb was stored in the warehouses.
Gamma radiation is characteristic of #enriched #uranium. Is it possible that were making "dirty bombs" at the Khmelnitsky #NPP
🎉Today, we’re releasing #Memgraph Lab 2.5.0. 🚀
Memgraph Lab is a visual UI for exploring and managing data stored in the Memgraph database. Check out the new features below and what they enable you to do.
Memgraph Lab is a visual UI for exploring and managing data stored in the Memgraph database. Check out the new features below and what they enable you to do.
🔎 With the new #Memgraph Lab, you can open more than one query execution view and stack them side by side.
This allows you to run different queries in separate sections and compare their execution speeds and results.
This allows you to run different queries in separate sections and compare their execution speeds and results.
🎉 If you have written several queries in the query editor, you can now run a single query by selecting it and pressing the Run Selected button.
You no longer have to comment out all the other queries you don't want to execute.
You no longer have to comment out all the other queries you don't want to execute.
#SQL Cheatsheet #infographic
———————
#Databases #DataScientists #DataScience #DataManagement #DataProfiling #DataLiteracy #DataQuality
———————
#Databases #DataScientists #DataScience #DataManagement #DataProfiling #DataLiteracy #DataQuality
12 Best #SQL Online Course Certificate Programs for #DataScience in 2023 — compiled by @tut_ml
————
#Databases #BigData #DataScientists
mltut.com/best-sql-onlin…
————
#Databases #BigData #DataScientists
mltut.com/best-sql-onlin…
7 Best Advanced #SQL Courses & Training Online You Must Know in 2023 — compiled by @tut_ml
————
#BigData #DataScience #DataScientists #Coding #Database #Analytics
mltut.com/best-advanced-…
————
#BigData #DataScience #DataScientists #Coding #Database #Analytics
mltut.com/best-advanced-…
12 Best FREE #SQL Courses and Certifications Online in 2023 — compiled by @tut_ml
—————
#Databases #DataScience #BigData #Analytics #DataScientists #100DaysOfCode
mltut.com/best-free-sql-…
—————
#Databases #DataScience #BigData #Analytics #DataScientists #100DaysOfCode
mltut.com/best-free-sql-…
#SQL Notes for Professionals: books.goalkicker.com/SQLBook/
[free 166-page PDF download]
———
#Database #DataScience #DataAnalytics #DataScientists #DataProfiling
[free 166-page PDF download]
———
#Database #DataScience #DataAnalytics #DataScientists #DataProfiling
1/6 🔥Prepare to be amazed by Ovidiu Damian - @Ovcd27, Tech Lead at @itheum when it comes to everything #MultiversX related.
He will take the stage as a speaker at the upcoming #SeedCaptain conference.
Learn more about his background and presentation 🧵👇
#MultiversXNFTs
He will take the stage as a speaker at the upcoming #SeedCaptain conference.
Learn more about his background and presentation 🧵👇
#MultiversXNFTs
2/6 🏗He's got it all - from Smart Contracts and User Interfaces to Architecture design.
With a portfolio of tens of applications on #MultiversX already released, he brings a diverse range of skills to the table.
#TechLead #Web3 #Web3Development #UIUXDesigner #MultiversXtech
With a portfolio of tens of applications on #MultiversX already released, he brings a diverse range of skills to the table.
#TechLead #Web3 #Web3Development #UIUXDesigner #MultiversXtech
3/6 📚Bachelor's degree in Computer Engineering and a Master's degree in International Business Management.
✅Google & Coursera certifications, Digital Marketing Fundamentals, Cloud Computing Basics, Structuring Machine Learning Projects, Improving Deep Neural Networks.
✅Google & Coursera certifications, Digital Marketing Fundamentals, Cloud Computing Basics, Structuring Machine Learning Projects, Improving Deep Neural Networks.
💥14 herramientas secretas impulsadas por #RStats para ahorrar tiempo y esfuerzo en tus proyectos de datos (¡No te lo pierdas!):👀
1️⃣ ¡Edita tus datos de forma interactiva (y guarda el código)! 👀
📦 'editData' es un complemento de RStudio para editar un data.frame o un tibble de forma interactiva
🔗 buff.ly/3U5Tgjy
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
📦 'editData' es un complemento de RStudio para editar un data.frame o un tibble de forma interactiva
🔗 buff.ly/3U5Tgjy
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
2️⃣ ¡Crea gráficos #ggplot de forma interactiva!🚀
📦esquisse es otro de mis addins favoritos de #rstudio
✅ exporta el gráfico o recupera el código para reproducir el gráfico
🔗 buff.ly/3mxLHSo
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
📦esquisse es otro de mis addins favoritos de #rstudio
✅ exporta el gráfico o recupera el código para reproducir el gráfico
🔗 buff.ly/3mxLHSo
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
(1/11) Is #Blockchain an enabler for sustainable future? Fasten your seatbelts as we’re all set to embark on a deep topic voyage. 🧵 Read more at:
medium.com/zignaly/llts72…
medium.com/zignaly/llts72…
(2/11) 💻 #Blockchain is a shared #ledger or repository that computer #subnets may access. It is similar to a #database, but it is secure and #decentralized. #Cryptocurrency systems like #Bitcoin use blockchains to keep a secure and decentralized database of transactions. 🔐
(3/11) 💡Blockchain eliminates a #centralized command structure, allowing #data sharing among parties without needing a centralized system or administrator. It is #secure and #data can't be corrupted or destroyed by anyone with access to the main database. #FinancialTechnology
And @PGelsinger takes the stage and immediately confirms that this is the launch of the fourth-generation #Xeon processor known as #SapphireRapids. He’s also emphasizing the #XeonMax brand!
@PGelsinger immediately turns it over to a video featuring @MichaelDell of @DellTech, then the CEO of @InspurSystems, then @AntonioNeri_HPE of @HPE, then @Lenovo
Q17 ) In problem where we need to find player with no of gold medals won by them only for players who won only gold medals.?
📓Code Snippets :
Q16 ) Write an SQL query to report all customers who never order anything.
Return the result table in any order.
Return the result table in any order.
Hey Folks 😃
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
Day 1 -
Day 2 -
Q15) A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department.
--- Write an SQL query to find the employees who are high earners in each of the departments.
Q12) Write a query that outputs the name of each credit card and the difference in issued amount between the month with the most cards issued, and the least cards issued. Order the results according to the biggest difference.
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform
@DataLemurHQ For SQL & Data Science Learners
🖍️Code Snippet :
@DataLemurHQ For SQL & Data Science Learners
🖍️Code Snippet :
Learn SQL projects for Data Analysis and add to your portfolio for free 🥳
Projects for the portfolio are very important. These projects will improve your skills
A thread 🧵👇
Projects for the portfolio are very important. These projects will improve your skills
A thread 🧵👇
1.
2.
Q11) New TikTok users sign up with their emails & each user receives a text confirm to activate their Acc. Assume you r given below tables about email & text
Write query to display the id of the users who didn't confirm on the first day of sign-up but confirmed on the second day
Write query to display the id of the users who didn't confirm on the first day of sign-up but confirmed on the second day
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners
🖍️Code Snippet :
🖍️Code Snippet :
▶️You want to reach an intermediate SQL level inside a week 🔥
💯 I have the recipe for it
Yeah, no kidding. Seriously🫡
Source - Sidharth Kriplani Sir
🧵👇
💯 I have the recipe for it
Yeah, no kidding. Seriously🫡
Source - Sidharth Kriplani Sir
🧵👇
2⃣Day Two:
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)
Day -🔟 on @facebook SQL Questions Series 🚀🎯
& Extremely sorry guys🙏 from last 2 days I am not posted but now onward i will Continue these series 😃🔥
🧵👇
& Extremely sorry guys🙏 from last 2 days I am not posted but now onward i will Continue these series 😃🔥
🧵👇
Q10) Assume you have an events table on app analytics. Write a query to get the app’s click-through rate (CTR %) in 2022. Output the results in percentages rounded to 2 decimal places.
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners
🖍️Code Snippet :
🖍️Code Snippet :
How to consume any Database as a Stream for heavy data processing using JavaScript 🤯🔥
🧵/1
#javascript #nodejs #streams #sql #nosql #tutorial #dataprocessing #database #business #data #strategy #pipeline @nodejs
🧵/1
#javascript #nodejs #streams #sql #nosql #tutorial #dataprocessing #database #business #data #strategy #pipeline @nodejs
The secret for processing anything using JavaScript is to handle data on demand.
Imagine data you wanna migrate data from a SQL database to a NoSQL DB. You would need to apply some business rules, clean up fields, filter data and then output them to the final output.
/2
Imagine data you wanna migrate data from a SQL database to a NoSQL DB. You would need to apply some business rules, clean up fields, filter data and then output them to the final output.
/2
You might know that you can block the Node.js (and the data source you're consuming) if you handle too much data at once in memory
The best practice then is to limit results, send individual data to a stream pipeline, and then ask for more data until you've consumed it all.
/3
The best practice then is to limit results, send individual data to a stream pipeline, and then ask for more data until you've consumed it all.
/3
Hello hello London! 👋🏻 We’re at IET Savoy Place, London for DSS London 2022 by #YugaByteDB. It’s gonna be super interesting tech session starting at 2 pm today! Don’t miss my #Live #Tweets in this #thread! 🤩🧵
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
Yes, the setup is going on for the grand presentation of the #Tech #Track. The master is teaching the student here! #JustKidding Say hi to Julie Wise and Dave Roberts from #YugaByteDB! 👋🏻
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
We’ve got our Social Media / Content Director @rachel_pescador from #YugaByteDB here, who’s busy at work and got some cool #swag! 🤩
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
@Yugabyte #DSS22 #DistributedSQL #PraveenScience
Another new idea for #PenetrationTesting and #Bug-hunting:
Tester:
Enhance the force of #vulnerabilities by doing things like
I discovered a free #URL that leads somewhere else.
Put this in my report and move on ?
Tester:
Enhance the force of #vulnerabilities by doing things like
I discovered a free #URL that leads somewhere else.
Put this in my report and move on ?
To the contrary, changing the #payload allowed me to transform it into a reflected #XSS #vulnerability. Is this the final question?
Obviously not if I have any hope of carrying on.
Obviously not if I have any hope of carrying on.
🔥Top 12 free Handbooks about Data Science / AI :
✅"Python Data Science Handbook"
tanthiamhuat.files.wordpress.com/2018/04/python…
✅"Learning Pandas"
linkedin.com/posts/stevenou…
✅"MACHINE LEARNING YEARNING"
lnkd.in/gXdYjzi
✅"Feature Engineering for Machine Learning"
d2wvfoqc9gyqzf.cloudfront.net/content/upload…
✅"Python Data Science Handbook"
tanthiamhuat.files.wordpress.com/2018/04/python…
✅"Learning Pandas"
linkedin.com/posts/stevenou…
✅"MACHINE LEARNING YEARNING"
lnkd.in/gXdYjzi
✅"Feature Engineering for Machine Learning"
d2wvfoqc9gyqzf.cloudfront.net/content/upload…
✅"The Hundred-Page Machine Learning Book"
lnkd.in/gNb22Qh
✅ "Introduction to Statistical Machine Learning"
lnkd.in/guFgpXD
✅"Statistics for Data Science"
lnkd.in/gBudWsA
✅"Natural Language Processing With Python"
lnkd.in/gCFKZAs
#Data #ind
lnkd.in/gNb22Qh
✅ "Introduction to Statistical Machine Learning"
lnkd.in/guFgpXD
✅"Statistics for Data Science"
lnkd.in/gBudWsA
✅"Natural Language Processing With Python"
lnkd.in/gCFKZAs
#Data #ind
✅"The Deep Learning Textbook"
lnkd.in/gfBv4h5
✅Deep learning Masterpiece by Andrew Ng
lnkd.in/gU98mhj
++A collection of Free Programing Books :
lnkd.in/gPPYPyD
By - Haithem Hermessi
#DataAnalytics #dataScientist #dataengineering #MachineLearning
lnkd.in/gfBv4h5
✅Deep learning Masterpiece by Andrew Ng
lnkd.in/gU98mhj
++A collection of Free Programing Books :
lnkd.in/gPPYPyD
By - Haithem Hermessi
#DataAnalytics #dataScientist #dataengineering #MachineLearning
