Introduction
  • Introduction
Installation and Overview of SQL Environment (MySQL)
  • Installing MySQL
  • Getting Familiar with the Interface
Database Fundamentals
  • How databases are structured
  • Understanding a schema in MySQL
  • Sakila Sample Database in MySQL
  • Database Structure Quiz
Writing SQL Queries in MySQL
  • Your First SQL statement in MySQL
  • Inserting a new record
  • Limiting the result set with WHERE clause
  • Sorting your result set
  • Using Numeric and Date Values to narrow down your result set
  • Updating exiting records
  • Deleting records
  • Aggregating the data
  • Getting data from multiple tables
  • Practice your skills
Data manipulation outside the database
  • Exporting Data from MySQL to Excel
  • Connecting Data Visualization tools such as Tableau to mySQL
Beyond Data Manipulation
  • Creating a new table
  • Some advanced table commands.
  • How to import data from a CSV file into MySQL
  • How to import data in Excel to mySQL
  • Bonus Lecture