SQL Introduction to SQL Understand what is SQL Basics of SQL SQL Components Importance of SQL Download Proper SQL Tool Data Definition Language (DDL) SQL Setup Download Proper SQL Tool Installing SQL server Setting up the database Creating your first database Basic SQL Queries SELECT statement FROM clause WHERE clause ORDER BY clause LIMIT statement DISTINCT clause Advanced SQL Queries JOIN operations GROUP BY clause HAVING clause UNION operation Wildcards usage Sub-queries SQL Operators Comparison operators Arithmetic operators Logical operators Set operators Bitwise operators Managing SQL Databases Create databases Modify databases Delete databases Handling database connections Granting & revoking permissions Database security SQL Functions Scalar functions Aggregate functions Date and time functions String functions Mathematical functions Control flow functions SQL Transact & Errors Understanding transactions COMMIT operation ROLLBACK operation SAVEPOINT operation Exception handling in SQL NULL values handling SQL Index & Perf Tuning Understanding indexes Creating and modifying indexes Index types in SQL Performance tuning tips SQL query optimization Database normalization SQL Trigs & Proc Understanding triggers Creating and managing triggers Understanding stored procedures Create & Manage SPs Cursors in SQL Temporary tables SQL Data Types Understanding SQL data types Numeric data types String data types Date and time data types Other special data types NULL value Data Management in SQL Importing and exporting data Data backup Data recovery Scheduled jobs Monitoring activities Database maintenance tasks

For detailed explanations and theory, visit the Complete Java Roadmap Notes.