1. Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
2. Practice SQL without installing any Software
3. Select Command
4. Distinct keyword
5. SQL is not case sensitive
6. Semicolon
7. Where Clause
8. Using Relational Operators in Where Clause Condition
9. Using Logical Operators (AND, OR, NOT)
10. Between Operator
11. Order By Clause (ASC, DESC)
12. Using Between Operator with Text
13. In Operator
14. Like Operator and Wildcard Characters
15. Aliases for Table Column Names AS Keyword
16. Limit Keyword
17. Breaking the Lengthy SQL Statement into multiple lines
18. MySQL Built in Functions
19. upper() MySQL String Function
20. lower() MySQL String Function
21. Length() MySQL String Function
22. Instr() MySQL String Function
23. Substr() MySQL String Function.
24. Concat() MySQL String Function
25. Trim() MySQL String Function
26. Abs() MySQL Numeric Function
27. Mod() MySQL Numeric Function
28. Greatest() and least() MySQL Numeric Functions
29. Truncate() MySQL Numeric Function
30. Power() and sqrt() MySQL Numeric Functions
31. Current_date(), curdate(), current_time(), curtime(), now() & sysdate().
32. Year(),month(),day(),month name(),day name() MySQL Date Time Functions
33. Avg(), max(), min(), count() and sum() MySQL Aggregate Functions.
34. Arithmetic Operators
35. Installing MySQL Server and Workbench Client for Practice
36. Creating, Deleting, viewing and using Databases
37. Creating, Viewing, Describing and Deleting Tables
38. Insert Into Statements (For inserting data into Tables)
39. Data Types
40. Null Value, Is Null Operator and Is Not Null Operator.
41. Delete Statement (For Deleting the Records from Table).
42. Update Statement and Set Keyword (For Updating the Table Records
43. Rename statement and To Keyword (For Renaming Table Name).
44. Alter Statement, Add, Modify Column, Rename Column, and Drop Column.
45. Set Autocommit
46. Commit Statement
47. Rollback Statement
48. Truncate Statement
49. Single Line and Multi Line Comments
50. Group By Clause
51. Having Clause
52. Sequence of using where, group by, having and order by clauses.
53. Set Operators
54. Union Operator
55. Union All Operator
56. Intersect Operator
57. Minus Operator
58. Tables and Aliases
59. Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
60. Sub Query (Single Row Sub Query explained by solving different problems)
61. In Operator
62. Using In Operator with Multi Row Sub Query
63. Using Any Operator in Multi Row Sub Query
64. Using All Operator in Multi Row Sub Query
65. Exists Operator
66. Using Sub Queries for retrieving the records from multiple tables.
67. Using Multiple Sub Queries in a single SQL statement
68. Integrity Constraints
69. Not Null Integrity Constraint
70. Unique Integrity Constraint.
71. Primary Key Integrity Constraint
72. Foreign Key Integrity Constraint
73. Check Integrity Constraint
74. Default Integrity Constraint
75. Auto_increment
76. Insert Into
77. AS Keyword
78. IfNull() function
79. Case, When, Then and End Keywords
80. Delimiter
81. Delimiter usage in Stored Procedures
82. Views
83. Indexes
84. JDBC (MySQL Database connection from Java Programs)
85. ODBC (Object Database Connectivity) using SQL ODBC Query Client Tool
86. MySQL Shell Command Line Tool
87. MySQL Command Line Client
88. Using default Windows Command Prompt for connecting to MySQL Server.
89. Types of SQL Statements
90. Grant and Revoke SQL Statements
91. Temporary Tables
92. Show Columns,Show Indexes,Show Privileges and Show Grants Statements
93. Inserting Null
94. Using trim() for trimming the corner characters of the Table Values.
95. Using wild cards as normal characters
96. Database Objects
97. Creating Linux Virtual Machine
98. Installing MySQL Server in Linux Ubuntu Machine
99. Putty for Connecting to a Remote Machine having MySQL Server.
100. Oracle 11g Software, SQL Plus, SQL Developer and Executing SQL Queries.
101. Oracle SQL Queries
102. Oracle SQL Built in functions
103. Oracle SQL Queries (Part 2)
104. Oracle SQL Queries (Part 3).
105. Oracle SQL Queries (Part 4)
106. Oracle SQL Queries (Part 5)
107. DBeaver Universal DB Client Tool
108. XAMPP for Practicing SQL
109. Savepoint
