SQL for Data Analytics · Setting up Canvas

Setting up Canvas

What goes in Canvas

Not much, and that's on purpose. The course is on this site. Canvas is where students turn things in.

  • One assignment per unit, set up as a file upload with a due date. The description links to the unit on this site and says what to do: work through the lessons, do the practice, download the submission file, and upload it here. The due date is what puts the unit on the student's Canvas calendar and to-do list.
  • Announcements and grades, as usual.
  • Anything that shouldn't be public. This site is public. The office hours Zoom link is on it because the room has a waiting room. A tutoring schedule or anything with student information belongs in Canvas.

If you'd like a page of this site to show up inside Canvas, the Office hours page for example, any page can be embedded. The codes are in the next section. I wouldn't embed the practice pages. A browser keeps the work a student does inside an embedded page apart from the work they do on the site itself, so a student who starts a practice in one place and opens it in the other finds it empty. Link to the practice and let it open on the site.

Links and embed codes

These are made from the pages that are published right now, using the address you're viewing this site at. When a new unit goes live, it shows up here.

To embed a page: in Canvas, edit the page, switch the editor to HTML with the </> button, paste the code, and save. An embedded lesson has no site menu. Its Back and Continue buttons move between the sections of that one lesson, and a small link at the top opens the full site.

Course resources · Office hours

Link to the unitfor the assignment description
Overviewembed code · /units/resources/

Unit 00 · Start here

Link to the unitfor the assignment description
Overviewembed code · /units/start-here/
1 · AI in this classembed code · /units/start-here/01-ai-in-this-class/
2 · Syllabusembed code · /units/start-here/02-syllabus/
3 · How the course worksembed code · /units/start-here/03-how-the-course-works/
Practicelink for the assignment description · not embedded

Unit 01 · Data and tables

Link to the unitfor the assignment description
Overviewembed code · /units/data-and-tables/
1 · Learning to Learnembed code · /units/data-and-tables/01-learning-to-learn/
2 · SQL for Data Analyticsembed code · /units/data-and-tables/02-sql-for-data-analytics/
3 · Basics of Dataembed code · /units/data-and-tables/03-basics-of-data/
4 · Databases and Relational Dataembed code · /units/data-and-tables/04-databases-and-relational-data/
Practicelink for the assignment description · not embedded

Unit 02 · Querying single tables

Link to the unitfor the assignment description
Overviewembed code · /units/querying-single-tables/
1 · SELECT Statementsembed code · /units/querying-single-tables/01-select-statements/
2 · Math on Columnsembed code · /units/querying-single-tables/02-math-on-columns/
3 · Column Aliasingembed code · /units/querying-single-tables/03-column-aliasing/
4 · WHERE Clauseembed code · /units/querying-single-tables/04-where-clause/
5 · ORDER BY, LIMIT, and Query Structureembed code · /units/querying-single-tables/05-order-by-limit-and-query-structure/
Practicelink for the assignment description · not embedded

Unit 03 · Aggregation

Link to the unitfor the assignment description
Overviewembed code · /units/aggregation/
1 · Null Valuesembed code · /units/aggregation/01-null-values/
2 · Aggregate Functionsembed code · /units/aggregation/02-aggregate-functions/
3 · GROUP BYembed code · /units/aggregation/03-group-by/
4 · HAVINGembed code · /units/aggregation/04-having/
5 · Query Orderembed code · /units/aggregation/05-query-order/
Practicelink for the assignment description · not embedded

Unit 04 · Answering a business question

Link to the unitfor the assignment description
Overviewembed code · /units/answering-a-business-question/
1 · An example analysisembed code · /units/answering-a-business-question/01-an-example-analysis/
2 · What is one row?embed code · /units/answering-a-business-question/02-what-is-one-row/
3 · Checking your answerembed code · /units/answering-a-business-question/03-checking-your-answer/
Practicelink for the assignment description · not embedded

Unit 05 · Joining tables

Link to the unitfor the assignment description
Overviewembed code · /units/joining-tables/
1 · Table Relationshipsembed code · /units/joining-tables/01-table-relationships/
2 · Table JOINsembed code · /units/joining-tables/02-table-joins/
3 · Multiple Table JOINsembed code · /units/joining-tables/03-multiple-table-joins/
4 · LEFT JOINembed code · /units/joining-tables/04-left-join/
Practicelink for the assignment description · not embedded

Unit 06 · AI in Data Analytics

Link to the unitfor the assignment description
Overviewembed code · /units/working-with-ai/
1 · What the query missesembed code · /units/working-with-ai/01-what-the-query-cant-tell-you/
2 · AI in an analysisembed code · /units/working-with-ai/02-working-with-ai-on-an-analysis/
3 · A mistake Claude madeembed code · /units/working-with-ai/03-when-the-ai-misreads-the-data/
Practicelink for the assignment description · not embedded

Midterm · Midterm check-in

Link to the unitfor the assignment description
Overviewembed code · /units/midterm/
1 · Midterm reviewembed code · /units/midterm/review/

Unit 07 · Reading database designs

Link to the unitfor the assignment description
Overviewembed code · /units/reading-database-designs/
1 · Diagram structureembed code · /units/reading-database-designs/01-diagram-structure/
2 · Reading relationshipsembed code · /units/reading-database-designs/02-reading-relationships/
3 · Types and nullabilityembed code · /units/reading-database-designs/03-types-and-nullability/
4 · Queries from diagramsembed code · /units/reading-database-designs/04-queries-from-diagrams/
Practicelink for the assignment description · not embedded

Unit 08 · Building and changing tables

Link to the unitfor the assignment description
Overviewembed code · /units/building-and-changing-tables/
1 · CREATE, ALTER, DROPembed code · /units/building-and-changing-tables/01-create-alter-drop/
2 · Changing the dataembed code · /units/building-and-changing-tables/02-changing-the-data/
3 · Constraintsembed code · /units/building-and-changing-tables/03-constraints/
Practicelink for the assignment description · not embedded

Unit 09 · Modeling relationships

Link to the unitfor the assignment description
Overviewembed code · /units/modeling-relationships/
1 · Many-to-manyembed code · /units/modeling-relationships/01-many-to-many/
2 · Drawing diagramsembed code · /units/modeling-relationships/02-drawing-diagrams/
3 · Composite primary keysembed code · /units/modeling-relationships/03-composite-primary-keys/
Practicelink for the assignment description · not embedded

Unit 10 · Database design

Link to the unitfor the assignment description
Overviewembed code · /units/database-design/
1 · Designing a databaseembed code · /units/database-design/01-designing-a-database/
2 · The Edanava problemembed code · /units/database-design/02-the-edanava-problem/
3 · Opportunities & stepsembed code · /units/database-design/03-opportunities-and-steps/
4 · Testing the designembed code · /units/database-design/04-testing-the-design/
Practicelink for the assignment description · not embedded

Final · Final exam

Link to the unitfor the assignment description
Overviewembed code · /units/final-exam-prep/
1 · Cheat sheetembed code · /units/final-exam-prep/01-cheat-sheet/
Announcement and assignment text

Ready-made text for Canvas, already formatted. Click Copy HTML. In Canvas, edit the announcement or the assignment, switch the editor to HTML with the </> button, and paste. The links use the address you're viewing this site at.

Name each assignment the way it's shown here, because the practice pages tell students which assignment to look for. Set the assignment to Online, File Uploads, with unlimited attempts.

Welcome announcement

Welcome to SQL for Data Analytics. Start here.use that as the announcement title

Assignments

Start here practiceStart here
Unit 01 practiceData and tables
Unit 02 practiceQuerying single tables
Unit 03 practiceAggregation
Unit 04 practiceAnswering a business question
Unit 05 practiceJoining tables
Unit 06 practiceAI in Data Analytics
Midterm reviewdue first · links to the check-in page, which links to the review
Midterm check-inthe grade for the meeting · set it to No Submission, due after the check-ins
Unit 07 practiceReading database designs
Unit 08 practiceBuilding and changing tables
Unit 09 practiceModeling relationships
Unit 10 practiceDatabase design
Final examthe grade for the final · set it to No Submission

Preview of what gets copied: