SQL Practice: Basic Queries
17mBeginner2023-09-13
Authors
David Gassner
Author of 60+ video-based training courses for software developers
Course details
In this hands-on, interactive course, join instructor David Gassner to practice writing basic queries in SQL, the popular programming language that’s widely used for relational databases. This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. David helps you boost your skills as a SQL programmer with seven specific, query-focused coding challenges. Practice retrieving sorted data from a specific table or multiple tables, retrieving data filtered on a range of values, retrieving aggregated data with SQL functions, retrieving data filtered with a string pattern, and more.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Talking to your database in SQL
- 02 - What you should know
- 03 - Exploring the lab environment
1. Code Challenges
- 04 - Solution - Get sorted data from a table
- 05 - Solution - Retrieve data from multiple tables
- 06 - Solution - Retrieve data filtered on a range
- 07 - Solution - Retrieve aggregated data
- 08 - Solution - Get data filtered with a string pattern
- 09 - Solution - Find the most expensive order
- 10 - Solution - Find the average of orders
Conclusion
- 11 - Next steps
Related courses
- Advanced SQL Project: Design and Manage a Database
- PHP: Accessing Databases with PDO and MySQLi
- Build with AI: SQL Agents with Large Language Models
- Introduction to Career Skills in Data Analytics
- Learning Data Analytics Part 2: Extending and Applying Core Knowledge
- Using Snowflake with Tableau
- SQL Practice: Managing Tables with CREATE, ALTER, and DROP
- Data Analysis with PostgreSQL