8.6 - Data Analysis & SQL Simulation
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
What does SQL stand for?
💡 Hint: Think about the terms used for working with databases.
Write a SQL query to find the lowest salary from the employees table.
💡 Hint: You need to order the salaries, but which order is needed for the lowest?
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What SQL statement do we use to retrieve specific columns from a table?
💡 Hint: Think of the word that indicates choosing something from a group.
True or False: The AVERAGEIF function in Excel can ignore empty cells.
💡 Hint: Does this function include blank cells in its calculations?
1 more question available
Challenge Problems
Push your limits with advanced challenges
Write a SQL query to find the second highest salary from the employees table without using the LIMIT clause.
💡 Hint: Think about how you can exclude the highest salary in your subquery.
Create a complex Excel formula that calculates the average sales only for products sold over 50 units in the range B1:B20.
💡 Hint: Use a condition to filter your range before averaging it.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.