Day 01: Introduction to SQL

• Concepts covered: Introduction to SQL

Day 02: MySQL

• 01-Installing-MySQL.md

• 02-Accessing-MySQL-via-CLI.md

• 03-Creating-database.md

• Concepts covered: MySQL installation, accessing MySQL via CLI, creating a database in MySQL

Day 03: SQL Database

• SQLBackupDatabase.md

• SQLCreateDatabase.md

• SQLDropDatabase.md

• SQLRenameDatabase.md

• SQLSelectDatabase.md

• SQLShowDatabases.md

• Concepts covered: Database operations in SQL

Day 04: Types of SQL Databases

• Concepts covered: Overview of different types of SQL databases

Day 05: SQL Table

• AlterTables.md

• CloneTables.md

• Constraints.md

• CreateTable.md

• DataTypes.md

• DeleteTable.md

• DropTable.md

• RenameTable.md

• ShowTables.md

• TemporaryTables.md

• TruncateTable.md

• Concepts covered: Table operations in SQL, table constraints, data types

Day 06: SQL Queries

• DeleteQuery.md

• InsertIntoSelect.md

• InsertQuery.md

• SelectQuery.md

• SortingResults.md

• UpdateQuery.md

• Concepts covered: Basic SQL queries, data manipulation

Day 07: SQL Operators and Clauses

• AND_OR.md

• ANYALLOperators.md

• Aliases.md

• BOOLEAN_BIT_Operator.md

• CASE.md

• DistinctClause.md

• EXISTSOperator.md

• GroupByClause.md

• HavingClause.md

• INOperator.md

• INTERSECT_EXCEPT_Operator.md

• LIKEOperator.md

• NOTEQUAL.md

• NOTOperator.md

• TopClause.md

• UNION_UNIONALL.md

• WhereClause.md

• null_not_null.md

• Concepts covered: SQL operators and clauses

Day 08: SQL Keys

• Concepts covered: Introduction to SQL keys

Day 09: SQL Indexes

• Concepts covered: Introduction to SQL indexes

Day 10: SQL Function

• AggregateFunctions.md

• Date_TimeFunctions.md

• ScalarFunctions.md

• StringFunctions.md

• User-DefinedFunctions.md

• Concepts covered: SQL functions, aggregate functions, date and time functions, scalar functions, user-defined functions

Day 11: SQL Joins

• FullJoin.md

• InnerJoin.md

• LeftJoin.md

• RightJoin.md

• SelfJoin.md

• Concepts covered: Different types of SQL joins

Day 12: SQL Views

• Concepts covered: Introduction to SQL views