SQL Data Query Language Course

Data Query Language Course Overview

Table of Contents

• Content
• Standards
• Aspects
  • 👶 Introduction
  • 💪 Workout
  • 🦑 Deep
  • ✨ New
  • 🔮 Obscura

Content

Below you can find the ordered content of the topic, in a linear progression

The linear progression of content aims to cover all content, course by course, workout by workout as follows:

• first course is the only core one, denoted by its manifest
• the next course is denoted by the first item of the next array in each course manifest
• each course has its order of workouts designated by the sections field in the same aforementioned manifest

1. what-is-sql

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	what-is-sql	✅	👶 introduction	❌	✅	✅	❌	❌
2	why-learn-sql	✅	👶 introduction	❌	✅	❌	❌	❌
3	how-to-use-sql	✅	👶 introduction	❌	✅	❌	❌	❌
4	sql-your-first-query	✅	👶 introduction	❌	✅	❌	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

2. using-select

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	select-structure	✅	👶 introduction	❌	✅	✅	❌	❌
2	select-columns	✅	👶 introduction	❌	✅	✅	❌	❌
3	select-where-1	✅	👶 introduction	❌	✅	✅	❌	❌
4	select-where-2	✅	👶 introduction	❌	✅	✅	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

3. building-queries

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	select-with-as	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌
2	where-with-and	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌
3	sql-more-operators	✅	👶 introduction 💪 workout	❌	✅	❌	✅	❌
4	sql-not-example	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

4. special-operators

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	in-like-between-intro	✅	💪 workout	❌	✅	❌	❌	❌
2	sql-like	✅	💪 workout	❌	✅	✅	✅	❌
3	sql-between	✅	💪 workout	❌	✅	✅	✅	❌
4	sql-order-by	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌
5	sql-order-by-advanced	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

5. write

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	insert	✅	👶 introduction 💪 workout	write.0: 10	✅	✅	❌	✅
2	update-clause	✅	👶 introduction 💪 workout	write.3: 10	✅	✅	❌	✅
3	delete-clause	✅	👶 introduction 💪 workout	write.5: 10	✅	✅	❌	✅

Exercises:

no	name	type	aspects	standards	done
1	sql-practice-insert	sqlfiddle	👶 introduction	write.0: 1000	✅
2	sql-practice-update	sqlfiddle	👶 introduction 💪 workout	write.3: 1000	✅
3	sql-practice-delete	sqlfiddle	👶 introduction 💪 workout	write.5: 1000	✅

Game:

⚠️ There is no game in this workout.

6. aggregate-queries

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	group-by-clause	✅	💪 workout	aggregate-single-table.3: 10	✅	✅	❌	✅
2	sum-clause	✅	💪 workout	aggregate-single-table.0: 10	✅	✅	❌	✅
3	count-clause	✅	💪 workout	aggregate-single-table.0: 10	✅	✅	❌	✅
4	min-and-max-clauses	✅	💪 workout	aggregate-single-table.1: 10	✅	✅	❌	✅
5	distinct-clause	✅	💪 workout	aggregate-single-table.0: 10	✅	✅	❌	✅
6	avg-clause	✅	💪 workout	aggregate-single-table.0: 10	✅	✅	❌	✅

Exercises:

no	name	type	aspects	standards	done
1	sql-practice-aggregate-single-table	sqlfiddle	👶 introduction 💪 workout 🦑 deep	read-single-table.2: 1000 aggregate-single-table.0: 1000	✅
2	sql-practice-aggregate-single-table-2	sqlfiddle	👶 introduction 💪 workout 🦑 deep	aggregate-single-table.0: 1000	✅
3	sql-practice-aggregate-table-min-and-max	sqlfiddle	👶 introduction 💪 workout 🦑 deep	aggregate-single-table.1: 1000	✅
4	sql-practice-aggregate-table-max-filter	sqlfiddle	👶 introduction 💪 workout 🦑 deep	aggregate-single-table.1: 1000	✅
5	sql-practice-aggregate-group	sqlfiddle	👶 introduction 💪 workout 🦑 deep	aggregate-single-table.0: 1000 aggregate-single-table.3: 1000	✅
6	sql-practice-aggregate-average	sqlfiddle	👶 introduction 💪 workout 🦑 deep	aggregate-single-table.1: 1000 aggregate-single-table.3: 1000	✅

Game:

⚠️ There is no game in this workout.

7. joins

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	inner-join	✅	👶 introduction 💪 workout	❌	✅	✅	✅	❌
2	left-and-right-joins	✅	👶 introduction 💪 workout	read-multiple-tables.0: 10	✅	✅	✅	✅
3	full-join	✅	🦑 deep 💪 workout	read-multiple-tables.0: 10	✅	✅	✅	✅
4	multiple-joins	✅	💪 workout 🦑 deep	read-multiple-tables.0: 10 read-multiple-tables.1: 10	✅	✅	✅	✅
5	union	✅	💪 workout 🦑 deep	read-multiple-tables.0: 10	✅	✅	✅	✅

Exercises:

no	name	type	aspects	standards	done
1	sql-practice-join-multiple-tables	sqlfiddle	💪 workout 🦑 deep	read-multiple-tables.0: 1000 aggregate-multiple-tables.0: 1000	✅
2	sql-practice-average-aggregate-multiple-tables	sqlfiddle	💪 workout 🦑 deep	read-multiple-tables.0: 1000 aggregate-multiple-tables.0: 1000	✅
3	sql-practice-max-aggregate-multiple-tables	sqlfiddle	💪 workout 🦑 deep	read-multiple-tables.0: 1000 aggregate-multiple-tables.0: 1000	✅
4	sql-practice-min-max-multiple-tables	sqlfiddle	💪 workout 🦑 deep	read-multiple-tables.0: 1000 aggregate-multiple-tables.0: 1000	✅

Game:

⚠️ There is no game in this workout.

8. database-clients

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	connection-strings	✅	💪 workout	connect-client.0: 10 connect-client.1: 10 connect-client.2: 10 connect-client.3: 10	✅	✅	❌	✅
2	gui-client	✅	💪 workout	connect-client.0: 10 connect-client.1: 10	✅	✅	❌	✅
3	command-line-client	✅	💪 workout	connect-client.0: 10 connect-client.1: 10	❌	❌	❌	❌
4	python-database-packages	✅	💪 workout	connect-client.0: 10 connect-client.1: 10	✅	✅	❌	✅
5	node-database-packages	✅	💪 workout	connect-client.0: 10 connect-client.1: 10	✅	✅	❌	✅
6	java-database-packages	✅	💪 workout	connect-client.0: 10 connect-client.1: 10	✅	✅	❌	✅

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

Standards

✅ - At least one insight covers this

❌ - Nothing covers this

🛠️ - This standard has no objectives yet

✅ Connect a database client to a database server

0. ✅ Connect any database client to a database server on a local host
1. ✅ Connect any database client to a database server on a remote host
2. ✅ Break down connection URLs into their component elements (protocol, hostname, credentials, port, database name, etc)
3. ✅ Assemble connection URLs from component elements

❌ Write queries to read data from single tables

0. ❌ Use the SELECT command to get data from a table
1. ❌ Use the WHERE clause to filter rows of data from a table
2. ❌ Filter the columns returned by a SELECT command
3. ❌ Use the ORDER BY command to sort a result set by the value of a column, or multiple columns

❌ Write queries to read data from multiple related tables

0. ✅ Use INNER, LEFT, RIGHT, OUTER, and JOIN to relate data across multiple tables
1. ✅ Write a query to relate two tables using a join table
2. ❌ Write a query to relate a table to itself using a join table

❌ Write queries to aggregate data from a single table

0. ✅ Use the COUNT, SUM, AVG functions to reduce a set to a single value
1. ✅ Use the MAX, MIN functions to search for the boundaries of set of data
2. ❌ Combine multiple columns' values in the aggregation of a set of data
3. ✅ Use GROUP BY to aggregate data in subsets of data

❌ Write queries to aggregate data from multiple related tables

0. ❌ Aggregate data using the GROUP BY statement and the COUNT, SUM, and AVG to collate information across related tables
1. ❌ Use MAX and MIN to look at the boundaries of a subset of data that is distributed across multiple tables
2. ❌ Use columns from related tables to aggregate a compound value

❌ Write queries to insert, update or delete data in a single table

0. ✅ Insert a single row of data using the INSERT command
1. ❌ Insert multiple rows of data using the INSERT command
2. ❌ Populate a table with the INSERT INTO command
3. ✅ Update 1 or more columns of data with the UPDATE command
4. ❌ Use a WHERE clause with the UPDATE command to conditionally update rows of data
5. ✅ Delete data with the DELETE command
6. ❌ Use a WHERE clause with the DELETE command to conditionally delete rows of data

Aspects

Given the insights are tagged with aspects, we can filter over the linear content progression and create learning sub-paths.

These sub-path progressions will most likely not cover all content, but they will ensure and enforce an unified learning experience, tailor for the user wish.

For example, a user might be interested in new additions and updates of a language, rather than introduction lessions. Note that these sub-paths don't take games into consideration

👶 Introduction

If you are being introduced to the topic for the first time

Insights:

1. what-is-sql
2. why-learn-sql
3. how-to-use-sql
4. sql-your-first-query
5. select-structure
6. select-columns
7. select-where-1
8. select-where-2
9. select-with-as
10. where-with-and
11. sql-more-operators
12. sql-not-example
13. sql-order-by
14. sql-order-by-advanced
15. insert
16. update-clause
17. delete-clause
18. inner-join
19. left-and-right-joins

Exercises:

1. sql-practice-insert
2. sql-practice-update
3. sql-practice-delete
4. sql-practice-aggregate-single-table
5. sql-practice-aggregate-single-table-2
6. sql-practice-aggregate-table-min-and-max
7. sql-practice-aggregate-table-max-filter
8. sql-practice-aggregate-group
9. sql-practice-aggregate-average

⚠️ There are no games tagged with this aspect in dql.

💪 Workout

Theory put into practice/that’s how you achieve X points

Insights:

1. select-with-as
2. where-with-and
3. sql-more-operators
4. sql-not-example
5. in-like-between-intro
6. sql-like
7. sql-between
8. sql-order-by
9. sql-order-by-advanced
10. insert
11. update-clause
12. delete-clause
13. group-by-clause
14. sum-clause
15. count-clause
16. min-and-max-clauses
17. distinct-clause
18. avg-clause
19. inner-join
20. left-and-right-joins
21. full-join
22. multiple-joins
23. union
24. connection-strings
25. gui-client
26. command-line-client
27. python-database-packages
28. node-database-packages
29. java-database-packages

Exercises:

1. sql-practice-update
2. sql-practice-delete
3. sql-practice-aggregate-single-table
4. sql-practice-aggregate-single-table-2
5. sql-practice-aggregate-table-min-and-max
6. sql-practice-aggregate-table-max-filter
7. sql-practice-aggregate-group
8. sql-practice-aggregate-average
9. sql-practice-join-multiple-tables
10. sql-practice-average-aggregate-multiple-tables
11. sql-practice-max-aggregate-multiple-tables
12. sql-practice-min-max-multiple-tables

⚠️ There are no games tagged with this aspect in dql.

🦑 Deep

Prerequisite knowledge consisting of 2 or more 👶/💪 workouts

Insights:

1. full-join
2. multiple-joins
3. union

Exercises:

1. sql-practice-aggregate-single-table
2. sql-practice-aggregate-single-table-2
3. sql-practice-aggregate-table-min-and-max
4. sql-practice-aggregate-table-max-filter
5. sql-practice-aggregate-group
6. sql-practice-aggregate-average
7. sql-practice-join-multiple-tables
8. sql-practice-average-aggregate-multiple-tables
9. sql-practice-max-aggregate-multiple-tables
10. sql-practice-min-max-multiple-tables

⚠️ There are no games tagged with this aspect in dql.

✨ New

Recently added/gained traction feature

⚠️ There are no insights tagged with this aspect in dql. :warning: There are no exercises tagged with this aspect in dql. :warning: There are no games tagged with this aspect in dql.

🔮 Obscura

Stories, obscure details that don’t specifically relate to a learning objective

⚠️ There are no insights tagged with this aspect in dql. :warning: There are no exercises tagged with this aspect in dql. :warning: There are no games tagged with this aspect in dql.

✅ All content has been tagged with aspects.