Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Learning MySQL Development

via LinkedIn Learning

Overview

Syllabus

Introduction
  • Learning to use MySQL
  • How to get started with MySQL
1. Database Basics
  • What is a database?
  • SQL, a declarative language
  • Databases vs. flat files and spreadsheets
  • Common database terms
  • Database best practices
2. Exploring MySQL
  • Advantages and disadvantages of MySQL
  • Exploring MySQL Workbench
  • MySQL data types, part 1
  • MySQL data types, part 2
  • Challenge: Explore the built-in databases
  • Solution: Explore the built-in databases
3. Creating Tables
  • Create a database
  • Create a table
  • Use CREATE and ALTER to define a table
  • Primary keys and foreign keys
  • Load bulk data
  • Challenge: Create normalized movies table
  • Solution: Create normalized movies table
4. Selecting Data
  • The basics of SELECT
  • Refine SELECT queries
  • Filter results with WHERE
  • Display data with CASE
  • Challenge: Filter movies by score
  • Solution: Filter movies by score
5. Updating and Deleting Data
  • Add data to tables with INSERT
  • Update existing rows with UPDATE
  • Remove data with DELETE
  • Challenge: Clean up the movies
  • Solution: Clean up the movies
6. Joining Tables
  • The basics of JOIN
  • Match fields with INNER JOIN
  • Match all fields with outer joins
  • Challenge: Find the best film
  • Solution: Find the best film

Taught by

Brad Wheeler

Reviews

Start your review of Learning MySQL Development

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.