SQL Learning Resources Thread
As a Beginner learning Data Analysis, Data Science + SQL, it is always good to connect the dots through projects and use cases.
In this growing thread, I will first share some resources with possible SQL projects to test your skill
#SQLOnBirdApp
It will be good to start with a foundational course. there are lots of resources in this space so I will list them:

Foundation
1. Udacity Free SQL Course: udacity.com/course/sql-for…
2. W3Schools. Don't joke with this site. highly valuable and resourceful. You also have the opportunity of trying out the queries without installing any software on your laptop.
w3schools.com/sql/
3. SQLCourse: This is another amazing site with easy-to-read instructions just like W3Schools and an online SQL interpreter.
sqlcourse.com
4. SQLBolt
Still on the fundamentals. there are lots of resources out there and SQLBolt is one of them

sqlbolt.com
All Levels
1. Hackerrank:
I love the hackerrank approach to learning SQL. You learn by solving challenges and acrrued points to move across levels.

A 30 minutes on hackerrank everyday for 60 days will make a significant impact
hackerrank.com/domains/sql
before I move on from Hackerrank, companies today access your SQL skill by sending you tasks on hackerrank. so, the faster you've gone learning and practicing there, the better you are to write efficient queries
2. Leetcode: This is yet another superb SQL learning resource. select different tasks to solve.

leetcode.com/problemset/dat…

very similar to hackerrank, some organizations also test your SQL skill with Leetcode assessment
3. Select Star SQL:

This is an interactive book that aims to be the best place on the internet for learning SQL. It is free of charge, free of ads, and doesn't require registration or downloads.

selectstarsql.com
I will also recommend Danny Ma's 8 Weeks SQL Challenge as a good resource:

8weeksqlchallenge.com

• • •

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

Keep Current with Olanrewaju Oyinbooke

Olanrewaju Oyinbooke 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 @TheOyinbooke

Feb 17
How to Get the Best from the Global Power Platform Bootcamp 2022, Lagos Nigeria.
Tips can be applied to other areas of your life
Global Power Platform Bootcamp is an annual event that takes place in over 70 cities across the globe where people come together to learn about Power Platform Tools; Power BI, Power Apps, Power Automate, and Power Virtual Agent.
You can register here bit.ly/GPPB2022LAGOS
We will be holding the Lagos edition as a Physical event at the University of Lagos Main Auditorium.

You self check the venue now.. opoor 🔥
Read 10 tweets
Jan 23
Learning SQL can be very interesting if you are just watching video but nay, watching video or reading SQL Blog doesn't take you anywhere.
Structure your learning and practice in this form
1. Basic SQL: select, filter using where, like, in, etc...
#SQLOnBirdApp
2. SQL Joins: focus on learning how to combine data from multiple tables.
I will recommend you learn Set theory and try to solve set questions with 3 subjects involved. It really break down the whole logic and possible relationships.

#SQLOnBirdApp
3. SQL Aggregation: Learn how to aggregate data using functions like SUM, AVG, COUNT, CASE, HAVING, and DATE.

#SQLOnBirdApp
Read 11 tweets
Jan 22
Google Data Analytics Professional Certificate
Open this THREAD if interested
About Google Data Analytics Professional Certificate.
This was released alongside other course by Google on Coursera in 2021 with over 571k students already.
The Certificate Course has 8 Modules which are courses and takes approximately 6 months to complete at 10hours/week
You will need to subscribe to Coursera or seek for Financial Aid to be able to take the courses and earn a Certificate.
The courses are listed below
1. Foundations: Data, Data, Everywhere
coursera.org/learn/foundati…
This is the first course. It has 5 Weeks Learning contents
Read 12 tweets
Dec 24, 2021
Let's talk about Adventureworks Database.
This database is popular among data enthusiasts as it is a one of the several free dataset out there to learn with.

In this thread, I will enlighten you on the business behind the database to help you better understand it.
I will put...
.. I will share links to help you learn more.
AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database.
It is a database for a fictitious multinational company called Adventure Works Cycles.
They are into the manufacturing of ..
... and selling of metal and composite bicycles to North American, European and Asian commercial markets.
HQ in Bothell, Washington with 290 employees, with several regional sales teams are located throughout their market base.
They acquired a manufacturing plant in Mexico in ..
Read 8 tweets
Dec 22, 2021
Let's get this right, in the 4th Industrial Revolution which we are in, not everyone can be a Data Scientists, Analytics Engineer, or even a Data Analyst, but everyone must be digital literate to benefit from its numerous opportunities.

Let's see what it takes to be digitally ..
.. literate.
Simply put, digital literacy is the ability for every individual to leverage on the existing and modern technologies for improved productivity at work and in their personal lives.
This means you need to know how to use productivity & collaborative tools efficiently
Learning Microsoft Power Platform will naturally get you to be digitally literate.
For example, you get to know how to use the following apps MS Teams, OneDrive, SharePoint, Outlook, Power Automate, Power Apps, MS Forms etc.
You get to build solutions that will expose you ...
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!

:(