Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Omoalhaja Profile picture
@omoalhajaabiola
Aug 28, 2023 • 1 tweets • 1 min read • Read on X
Top 50 SQL queries during Interviews


Image
Image
Image
Image

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Omoalhaja

Omoalhaja Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @omoalhajaabiola

Omoalhaja Profile picture
May 2
HOW TO LAND YOUR FIRST WHALES CLIENT ON TUESDAY

If you are hoping for a complicated, jazzy, “cutting edge” formula for attracting high ticket clients in the next 5 days…

… I’m afraid you’ll be sorely disappointed with what you’re about to read

Because it is simple. Simple to do. A 4-year old babe can do this. Follow this
This simple formula for client getting requires zero cost.  You don’t need a website or Facebook page or a portfolio.

If you can copy and paste a few emails, you could potentially get clients using this method. But don’t be turned off by its simplicity. It’s just 3 steps. Like most things in life, it works because it is simple.
Lastly, I must warn you of what is guaranteed to happen when you finish reading this short report.

There will be a moment of excitement where you say, “I can totally do this!” (which you can). Following that your mind will start looking for reasons not to do it. Specifically, fear will attempt to take hold of you and give you 100 reasons why this won’t work for you in particular
Read 11 tweets
Omoalhaja Profile picture
Apr 15
How to Land your dream role using LinkedIn

(Tried and tested)
Go to your LinkedIn app, tap the search bar and type Founder AND “We are hiring”.

This prompt combines two powerful LinkedIn Boolean search

- Founder: tells LinkedIn to return profiles of people with Founder in their title

- AND: this is a powerful Boolean search. It simply tells LinkedIn to combine Founder with anything that follows

- “We are hiring”: noticed how I wrapped this with double quotations? It means only returns profiles with “we are hiring”. It’s different from we are hiring (without double quotations).

Check the attached screenshotImage
Before you continue, don’t forget to register on if you are looking for remote roles in the UK, USA, and Canada

And you can monetize your social media presence through

In the screenshot, I already filtered my result by location. In this case, I selected the US ( I actually recommend countries like Estonia, Norway, KSA, and Australia). Click enter and you have profiles of founders that are currently hiring

Now this is where it gets more interestingfeedcoyote.com
influenzit.com
Read 4 tweets
Omoalhaja Profile picture
Mar 13
If you are seeing this tweet congratulations, as it's time to understand @Upwork algorithms

Course Title: Understanding Upwork's algorithm and ranking your profile

I'll try to make this as simple as possible. Kindly retweet, so others can learn.
If you have been struggling with landing clients, scaling your freelance business or rank your profile on upwork, this thread is for you

The first thing to understand is how the platform works. Fortunately, @Upwork has done the hard work for you. Understanding how upwork
connects talents and opportunities is important to start and scale your freelance career.

Upwork has (what I think is the best explanation) a video on this on their YouTube channel

Check it here
Read 8 tweets
Omoalhaja Profile picture
Feb 9
Complete roadmap for Mobile app and User testing (including free learning resources)
1. Understand the Basics: Start by learning the fundamentals of software testing, including different testing types, testing methodologies, and testing levels.

2. Learn Mobile App Basics: Familiarize yourself with mobile app development concepts, platforms (iOS, Android), and popular development frameworks.

3. Study Testing Tools: Explore various testing tools specific to mobile app testing, such as Appium, XCTest, Espresso, and UI Automator.

4. Learn Usability Testing Principles: Understand the principles of usability testing, including user-centered design, user personas, and usability metrics.

5. Explore Usability Testing Techniques: Dive into different usability testing techniques like user interviews, surveys, heuristic evaluation, and think-aloud protocol.

6. Practice with Real Apps: Start practicing mobile app testing on real-world applications. You can begin with simple apps and gradually move to more complex ones.

7. Learn Test Automation: Gain knowledge of test automation frameworks for mobile apps, such as Selenium, Calabash, and Robot Framework.

8. Experiment with Usability Testing Tools: Experiment with usability testing tools like UsabilityHub, UserTesting, and Optimal Workshop to conduct remote usability tests.

9. Stay Updated: Keep yourself updated with the latest trends, tools, and technologies in mobile app testing and usability testing by following blogs, forums, and industry experts.

Learning resources 👇👇
Mobile App Testing:
Fundamentals:

- Google Mobile Testing Guide: (Android-specific, but covers general principles)

- Appium Documentation: (Open-source framework for automating mobile app testing)

Free Tools:

- MonkeyTalk: (Visual scripting tool for automating basic tests)

- Kobiton: (Free plan for limited manual and automated testing)

- Firebase Test Lab: (Limited free tier for running tests on real devices)

- DevTools for Mobile Browsers: (Inspect and debug web views within apps)softwaretestinghelp.com/android-app-te…
appium.io
amazon.com/Adventures-Mak…
kobiton.com
firebase.google.com/docs/test-lab
developer.chrome.com/docs/devtools/…
Read 6 tweets
Omoalhaja Profile picture
Feb 6
Do this for the next 10 days to land your first clients

(Short thread even if you don’t have a laptop)
FIRST STEP

Choose 5 niches you want to focus on. I have posted about 100 niches to choose from. These are some of the niches if you missed it:

- gutter cleaning
- junk removal
- interior decoration
- pest removal
- HVAC

Check my channel for the complete list of 100 niches to choose from
STEP 2

Watch my IG prospecting video. This is where I show you a simple hack about how to get the contact details of small business owners. Download the video here

drive.google.com/file/d/1RJeRUh…
Read 6 tweets
Omoalhaja Profile picture
Jan 30
How to Land your dream role using LinkedIn

(Tried and tested)
Go to your LinkedIn app, tap the search bar and type Founder AND “We are hiring”.

This prompt combines two powerful LinkedIn Boolean search

- Founder: tells LinkedIn to return profiles of people with Founder in their title

- AND: this is a powerful Boolean search. It simply tells LinkedIn to combine Founder with anything that follows

- “We are hiring”: noticed how I wrapped this with double quotations? It means only returns profiles with “we are hiring”. It’s different from we are hiring (without double quotations).

Check the attached screenshotImage
In the screenshot, I already filtered my result by location. In this case, I selected the US ( I actually recommend countries like Estonia, Norway, KSA, and Australia). Click enter and you have profiles of founders that are currently hiring

Now this is where it gets more interesting

We want to reach out to them but most times, LinkedIn doesn’t allow sending connection request to more than 100 connections per day (except you are on their premium plan).

Do this instead 👇👇
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

Send Email!

:(