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

Developing Scalable Apps in Python
Google via Udacity
Capstone: Retrieving, Processing, and Visualizing Data with Python
University of Michigan via Coursera
Teaching Impacts of Technology: Workplace of the Future
University of California, San Diego via Coursera
Build Native Mobile Apps with Flutter
Google via Udacity
Health Informatics and Technology in Decision Making
Doane University via edX