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.

Querying a database

Learning to COUNT()

Practice with COUNT()

SELECT DISTINCT

Query execution

SQL Order of Execution

Order of execution

Debugging errors

SQL style

SQL code

Best Practice

Poor Practice

SQL best practices

Formatting

Non-standard fields

Selecting Data

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 numbers

Filtering results

Using WHERE with numbers

Using WHERE with text

Multiple criteria

Using AND

Using OR

Using BETWEEN

Filtering text

LIKE and NOT LIKE

WHERE IN

Combining filtering and selecting

NULL values

What does NULL mean?

Practice with NULLs

Filtering Records

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 data

Aggregate functions and data types

Practice with aggregate functions

Summarizing subsets

Combining aggregate functions with WHERE

Using ROUND()

ROUND() with a negative parameter

Aliasing and arithmetic

Using arithmetic

Aliasing with functions

Rounding results

Aggregate Functions

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 results

Sorting text

Sorting single fields

Sorting multiple fields

Grouping data

GROUP BY single fields

GROUP BY multiple fields

Answering business questions

Filtering grouped data

Filter with HAVING

HAVING and sorting

All together now

Congratulations!

Sorting and Grouping

Films CSV

People CSV

Reviews CSV

Roles CSV

Course Glossary: Intermediate SQL

SQL is the most popular language for turning raw data stored in a database into actionable insights. Using a films database, you'll learn how to filter, compare, and summarize data with SQL. You'll also get a taste of aggregate functions, sorting, grouping, and how to present data neatly.  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!

The videos contain live transcripts, which can be accessed by clicking "Show transcript" at the bottom left of the videos.

The course glossary can be found on the right in the resources section.

To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

SQL secara luas diakui sebagai bahasa yang paling populer untuk mengubah data mentah yang disimpan dalam basis data menjadi wawasan yang dapat ditindaklanjuti. Kursus ini menggunakan basis data film untuk mengajarkan cara menavigasi dan mengekstrak wawasan dari data menggunakan SQL.
<br><br>
<h2>Pelajari Penyaringan dengan SQL</h2>
Anda akan mempelajari teknik untuk menyaring dan membandingkan data, sehingga Anda dapat mengekstrak informasi spesifik untuk mendapatkan wawasan dan menjawab pertanyaan tentang data tersebut.
<br><br>
<h2>Kenali Aggregation</h2>
Selanjutnya, Anda akan mengenal fungsi agregat, yang sangat penting untuk merangkum data secara efektif dan memperoleh wawasan berharga dari dataset yang besar. Anda juga akan menggabungkan hal ini dengan pengelompokan dan penyortiran data, menambahkan lapisan makna tambahan pada wawasan dan analisis Anda.
<br><br>
<h2>Tulis Query yang Bersih</h2>
Akhirnya, Anda akan diberikan beberapa tips dan praktik terbaik untuk menyajikan data dan kueri Anda dengan rapi. Selama kursus ini, Anda akan mendapatkan latihan praktis langsung untuk memperkuat pemahaman Anda tentang konsep-konsep yang dipelajari. Pada akhir kursus ini, Anda akan memiliki semua yang Anda butuhkan untuk menganalisis data menggunakan kode SQL Anda sendiri hari ini!

Introduction to SQL

Kursus ini mengajarkan analisis data dengan SQL melalui latihan langsung di setiap langkah!

Intermediate SQL

Lengkap dengan latihan setiap langkah, kursus ini ajarkan yang perlu diketahui untuk analisis data dengan kode SQL Anda sendiri hari ini.

Order of execution

Intermediate SQL

Latihan interaktif praktis