19 - Advanced SQL and NoSQL for Data Science
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
Define a subquery and provide an example.
💡 Hint: Think about how filtering works within a query.
What does a CTE do?
💡 Hint: What do we call a temporary result set in SQL?
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What is the purpose of a subquery in SQL?
💡 Hint: Consider how queries can be layered.
True or False: CTEs are only used in nested queries.
💡 Hint: Think about the functionality of CTEs beyond nesting.
2 more questions available
Challenge Problems
Push your limits with advanced challenges
Create a SQL query using a subquery that finds the names of employees who have the highest salary within each department.
💡 Hint: You may need to consider aggregation and grouping functions.
Describe how you would use CTEs to find the total sales in each region using sales data.
💡 Hint: Remember the structure of a CTE and how to use the WITH clause.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.
- SQL Subqueries Explained
- Common Table Expressions in SQL
- Understanding Window Functions
- Pivoting Data in SQL
- Introduction to NoSQL Databases
- Understanding MongoDB CRUD Operations
- SQL vs NoSQL: What's the Difference?
- MongoDB Aggregation Pipeline
- A Beginner's Guide to Data Engineering
- Understanding SQL Optimization