Tuesday, November 10, 2020

SQL - STEP BY STEP

 1.  SQL1 dept create table without primary key.

2. SQL2 data insertion into two ways.



3. SQL3 display dept table.

4. SQL4 display column in a table.

5. SQL5.USE OF WHERE IN A TABLE.

6. SQL6 display data where location=mumbai. 


7. SQL7 WHAT IS MAIN PROBLEM IF WE NOT USE ANY PRIMARY KEY IN A TABLE.

8. SQL8 DELETE THE TABLE DEPT.


9. SQL9 PRIMARY KEY CREATION IN TABLE.



10.  SQL10 ADVANTAGES OF PRIMARY KEY IN A TABLE.


11. SQL11 USE OF DESC IN SQL .


12.  SQL12 USE OF DEFAULT VALUE IN SQL TABLE.



13. SQL13 HOW FOREIGN KEY IS CREATED??


14. SQL14 WHY FOREIGN KEY IS USED??


15. SQL15 USE OF BETWEEN KEYWORD IN SQL.


16. SQL16 USE OF NOT BETWEEN IN SQL.


17. SQL17 CURRENT DATE USING SYSDATE IN SQL.


18. SQL18 DUAL TABLE IN SQL.

19.SQL19 ARITHMETIC OPERATION IN SQL USING DUAL TABLE. 

20.SQL20 COLUMN RENAME USING AS IN SQL.

21. SQL21 STRING PATTERN MATCHING. 


22. SQL22 ENDING WITH A LETTER. STRING PATTERN MATCHING. 



23.  SQL23 SATRTING WITH TWO LETTER।


24. SQL24 ENDING WITH TWO LETTER।





25. SQL25 STARTING AND ENDING WITH LETTER.




26. SQL26 SECOND LETTER MATCHING।


27. SQL27 3RD LETTER MATCHING। 


28. SQL28 4 LENTH NAME OR 4 LENGTH STRING।
 


29. SQL29 SECOND LETTER AND 4TH LETTER CHECKING. 




30. SQL30 a letter in ANY POSITION. 



31. SQL31 matches a SUBSTRING



32. SQL32 4 LENGTH BUT STARTING WITH A.




33. SQL33 4LENTH AND ENDING WITH A.




34. SQL34 NAME WITH TWO AA





35.  SQL35 FUNCTION OF COUNT() , COUNT() এর কাজ।





36. SQL36 FUNCTION OF MAX(), MAX() এর কাজ।



37. SQL37 FUNCTION OF MIN(), MIN () এর কাজ।



38.SQL38 FUNCTION OF SUM(), SUM() এর কাজ।



39. SQL39 FUNCTION OF AVG(), AVG()এর কাজ।


40. SQL40 USE OF IN, IN এর কাজ।


41. SQL41 FUNCTION OF NOT IN, NOT IN এর কাজ।




42.SQL42 FUNCTION OF GROUP BY. GROUP BY এর কাজ।


 




















































No comments:

Post a Comment