SQL

• 1. Introduction to SQL

• 2. Data Types

• 3. Operators

• 4. Create Database

• 5. Drop Database

• 6. Rename Database

• 7. Select Database

• 8. What is Tables?

• 9. Create Table

• 10. Drop Table

• 11. Rename Table

• 12. Truncate Table

• 13. Copy Table

• 14. Temporary Tables

• 15. Alter Table

• 16. Select Statement

• 17. Select Unique

• 18. Select Count

• 19. Select Top

• 20. Select First

• 21. Select Last

• 22. Select Random

• 23. Views

• 24. Select In

• 25. Select Where Clause

• 26. Select AND

• 27. Select Or

• 28. Select With

• 29. Select As

• 30. Select Group By

• 31. Select Having

• 32. Select Order By

• 33. Select Order By Random

• 34. Select Order By Limit

• 35. Insert Query

• 36. Update Query

• 37. Delete Query Remove Records

• 38. Delete Duplicate Records

• 39. Joins

• 40. Join Outer

• 41. Joins Left

• 42. Join Right

• 43. Join Full

• 44. Join Cross

• 45. Primary Key

• 46. Foreign Key

• 47. Composite Key

• 48. Aliases