# Most recents (24)

#Day5 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble

Find the links to the questions here
1. leetcode.com/problems/the-n…
2. leetcode.com/problems/prima…

#SQL #DATAANALYSIS #Interviews #lowcode
Let's break them down:
1. Intuition
The query aims to retrieve information about managers in the Employees table, including their IDs, names, the number of employees reporting to them, and the average age of their reports.
The solution involves using a self join. Since we were told that a manager is also an employee, we will join the table to itself, where the employee_id field is equal reports_to field. On this premise, we aggregate the number of employees who report directly to the manager,
Let's break down each question
1. Logic: Show the classes, where the number of student is more than 5. The word "At least" tells us something, we have to include 5 as part of our filtering condition, hence >=5
2. This looks pretty straight forward. For each user, we want to....
..return the number followers, hence the need to use the Group BY clause. This clause allows us to aggregate data against the unique categorical/qualitative values in a field.
3. The given SQL query finds the maximum value (num) from the "mynumbers" table that appears only once.
Let's break down each code
1. The ending part to the question is where the major conditional logic lies. We were told to return the needed columns, and price for the first year of every product sold. Since we do not have distinct column showing min years for each product,
We have to create that with a subquery in the Where clause. We are concerned about the first year of every product sold, so we aggregate the min years for each product. After doing that, we tell SQL to return the prices of products, the year, and qty when the product was first..
You can unlock the full potential of your workflow with the power of NoCode and AI tools.

These 9 tools will surely help you to save time (I bet):
{1} @ScribeHow

It used to take a lot of time to write documents and how-to tutorials, but not anymore!

Auto-generate step-by-step guides just by clicking record.

Save your team 20+ hours/month vs. video and text tutorials.

300,000+ users

🔗 getscribe.how/chrome
{2} Otter .ai

Voice Meeting Notes & Real-time Transcription

Uses artificial intelligence to empower users with real-time transcription meeting notes that are shareable, searchable, accessible, and secure.

🔗 otter.ai
My 2022 Year in Review and look ahead to 2023…

An unusual year of ups + downs that took my research agenda to unexpected places.

Yet the result was invaluable + ended up taking my work to useful new places.

A longish 🧵 on #cio #cloud #digitaltransformation #FutureOfWork. 1/x
First up is my detailed analysis titled “The #Cloud Reaches an Inflection Point for the #CIO in 2022.” It remains very pertinent reading.

Written as the cloud industry reached an early maturity point, it highlighted a top hot issue: Complexity

constellationr.com/blog-news/clou…

2/x
Then I took a deep dive into #decentralization, perhaps one of the most significant generational revolutions of our era:

What is #Web3 and Why It Matters

dionhinchcliffe.com/2022/01/11/wha…

Regardless of what happens to #crypto, the underlying tech esp. #blockchain, is an inflection.

3/x
Low code/No code can do magic.

Use them to hack your web development process ultimately!

{1} @locofy_ai

Convert Figma or Adobe XD designs into production-ready frontend code and extend your code with data & logic to create fully functional apps.

Export to:

➜ HTML/CSS

➜ React/React Native

➜ Gatsby

➜ Next.js

Vue, Angular (soon)

🔗 locofy.ai
{2} Tally

Free Online Form Builder

Tally is the simplest way to create free forms & surveys.

Create any form in seconds, without knowing how to code, and for free.

🔗 tally.so

Do things 3 times faster with these fantastic Free Tools for web developers.

Can save you tens of hours every month. (believe me)
{1} @appwrite

Excellent open-source Firebase alternative.

It's a secure backend server for web, mobile & flutter developers.

Out-of-the-box support for:

✅ Authentication and Users (including social logins)
✅ Database
✅ Storage
✅ Functions

👉 appwrite.io
{2} Retool

Retool is the fast way to build internal tools.

Drag-and-drop building blocks and connect them to your databases and APIs to build your own tools, instantly.

🔗 retool.com
10 Web sites web developers may feel illegal to know.

But trust me, they can save you tens of hours every month.🧵👇
{1} @appwrite

Excellent open-source Firebase alternative.

It's a secure backend server for web, mobile & flutter developers.

Out-of-the-box support for:

✅ Authentication and Users (including social logins)
✅ Database
✅ Storage
✅ Functions

👉 appwrite.io
{2} Magic Eraser

Use AI to remove unwanted things from images in seconds

👉 magiceraser.io
Can’t code or design?

No problem.

Here are 10 FREE apps/websites that will save or make you HUNDREDS of USD dollars and transform your business.

Fun fact: I actually help to build one of them 🔥

Check them out! 🧵
1. Use Canva.com to make graphics for FREE. No design skills are required.

- Use a drag-and-drop editor for easy customizations
- Over 250,000 free templates to choose from.
- Over 100+ design types
- 5GB of free cloud storage.
2. Use wordpress.com to make a FREE website. No coding skills are required. ( I work here 😀). WordPress powers over 145 million websites.

- Dozens of free themes
- 1GB of storage
- Free SSL certificate
Nuevo HILO  🔉

"Porque el marketing sin optimizar tu tiempo no es productivo, confía en el #nocode "

💜 Haz RT para guardar este hilo
💜 Like para agradecernos el hilo

🟣 CEOs: @pab_sharingaway Toni y Lidón Llansola

¿Quieres aprender #nocode ? Pues en su academia podrás hacerlo paso a paso.

De aquí han salido grandes profesionales del #nocode y #lowcode

Ever wondered what it takes to build an intelligent Q/A assistant? 🤔

@OpenAI #gpt3 and a few hours is all you need!

🤯 Yes, you heard it right!

🕹 Built a #javascript wizard using @streamlit to answer all your queries like a human expert!

#nlproc #AI #lowcode
@OpenAI @streamlit Gone are the days when you had to spend hours on @StackOverflow for resolving code-related queries!

🪄 Javascript wizard gives you precise answers to all your #JS related questions by leveraging #gpt3's latest code-davinci model that understands your queries just like humans!
@OpenAI @streamlit @StackOverflow I have made the application code #OpenSource so you can just clone the repo and build #gpt3 powered #AI applications for your usecase!

👨‍💻 GitHub Repo - github.com/Shubhamsaboo/j…

#NLP #lowcode #nlproc
How to make your weekend productive? 🤔

🕹 Build an end-to-end neural search engine in #Python using @JinaAI_

🤯 Yes, you heard it right!

@JinaAI_'s DocArray library and a few hours is all you need to build a complete search solution!

#nlproc #OpenSource #AI
@JinaAI_ Neural search lets you improve search relevance by understanding the intent and going beyond the conventional keyword-based search!

Some common applications are:

👉 Q/A chatbots
👉 Voice assistants like #alexa #siri
👉 Recommendation system by @netflix
Check out this blog to build a semantic search engine for textual data.

It will walk you through the steps to build your first neural search application in no time!

#python #artificialintelligence #nlproc #OpenSource #datascience #lowcode

shubhamsaboo111.medium.com/build-neural-t…
Following up on my last tweet on the masterclass by @5aitec @0xPolygon on ‘Metaverse 101’, hosted by amazing people @adityamohanty_ @abhayjani4 at @0xTPH

If you are new to the metaverse world like me, dive into my thread🧵

Here are my learnings, hope it helps🙏🏼

#Metaverse
The session started with defining the ‘Metaverse’
and
how a user being just a ‘Spectator’ in Web2 will transform into an ‘Active Participant’ in Web3/Metaverse.
The ‘7 Layers of Metaverse’ gives a detail idea of what it takes to build a Metaverse, few of them being :-

Infrastructure - GPU, Cloud, 5G-6G

Decentralisation - Blockchain

Experience - Games, ESports,shopping etc.

#blockchain #5G #cloud #esports #neural
We just rolled out ToolJet 1.0 🚀
We are also live on ProductHunt, really appreciated it if you can take a few minutes to review ToolJet - producthunt.com/posts/tooljet-2
Thanks, everyone for making this happen in such a short time!

#opensource #producthunt #lowcode #nocode #devtool
What's new:
+ Started with 7 integrations and now we have 20+ datasource integrations
+ Started with 15 widgets and now there are 35+ UI widgets
+ Responsive canvas
+ Redesigned the application builder and dashboard for better usability
#buildinpublic #automation #startups

At the request of @alistairswilson, here is my present #OpenSource Tech Stack!

Many of these are #Nocode/#Lowcode tools that make your life a lot easier.

So grab a cup of coffee & settle into:

Top 20 Solutions in My Tech Stack
🧵 👇
1. n8n (#Automation)
What it is: Connects different systems together and automates the tasks.

How I use it: How don't I use it?! Automated emails. Hardware Endpoint. API creation. System monitor.

Website: n8n.io
What it is: Safely stores & remembers your passwords so you don't have to.

How I use it: I have over 2000 username & password pairs. This remembers the very long passwords I create!

Website: bitwarden.com
Amazon just announced a new #nocode/#lowcode tool at re:Invent conference.

It’s called AWS Amplify Studio.

In their own words, it is: “a visual development environment that offers frontend developers new features to accelerate UI development with minimal coding”
And this will totally blow your mind. 👇

The tool accepts a #Figma file and converts it into #React components library that you can then pull into your app.

So, not a no-code tool and definitely not for beginners.
But they are clearly bullish on the low-code/no-code approach to development.

They are positioning it as a “happy medium” between drag-n-drop development and the ability to customize.
“HashiCorp: Past, Present, Future”

In this article, our guest contributor @shawnxusy takes you to explore the tech & biz model of HashiCorp \$HCP, one of the most prominent open source startups to date.

@shawnxusy 1/ Like pianola that consistently automates piano playing, HashiCorp \$HCP builds consistency via automation in cloud infra space.

Ex. Terraform automates away repetitive steps in provisioning a new EC2 server instance on AWS thru template, w/o replacing infra engineers #lowcode
@shawnxusy 2/ Origin story:

Growing up, co-founder @mitchellh wrote bots that auto-perform repetitive steps in games.

In 2009, his frustration of spending hours switching computing contexts to simulate diff customer environments prompted HashiCorp’s 1st open source product, Vagrant
Be part of a community and grow faster!

Learning together with other like-minded no-coders will help you grow faster. But where to start?

These 11 communities might be interesting for you! Thread below 👇

Build anything without writing code. The #1 ranked platform for no-code education and community. Become a founder without being technical!

@nocodefounders

The #1 community for non-technical founders, makers, and entrepreneurs. Join 10,000+ founders building businesses with #NoCode

nocodefounders.com
No-Code AI or ML in your projects? I did an hour of research, and those are the 9 best tools & APIs for integrating into your projects.

Happy predicting 🤖

#lowcode #nocode #machinelearning #datascience

🧵👇
👉 @clarifai

✅ computer vision, natural language processing, and automated machine learning
👉 @levityai

✅ flexible ai model creation in a visual drag and drop editor
✅ computer vision, text processing
What key 8 difference between permissioned #blockchain #setcoin & public blockchain #bitcoin?

#investing #Finance #finanstwitter #cryptotrading #cryptocurrencies #cryptocurrency #cryptoart #defi #altcoin #CryptoNews #ethereum #Dodgers
1. #ESG Compatible with limited energy usage to deploy and run ledgers and nodes.
2. #Scalability: much faster validation, and transaction execution;
3. Generating income from real sector #assets;
Next 👇

#fintech #banking #cbdc #CryptoTownEU #DigitalCurrency #NFTgaming
4. Advanced #identity system for #digital #assets owners #validation;
5. Facilitating #green & #cycling economy transition
6. Diversification between income of green buildings, #renewables, #smartcities, #agtech, vertical farming, technology sector private equity assets
Next 👇
3 steps
How to start your idea (#startup) from scratch
No needs:
- #hiring #engineers (product developers)
- #UI/#UX #designer
- #PM
- #Marketing #teams
- #angel or #vc #investors

Needs:
- increasing curiosity
- #skills growth
- intentions for great

Step #1
Use #nocode or #lowcode solutions to build your #product from scratch (needs \$15-30 for domains and nocode platform)

You don't need funds or hire engineers/designers to build your product just grow your skillset.
Build on @bubble by single person 👇
I love supporting smaller accounts on Twitter, but sometimes you gotta learn from the best.

Here are the 20 no-coders with the most followers 👇

Co-founder/CEO @webflow
2/ Ben Tossell @bentossell with 33,768 followers.

no-code education | Founder makerpad.co (acq by @zapier) | Investor in no-code/low-code tools
How I built my full functional personal website in less than a day using low-code. 🚀

Spend less, Ship Faster.

A thread which you will love 🧵👇🏻

#nocode #lowcode
Tech stack used 🏆:

1. Frontend - React app using @divjoy
3. Email using @EmailJS_com
4. Chatbot using @wotnot_io
5. Analytics using @splitbee
✅ Frontend

- Build the complete UI using components provided by @divjoy to save time

- Created multiple pages using the visual editor from Divjoy

- Exported the code which was a ZIP file of React app
How I created a Mini Bank App using low-code in less than a week 🏦 💰

#nocode #lowcode #100DaysOfNoCode #BuildingInPublic
✨ Overview

Built a Web application that mimics the behavior of the bank like show balance, transaction history, FAQs, Block cards. It's a mini Bank 🏦

Stack Used

@airtable as Backend
@UiBakery for Frontend
@MailerLite for Email Integration
@zapier for workflow
✨ Frontend

(1/2)

Used UiBakery components via drag and drop visual builder, modified some styling according to our theme, and hooked REST API via built-in Data Connection.