SQL code challenges - SQL Tutorial
5.0 /5- Offered byLinkedin Learning
SQL code challenges - SQL Tutorial at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Credential | Certificate |
SQL code challenges - SQL Tutorial at Linkedin Learning Course details
- The challenges will start out at a low difficulty level and will become more difficult toward the end
- The goal of these challenges is not to always arrive at the same conclusion I do, but to use the challenges as an opportunity to think about how to approach solving real-world problems
- In these videos, we'll use two different databases, one containing information about a popular neighborhood restaurant and one containing information about a small town library which has a collection of a few hundred classic books
- Learner can download these databases from the exercise files or from the GitHub repository, or if learners are using the Code Spaces interactive environment, the files are already there for learner
- The challenges will assume that learners are already taken a look at the databases and know a little bit about their structure before writing solutions
SQL code challenges - SQL Tutorial at Linkedin Learning Curriculum
Introduction
SQL code challenges
Using GitHub Codespaces with this course
Exploring the databases and running SQL code
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
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
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?