YoVDO

Level Up: SQL

Offered By: LinkedIn Learning

Tags

SQL Courses Data Analysis Courses Relational Databases Courses Database Management Courses GitHub Codespaces Courses

Course Description

Overview

Test your SQL skills with these concise challenges.

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

Related Courses

A Hands-On Look at Amazon Q Business Expert
Amazon Web Services via AWS Skill Builder
Amazon Aurora - Cloud SQL DB Essentials
A Cloud Guru
Amazon DynamoDB Data Modeling
A Cloud Guru
AWS Certified Database - Specialty (DBS-C01)
A Cloud Guru
Database Essentials
A Cloud Guru