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

Social Network Analysis
University of Michigan via Coursera
Intro to Algorithms
Udacity
Data Analysis
Johns Hopkins University via Coursera
Computing for Data Analysis
Johns Hopkins University via Coursera
Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX