Tweet

@SachinK02316651

This Thread may be Removed Anytime!

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

More from @SachinK02316651

Sachin Kumar🇮🇳

@SachinK02316651

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

Sachin Kumar🇮🇳

@SachinK02316651

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

Sachin Kumar🇮🇳

@SachinK02316651

Dec 8

🎯 You should know 7 things to become successful in
#dataengineering career 🔥

📌 Credit - Shri Ajay Kadiyala ji ✅

🧵👇

1. SQL
lnkd.in/gyqXbVDM

2. Python
lnkd.in/gUSsvKbd

Read 9 tweets

Sachin Kumar🇮🇳

@SachinK02316651

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

Sachin Kumar🇮🇳

@SachinK02316651

Nov 25

🚀 5 interesting #Python Projects with Source Code to start building your #portfolio 👨‍💻

Here are 5 #DataScience and #MachineLearning Projects that you can add to your portfolio :

👇

1. WhatsApp Data Analysis using Python
🌐 lnkd.in/e_CYCWfw

2. Extract Text from any website using Python
🌐 lnkd.in/eRJ34Fk6

3. Extract Text from PDF file using Python
🌐 lnkd.in/ehbbP_Ni

4. Detect Emotion, Sentiment and Trends using AI
🌐 lnkd.in/erbKTKdZ

5. Generate Subtitles for YouTube Video
🌐 lnkd.in/e_hKF-7X

Read 4 tweets

Sachin Kumar🇮🇳

@SachinK02316651

Nov 16

📗 Studying SQL for data analysts👩‍💻

📌Let’s take a look at Studying SQL for data analysts from useful resources collection :
👇

𝟭. 𝗦𝗤𝗟 𝗕𝗼𝗹𝘁
👉 sqlbolt.com

From SELECT * to GROUP BY, SQL Bolt contains lessons and interactive exercises to help you grasp the essentials in SQL. With no SQL Experience, you can get the basics of SQL in just one week.

𝟮. 𝗦𝘁𝗮𝗻𝗳𝗼𝗿𝗱 𝗗𝗕 & 𝗦𝗤𝗟 𝗰𝗼𝘂𝗿𝘀𝗲
👉 lnkd.in/gFEc8ngA

If you want a detailed explanation of SQL queries with a mixture of easy and hard SQL problems, I highly recommend you check out this course

Read 8 tweets

Share this page!

Sachin Kumar🇮🇳

People who liked this thread also liked...

Try unrolling a thread yourself!

More from @SachinK02316651

Sachin Kumar🇮🇳

Sachin Kumar🇮🇳

Sachin Kumar🇮🇳

Sachin Kumar🇮🇳

Sachin Kumar🇮🇳

Sachin Kumar🇮🇳

Did Thread Reader help you today?

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

Send Email!