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

MongoDB for .NET Developers
MongoDB University Implementing ETL with SQL Server Integration Services
Microsoft via edX Практики оперативной аналитики в MS Excel
Saint Petersburg State University via Coursera Analyzing Big Data with SQL
Cloudera via Coursera Data Analysis Using Python
University of Pennsylvania via Coursera