Introduction to MySQL

Table of contents

1. Introduction
   1. Welcome To The Course
   2. About The Author
2. Creating A Database
   1. What Is A Relational Database?
   2. What Is MySQL?
   3. Installing A Local Implementation Of MySQL
   4. Creating And Removing Tables
   5. Data Types
   6. What Is A Primary Key?
   7. Creating Indexes
   8. Modifying Table Structures
   9. Adding Data To A Table
   10. Changing Data In A Table
   11. Removing Data From A Table
3. Querying Data From A Database
   1. Retrieving Data From A Table
   2. Restricting Rows With The Where Clause
   3. Using Mathematical And Text Expressions
   4. Sorting Results
   5. Comparison Operators
   6. Logical Operators
   7. Dealing With Null Values
   8. What Is A Foreign Key?
   9. Joins With The Using Clause
   10. Joins With The On Clause
4. Using Functions And Summarizing Data
   1. Aggregate Functions
   2. Single Row Functions
   3. Using The Group By Clause
   4. Using The Having Clause
5. Advanced Database Queries
   1. Many To Many Relationships
   2. Join Multiple Tables With The Using Clause
   3. Join Multiple Tables With The On Clause
   4. Eliminating Duplicate Rows From The Results
   5. Using The Like Operator For Pattern Matching
   6. Using The In Operator
   7. How Subqueries Work
   8. Subqueries With The In Operator
   9. Creating And Using Views
   10. Combining SQL Results
6. Conclusion
   1. Legacy SQL Techniques
   2. Wrap Up And Thank You