Basics of SQL
- SELECT Data
- INSERT Data
- UPDATE Data
- DELETE Data
- CREATE Table
- Specify Which Database To Use
- Numeric Data Types In SQL
- String Data Types In SQL
- Delete a Table
- See All Tables In Your Database
- See The Attributes Of a Particular Table
- See All Data Currently In a Table
- Pattern Matching
- Sorting the Output
- Subqueries
- The EXISTS Operator
- The IN Operator
- The ALL And ANY Operators
- Theta-Joins
- Natural Joins
- Eliminating Duplicates
- Grouping
- The Aggregation Operators - SUM, AVG, MIN, MAX, COUNT
- The HAVING Clause
- Foreign Keys
- Maintaining Referential Integrity With Foreign Keys
- The NOT NULL Constraint
- The CHECK Constraint
- Views
- Querying Views
- Renaming Attributes In Views
- Change Password For Currently Logged In User
- Using mysqldump To Export Data
- Outer Join
- Indexes
- Create a New Database
- Auto Increment
- Transactions
- Isolation Levels in a Transaction
- GRANTing Privileges
- REVOKing Privileges
- Triggers
- How do I use a string literal that contains an embedded single-quote (') character?
- Get The Number of Rows In a Table