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)
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
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
๐#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?