📕#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?
11. What is difference between “Clustered Index” and “Non Clustered Index”?
12. What is the difference between “Primary Key” and “Unique Key”?
13. What is the difference between a “Local Temporary Table” and “Global Temporary Table”?
14. What is the difference between primary key and unique constraints?
15. What are the differences between DDL, DML and DCL in SQL?
16. What is a view in SQL? How to create view?
17. What is a Trigger?
8. What is the difference between Trigger and Stored Procedure?
19. What are indexes?
20. What are Primary Keys and Foreign Keys?
21. What are wildcards used in database for Pattern Matching?
22. What is Union, minus and Interact commands?
23. What is RDBMS?
24. What is OLTP?
25. What is Aggregate Functions?
26. What is the difference between UNION and UNION ALL?
27. What is a foreign key, and what is it used for?
✅🧵Scenario Based Questions--👇

❗ SQL Query to find second highest salary of Employee?
❗ SQL Query to find Max Salary from each department?
❗ Write SQL Query to display current date?
❗ Write an SQL Query to check whether date passed to Query is date of given format or not?
❗ Write a SQL Query to print the name of distinct employee whose DOB is between 01/01/1960 to 31/12/1975?
❗ Write an SQL Query to find employee whose Salary is equal or greater than 10000?
❗ Write an SQL Query to find name of employee whose name Start with ‘M’?
#DataScience
❗ Find the 3rd MAX salary in the emp table?
❗ Suppose there is annual salary information provided by emp table.
❗How to fetch monthly salary of each and every employee?
❗Display the list of employees who have joined the company before 30th June 90 or after 31st dec 90?
#SQL
📌Follow @SachinK02316651 For More Update
✅SQL
✅EXCEL
✅PYTHON
✅Tweet on Current Affairs 🌎

#python #excel #currentaffairs

• • •

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 @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
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
Oct 9
🔥Top 12 free Handbooks about Data Science / AI :

✅"Python Data Science Handbook"
tanthiamhuat.files.wordpress.com/2018/04/python…
✅"Learning Pandas"
linkedin.com/posts/stevenou…

✅"MACHINE LEARNING YEARNING"
lnkd.in/gXdYjzi

✅"Feature Engineering for Machine Learning"
d2wvfoqc9gyqzf.cloudfront.net/content/upload…
✅"The Hundred-Page Machine Learning Book"
lnkd.in/gNb22Qh

✅ "Introduction to Statistical Machine Learning"
lnkd.in/guFgpXD

✅"Statistics for Data Science"
lnkd.in/gBudWsA

✅"Natural Language Processing With Python"
lnkd.in/gCFKZAs

#Data #ind
✅"The Deep Learning Textbook"
lnkd.in/gfBv4h5

✅Deep learning Masterpiece by Andrew Ng
lnkd.in/gU98mhj

++A collection of Free Programing Books :
lnkd.in/gPPYPyD
By - Haithem Hermessi
#DataAnalytics #dataScientist #dataengineering #MachineLearning
Read 4 tweets
Aug 13
Top free #DataScience resources :

1. CS109 Data Science
cs109.github.io/2015/pages/vid…

2. Data Science Essentials
edx.org/course/data-sc…

3. Learning From Data from California Institute of Technology
work.caltech.edu/telecourse
4. Mathematics for Machine Learning by University of California, Berkeley
gwthomas.github.io/docs/math4ml.p…

5. Foundations of Data Science by Avrim Blum, John Hopcroft, and Ravindran Kannan
cs.cornell.edu/jeh/book.pdf?f…

6. Python Data Science Handbook
jakevdp.github.io/PythonDataScie… #Data #india
7. CS 221 ― Artificial Intelligence
stanford.edu/~shervine/teac…

8. Ten Lectures and Forty-Two Open Problems in the Mathematics of Data Science
ocw.mit.edu/courses/mathem…

9. Python for Data Analysis by Boston University
bu.edu/tech/files/201…
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 on Twitter!

:(