After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
SQL is widely recognized as the most popular language for turning raw data stored in a database into actionable insights. This course uses a films database to teach how to navigate and extract insights from the data using SQL.
Discover Filtering with SQL
You'll discover techniques for filtering and comparing data, enabling you to extract specific information to gain insights and answer questions about the data.Get Acquainted with Aggregation
Next, you'll get a taste of aggregate functions, essential for summarizing data effectively and gaining valuable insights from large datasets. You'll also combine this with sorting and grouping data, adding another layer of meaning to your insights and analysis.Write Clean Queries
Finally, you'll be shown some tips and best practices for presenting your data and queries neatly. Throughout the course, you'll have hands-on practice queries to solidify your understanding of the concepts. By the end of the course, you'll have everything you need to know to analyze data using your own SQL code today!Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Identify and apply filtering techniques using WHERE, AND, OR, BETWEEN, and LIKE operators.
- Differentiate between aggregate functions (SUM, AVG, COUNT, etc.) and arithmetic operators in SQL queries.
- Recognize the correct use of WHERE versus HAVING when filtering grouped data.
- Define best practices for query readability using style guides, indentation, and aliasing.
- Evaluate and organize query results by applying sorting, grouping, and rounding techniques.
Prerequisites
Curriculum
Course outline
1
Selecting Data
In 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.
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.
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.
S
Intermediate SQL
Course
Complete
