YoVDO

First Look: MySQL 8 for Developers

Offered By: LinkedIn Learning

Tags

MySQL Courses Database Security Courses Common Table Expressions Courses

Course Description

Overview

Learn how to use MySQL to build databases and power data-driven applications.

Syllabus

Introduction
  • Learn 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
  • Display database relationships with reverse engineering
  • Load bulk data
  • Challenge: Create a normalized movies table
  • Solution: Create a 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
Conclusion
  • Level up your MySQL knowledge

Taught by

Ami Levin

Related Courses

Advanced MySQL Topics
Meta via Coursera
موضوعات MySQL المتقدمة
Meta via Coursera
Temas avanzados de MySQL
Meta via Coursera
Advanced Relational Database and SQL
Coursera Project Network via Coursera
Intermediate SQL
Cybrary