YoVDO

SQL Practice: Basic Queries

Offered By: LinkedIn Learning

Tags

SQL Courses Data Sorting Courses Data Filtering Courses Data Aggregation Courses Data Retrieval Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Practice writing basic queries in SQL in this hands-on, interactive course with coding challenges in CoderPad.

Syllabus

Introduction
  • Talking to your database in SQL
  • What you should know
  • Exploring the lab environment
1. Code Challenges
  • Solution: Get sorted data from a table
  • Solution: Retrieve data from multiple tables
  • Solution: Retrieve data filtered on a range
  • Solution: Retrieve aggregated data
  • Solution: Get data filtered with a string pattern
  • Solution: Find the most expensive order
  • Solution: Find the average of orders
Conclusion
  • Next steps

Taught by

David Gassner

Related Courses

Introduction to Databases
Meta via Coursera
Analyzing Big Data with SQL
Cloudera via Coursera
Managing Google Workspace 日本語版
Google Cloud via Coursera
Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera
Query Client Data with LibreOffice Base
Coursera Project Network via Coursera