Intermediate SQL
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Start Course for Free4 Hours14 Videos50 Exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Course Description
SQL is the most popular language for turning raw data stored in a database into actionable insights. Using a database of films made around the world, this course covers:
✓ How to filter and compare data
✓ How to use aggregate functions to summarize data
✓ How to sort and group your data
✓ How to present your data cleanly using tools such as rounding and aliasing
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
✓ How to filter and compare data
✓ How to use aggregate functions to summarize data
✓ How to sort and group your data
✓ How to present your data cleanly using tools such as rounding and aliasing
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
- 1
Selecting Data
FreeIn this first chapter, you’ll learn how to query a films database and select the data needed to answer questions about the movies and actors. You'll also understand how SQL code is executed and formatted.
- 2
Filtering Records
Learn about how you can filter numerical and textual data with SQL. Filtering is an important use for this language. You’ll learn how to use new keywords and operators to help you narrow down your query to get results that meet your desired criteria and gain a better understanding of NULL values and how to handle them.
Filtering numbers50 xpFiltering results50 xpUsing WHERE with numbers100 xpUsing WHERE with text100 xpMultiple criteria50 xpUsing AND100 xpUsing OR100 xpUsing BETWEEN100 xpFiltering text50 xpLIKE and NOT LIKE100 xpWHERE IN100 xpCombining filtering and selecting100 xpNULL values50 xpWhat does NULL mean?50 xpPractice with NULLs100 xp - 3
Aggregate Functions
SQL allows you to zoom in and out to better understand an entire dataset, its subsets, and its individual records. You'll learn to summarize data using aggregate functions and perform basic arithmetic calculations inside queries to gain insights into what makes a successful film.
Summarizing data50 xpAggregate functions and data types100 xpPractice with aggregate functions100 xpSummarizing subsets50 xpCombining aggregate functions with WHERE100 xpUsing ROUND()100 xpROUND() with a negative parameter100 xpAliasing and arithmetic50 xpUsing arithmetic50 xpAliasing with functions100 xpRounding results100 xp - 4
Sorting and Grouping
This final chapter teaches you how to sort and group data. These skills will take your analyses to a new level by helping you uncover critical business insights and identify trends and performance. You'll get hands-on experience to determine which films performed the best and how movie durations and budgets changed over time.
Sorting results50 xpSorting text50 xpSorting single fields100 xpSorting multiple fields100 xpGrouping data50 xpGROUP BY single fields100 xpGROUP BY multiple fields100 xpAnswering business questions50 xpFiltering grouped data50 xpFilter with HAVING100 xpHAVING and sorting100 xpAll together now100 xpCongratulations!50 xp
In the following tracks
Data Analyst in SQLData EngineerData Scientist Professional with PythonData Scientist Professional with RSQL FundamentalsCollaborators
Prerequisites
Introduction to SQLJasmin Ludolf
See More
Data Science Content Developer, DataCamp
Jasmin is a Content Developer at DataCamp. After ten years as a global marketing manager in the music industry, she recently changed careers to follow her curiosity for data. Her passion is value exchange and making data science accessible to all.
Don’t just take our word for it
*4.7
80%
15%
3%
1%
1%
Sort by
- Angela P.about 21 hours
Information was presented at a good pace in a manner that was clearly understandable. Important concepts like the order of execution were explained and emphasized, which I appreciated. This was a class done well and absolutely worth the time to take.
- Amogh N.3 days
The content in the videos were crisp. I thought a little more deeper explanation would be good.
- Aung H.4 days
It’s quite interesting and I feel like I would like learn more about it.
- Levi M.6 days
Exactly what I'd expect as a follow up for the intro to SQL
- Martin P.7 days
I am well versed in SQL and joins but still managed to learn something from the course and will use it in my work.
FAQs
Join over 12 million learners and start Intermediate SQL today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.