Learn SQL

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language.

* Contents:

1. Overview

2. RDBMS Concepts

3. Databases

4. Syntax

5. Data Types

6. Operators

7. Expressions

8. Create Database

9. Drop Database

10. Select Database

11. Create Table

12. Drop Table

13. Insert Query

14. Select Query

15. Where Clause

16. AND & OR Clauses

17. Update Query

18. Delete Query

19. Like Clause

20. Top Clause

21. Order By

22. Group By

23. Distinct Keyword

24. Sorting Results

25. Constraints

26. Using Joins

27. Unions Clause

28. NULL Values

29. Alias Syntax

30. Indexes

31. Alter Command

32. Truncate Table

33. Using Views

34. Having Clause

35. Transactions

36. Wildcards

37. Date Functions

38. Temporary Tables

39. Clone Tables

40. Sub Queries

41. Using Sequences

42. Handling Duplicates

43. Injection