Free SQL Resources for beginners!

Spend $0 and earn yourself some SQL knowledge with these sites.

Post Credit - Travis Tang Sir

๐Ÿงต๐Ÿ‘‡
1๏ธโƒฃ ๐™†๐™๐™–๐™ฃ ๐˜ผ๐™˜๐™–๐™™๐™š๐™ข๐™ฎ's Intro to SQL: Querying and Managing Data comes with video lessons and interactive coding exercises.
(lnkd.in/g5y_Pfvf)
2๏ธโƒฃ ๐˜พ๐™ค๐™™๐™š๐™–๐™˜๐™–๐™™๐™š๐™ข๐™ฎ provides a treasure trove of text tutorials for beginners and intermediates alike. (lnkd.in/gZ5_uYjC)
3๏ธโƒฃ ๐™Ž๐™Œ๐™‡๐™•๐™ค๐™ค covers basic to advanced concepts in an interactive coding environment. This is easily my favourite on the list because of its challenging exercises.
(sqlzoo.net)
4๏ธโƒฃ ๐™Ž๐™Œ๐™‡๐˜ฝ๐™ค๐™ก๐™ฉ also provides text tutorials and interactive exercises. Their instructions are easy to follow!
(sqlbolt.com)

โ€ข โ€ข โ€ข

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

Keep Current with Sachin Kumar๐Ÿ‡ฎ๐Ÿ‡ณ

Sachin Kumar๐Ÿ‡ฎ๐Ÿ‡ณ 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 @Sachintukumar

Dec 22
๐Ÿ’กDay -2 on SQL Questions

๐Ÿงต๐Ÿ‘‡
Q2) Assume you are given the tables below about Facebook pages and page likes. Write a query to return the page IDs of all the Facebook pages that don't have any likes. The output should be in ascending order. ( Questions Link is also Provided )
๐Ÿ™ŒThankyou so much Shri @NickSinghTechSir For
Creating Such a Great Platform @DataLemurHQ For
SQL & Data Science Learners

๐Ÿ–๏ธCode Snippet :
Read 4 tweets
Dec 21
๐Ÿ’กSo Today I Start a Series on SQL Question :

๐Ÿ“Œ So Please Share Your Thoughts Guys

๐Ÿงต๐Ÿ‘‡ ( Question Link is also Given )
Q1 ) Given a table of candidates & their skills, you're tasked with finding the candidates best suited for an open Data Science job. You want to find candidates who are proficient in Python Tableau,& PostgreSQL.

Write a query to list the candidates who possess all of the Skills
๐Ÿ”ฅThankyou so much Shri @NickSinghTech Sir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners

๐Ÿ–๏ธCode Snippet :
Read 4 tweets
Dec 12
10 Most Important SQL Common Commands๐Ÿ”ฅ

๐Ÿงต๐Ÿ‘‡
1. SELECT and FROM :
SELECT informs which columns you want to select whereas FROM specifies which table you want to query the data from.

2. DISTINCT
DISTINCT is used to view the unique values in a column.
3. WHERE
WHERE is used to filter rows that match a certain condition.

4. % Wildcard
The % wildcard is used in a LIKE operator to match string patterns.

5. ORDER BY
ORDER BY can be used to sort the result of a query by a particular column either alphabetically or numerically.
Read 9 tweets
Dec 10
๐Ÿ“Data science blogs๐Ÿ’ก

โœ…A curated list of data science blogs

๐Ÿงต๐Ÿ‘‡
๐Ÿ“ŒA Blog From a Human-engineer-being erogol.com (RSS)

๐Ÿ“ŒAakash Japi aakashjapi.com (RSS)

๐Ÿ“ŒAdvanced Analytics & R
advanceddataanalytics.net (RSS)

๐Ÿ“ŒAdventures in Data Land blog.smola.org (RSS)

๐Ÿ“ŒAgile Data Science blog.sense.io (RSS)
๐Ÿ“ŒAhmed El Deeb medium.com/@D33B (RSS)

๐Ÿ“ŒAirbnb Data blog nerds.airbnb.com/data/ (RSS)

๐Ÿ“ŒAlex Castrounis | InnoArchiTech innoarchitech.com (RSS)

๐Ÿ“ŒAlex Perrier alexperrier.github.io (RSS)
Read 16 tweets
Dec 8
๐ŸŽฏ You should know 7 things to become successful in
#dataengineering career ๐Ÿ”ฅ

๐Ÿ“Œ Credit - Shri Ajay Kadiyala ji โœ…

๐Ÿงต๐Ÿ‘‡
Read 9 tweets
Dec 2
๐Ÿ“•#SQL is super important. These are the questions that you will have face in interviews which helps you to ace your sql interviews

Credit - Shri Ajay Kadiyala Sir ๐Ÿ”ฅ

๐Ÿงต๐Ÿ‘‡
Q1. Explain the various types of Joins?
2. Explain Equi join?
3. Explain the Right Outer Join?
4. How do you alter the name of a column?
5. how can you build a stored procedure?
6. Distinguish between MongoDB and MySQL ?
Q7. Compare the 'Having' and 'Where' clauses in detail?
8. What are the differences between COALESCE() and ISNULL()?
9. What is the difference between โ€œStored Procedureโ€ and โ€œFunctionโ€?
10. What is the difference between the โ€œDELETEโ€ and โ€œTRUNCATEโ€ commands?
Read 11 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 on Twitter!

:(