SQL Interview Questions & Tips 📝

Some important SQL Interview Questions
1. What is Data Integrity in SQL?
2. How to Identify Primary and Foreign Key in SQL?
3. What is Normalization in SQL?
4. What are the types of joins in SQL?
5. What is Projection in SQL?
6. WHat is Selections in SQL?
7. What are the types of SQL?
8. What is the Difference between Delete, Drop and Truncate?
9. What is DQL?
10. What is TCL?
11. What is DDL?
12. What is DML?
13. What is DCL?
14. What are Sub queries?
15. What are special operators in SQL?
16. What are logical operators in SQL?
17. What are conditional/relational operators in SQL?
18. What is wild card search
19. How to do Sorting?
20. Explain group by?
21. When having a clause can come in the picture?

My Insta ID: https://instagram.com/_iammkt
Join this channel to get access to perks:
https://www.youtube.com/channel/UCKliIabx-RsHYTqjOiYegSg/join

Like, share and subscribe to the channel.
API Testing Playlist
https://www.youtube.com/watch?v=lMliQAutHDQ&list=PLQ7x7oTdExNLTqXnPPSfnT2zm45hTh_Bv

Core Java Playlist
https://www.youtube.com/watch?v=-P8XuT9NLTI&list=PLQ7x7oTdExNIFYqnAKiZ3GL_l_HuEW3US

This calling statement in Java or this() video
https://www.youtube.com/watch?v=fyzOz3m0sfU

Constructor Overloading in Java video
https://www.youtube.com/watch?v=tnHufHX3GXM

Constructor in Java video
https://www.youtube.com/watch?v=jlPCtEw-OzA

Static and Non Static Variables in Java video
https://www.youtube.com/watch?v=Wk6dlzNFCrs

How to Create an Object in Java & Handing non Static method video
https://www.youtube.com/watch?v=nrUKJAOXfgU

Multiple static methods inside a single Class | How to deal it?
https://www.youtube.com/watch?v=nx1iidySXdU

Methods in Java | What exactly is public static void main(String[] args)
https://www.youtube.com/watch?v=4X-mGh97wYk

Types of Variables in Java | Local,Global & Final Variables
https://www.youtube.com/watch?v=ZldncvxC-x0

Variable and Datatype in Java
https://www.youtube.com/watch?v=6N57XglKpiA

Easy way to run a program in Java | First program in Java
https://www.youtube.com/watch?v=e7f7Gq7Tu2E

Class and Object in java
https://www.youtube.com/watch?v=BHk5Wj28Q5w

50 Keywords in Java
https://www.youtube.com/watch?v=uuPgtntkX04

Tokens in Java
https://www.youtube.com/watch?v=SKQe42Tdatk

How Java internally works?| Compilation & Interpretation
https://www.youtube.com/watch?v=Xy9n1yaOI3I

Introduction to Java | History of Java |Features of Java
https://www.youtube.com/watch?v=-P8XuT9NLTI
Derived model in software development life cycle video link
https://www.youtube.com/watch?v=kHn-qpkloBs

Prototype model in software development life cycle video link
https://www.youtube.com/watch?v=30ln8QUGfBM

Spiral model in software development life cycle video link
https://www.youtube.com/watch?v=yt1IXzIlJDY

Verification and Validation in software development life cycle video
https://www.youtube.com/watch?v=SbfCln1cZBo

Hybrid model in software development life cycle video video
https://www.youtube.com/watch?v=KrrcwoE-nC8

Waterfall model in software development video link
https://www.youtube.com/watch?v=5M0wC_i4x1c

Software development life cycle video link
https://www.youtube.com/watch?v=QxoP26bCCcg


What is manual testing, it's advantages and disadvantages video link
https://www.youtube.com/watch?v=QnTSwUGQsso

What is Software testing video link
https://www.youtube.com/watch?v=DKXkyzBV5Hw

I work in the IT industry as a Senior Software QA Engineer in Bangalore, India and I have worked on mobile applications, web applications, and API testing.
The main reason behind this channel is to educate people about software testing so that it will helpful for them to choose the right career and also to prepare for their interviews.

Adding my blog link
http://softwaretestingbymkt.blogspot.in

Adding my personal mail Id:
mkumartiwari1710@gmail.com

Adding my Quora profile link here:
https://www.quora.com/profile/Manish-Kumar-Tiwari-11

Adding my Twitter account here,
(@MANISH171094): https://twitter.com/MANISH171094
or
(@softwaretesti16): https://twitter.com/softwaretesti16
Facebook Page:
https://www.facebook.com/stbymkt

Join us on Telegram today,
SoftwaretestingbyMKT
For the latest update on software jobs and to discuss each and everything about Software Testing also get an opportunity to get on an audio/video call with me directly to you.
I make videos on daily basics and also help student all over the world for FREE. If my videos are helpful in anyway help "SoftwaretestingbyMKT" reach billions by supporting
https://www.instamojo.com/@SoftwaretestingbyMKT
OR
https://www.paypal.com/paypalme/IAMMKT