Database

• Introduction in Database
  • Relational vs Non-Relational in Database
  • MySQL History & Architecture in Database
• Basic SQL in Database
  • Exploring MySQL in Database
  • Create Database in Database
  • Data Types in Database
  • Create Table in Database
  • Temporary Table in Database
  • Collations & Character Sets in Database
  • Inserting Data in Database
  • Querying Data in Database
  • LIKE Operator in Database
  • Combining Conditions in Database
  • ORDER BY in Database
  • LIMIT in Database
  • Deleting Data in Database
  • TRUNCATE in Database
  • Updating Data in Database
  • Primary Key and Indexes in Database
  • ... continued in Database
  • Alterations in Database
  • Alter Index in Database
  • More on Alter in Database
  • Alias in Database
  • DISTINCT in Database
  • Aggregate Methods in Database
  • GROUP BY in Database
  • HAVING in Database
• Joins in Database
  • Types of Joins in Database
  • Self Inner Join in Database
  • Inner Join in Database
  • Union in Database
  • Left and Right Joins in Database
  • Natural Join in Database
• Nested Queries in Database
  • Nested Scalar Queries in Database
  • Nested Column Queries in Database
  • Nested Row Queries in Database
  • EXISTS Operator in Database
  • Correlated Queries in Database
• Multi Table Operations in Database
  • Multi-Table Delete in Database
  • Multi-Table Update in Database
  • SELECT and INSERT in Database
  • REPLACE in Database
• Views in Database
  • Creating a View in Database
  • Untitled Masterpiece in Database
  • With Check Option in Database
  • Local & Cascaded Check in Database
  • Drop, Show, & Rename Views in Database
• Stored Procedures in Database
  • What are Stored Procedures? in Database
  • Create, Delete, and Alter a Stored Procedure in Database
  • Variables in Database
  • Parameters in Database
  • Conditional Statements in Database
  • Iterative Statements in Database
  • Cursors in Database
  • Error Handling in Database
  • SIGNAL and RESIGNAL in Database
  • Stored Functions in Database
• Triggers in Database
  • What are Triggers? in Database
  • Create and Delete a Trigger in Database
  • INSERT Triggers in Database
  • UPDATE Triggers in Database
  • DELETE Triggers in Database
  • Multiple Triggers in Database
• Miscellaneous in Database
  • Transaction in Database
  • EXPLAIN in Database
  • Foreign Keys in Database