SQL Lesson Plan
- Some Quick Guide Lines
- Installing MySQL On Ubuntu
- Easily And Quickly Logging Into The MySQL CLI
- Generating MySQL User Passwords
- Creating MySQL Users
- Deleting Users
- Changing User Access
- Logging In As A Regular User
- Database Description Project Files
- Database Backup
- Different Databases For Different Jobs
- Database Keys
- Foreign Keys Vs Regular Keys
- Field Types
- Data Modelling
- Creating A Database
- Using A Database
- Creating A Table
- How Do We Show What Tables Exist?
- What If We Messed Up Defining Our Table? What Are Our Options?
- Creating A Table That Relates To Another
- An Alternative Method To Create Primary Keys And Auto Increment
- Inserting Data Into A Database
- Data Relationships
- Another Join Type - Left Joins
- Table Name Aliases
- Indexing For Speed
- Searching Tables
- The Where Clause
- Breaking Down Queries To Be More Readable
- Updating Data Already In The Database
- More Keys
- Dates And Times
- Date Integration Techniques
- Sorting
- Searching Using Dates
- Counting And Summing
- Search Limits
- Joining More Than Two Tables
- Lets Add A Shopping Cart - Getting Set Up
- Get All Customers And Orders
- Doing Math Aka Having A Store Wide Sale
- Doing Math For Business Intelligence
- Other Non Math Business Intelligence Methods
- More Business Intelligence Methods
- Searching Text Fields