what need to learn in mysql?

Question

Rajanikant Hawaldar · Answer

Learn and practice writing queries, sub queries, CTE, stored procedures, views, triggers etc using Basic keywords: 1. Select 2. Distinct 3. IS NULL 4. WHERE 5. LIKE 6. Order by 7. Limit and offset 8. Case 9. Rank and Dense Rank 10. Union and Union all 11. Exists 12. Count and it's variant 13. Max, Min, Sum, Avg, etc 14. Round, Substr,len 15. Alter, Update, Delete 16. Create, Insert Operators: 1. And 2. Or 3. Greater Than 4. Less Than Joins: 1. Self join 2. Inner join 3. Cross join 4. Left and Right outer join 5. Full Outer Join Windows function: 1. Rank 2.Dense_Rank 5. NTILE 6. ROW_NUMBER

Sarang Babu · Answer

You can start by learning the very basics. Go step by step and learn one topic at a time. There are plenty of free online resources from where you can start learning. The topics you should master are - SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And, Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Group By SQL Having SQL Exists SQL Any, All SQL Select Into SQL Insert Into Select SQL Case SQL Null Functions SQL Stored Procedures SQL Comments SQL Operators These are the basics you should get started with.

Jignesh Kumar · Answer

Hi Manju, Please refer below links which will help you out to learn step by step SQL server which may help long run for future, https://www.c-sharpcorner.com/learn/mastering-sql https://www.tutorialsteacher.com/sql

what need to learn in mysql?

Answers (3)