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

LinkedIn Learning

Level Up: SQL

via LinkedIn Learning

Overview

Syllabus

Introduction
  • SQL code challenges
  • Using GitHub Codespaces with this course
  • Exploring the databases and running SQL code
1. In the Restaurant
  • Create invitations for a party
  • Create a table to store information
  • Print a menu
  • Sign a customer up for your loyalty program
  • Update a customer's personal information
  • Remove information from the database
  • Log customer responses to an invitation
  • Look up reservations
  • Take a reservation
  • Take a delivery order
  • Track your customer's favorite dishes
  • Prepare a report of your top customers
2. At the Library
  • Check book availability
  • Add new books to the library
  • Check out books
  • Check for books due back
  • Return books to the library
  • Encourage patrons to check out books
  • Find books to feature for an event
  • Book statistics

Taught by

Scott Simpson

Reviews

Start your review of Level Up: SQL

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.