Use this Brightspace Data Sets sample pack to practice SQL joins before working with your own extracts. Every person, course and grade is made up for the fictional Northfield Example College.

Where the data comes from: Brightspace Data Sets, the CSV extracts Brightspace publishes in Data Hub. This is not a built-in Brightspace report or screen. Rowseta syncs these data sets for you, or your administrator can download the extracts for your own SQL tool.

Try the sample data

Open the sample files

Download the pack using the link above. Unzip it, then unzip each data set archive. Each archive holds one CSV with a header row, UTF-8 with a BOM and CRLF line endings. Boolean values are TRUE or FALSE; empty fields represent missing values. The sample uses a fixed date of November 1, 2026.

These fictional files follow the data set reference. They are full sample extracts, with no differential updates. They are not exports from a real institution. Email addresses use the reserved .example domain.

What is inside

Try an enrollment join

Load each CSV into your SQL tool with the first row as headers. Name each table after its file without .csv, for example UserEnrollments. Another SQL tool may need small changes to this query.

sql
SELECT UserEnrollments.OrgUnitId, OrganizationalUnits.Name AS CourseName,
       Users.UserId, Users.FirstName, Users.LastName, UserEnrollments.RoleId
FROM UserEnrollments
JOIN Users ON Users.UserId = UserEnrollments.UserId
JOIN OrganizationalUnits ON OrganizationalUnits.OrgUnitId = UserEnrollments.OrgUnitId
ORDER BY UserEnrollments.OrgUnitId, Users.UserId;

Each row connects an enrollment to a person and a course through their IDs. Different people deliberately share first and last names, and different courses share names. Keep the IDs in your results and use them for joins and distinct counts.

When it goes wrong

What you seeWhat to do
The download contains more zip filesUnzip the main download, then unzip each data set archive to get its CSV file.
A join combines different people or coursesJoin on UserId and OrgUnitId. The sample deliberately includes different IDs with the same names.
The first column name looks wrongImport the file as UTF-8 with a BOM and use the first row as column headers.

Next guides

Brightspace Data Sets full vs differential: avoid duplicate rowsHow to join Brightspace Data Sets: keys and a worked query