SQL Practice: Intermediate Queries
11mIntermediate2023-09-13
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
Looking to boost your skills writing queries in SQL? This course was made for you. Join senior LinkedIn Learning staff instructor Scott Simpson in this hands-on, interactive, skills-first coding course designed uniquely for intermediate SQL developers. Explore techniques for writing queries in SQL to boost your technical know-how or prepare for an interview to land a new role. This course includes Code Challenges powered by CoderPad: interactive coding exercises with real-time feedback, so you can get hands-on coding practice to advance your coding skills. Scott helps you develop your skills as a SQL programmer with five specific, query-focused coding challenges. Practice finding your top customers, listing items in each order, sorting orders by day, seasonal sales, and vendor integration.
Skills covered
Desktop DatabasesSQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Try your SQL programming skills
- 02 - What you should know
- 03 - Exploring the lab environment
1. Code Challenges
- 04 - Solution - Who are your top customers
- 05 - Solution - List items in each order
- 06 - Solution - Which days did people order pizza
- 07 - Solution - Seasonal sale
- 08 - Solution - Vendor integration
Conclusion
- 09 - Next steps