Uses aggregates to apply expressions over groups of solutions (GROUP BY, COUNT, SUM, AVG, MIN) for partitioning results, evaluating projections, and filtering. – Linked Data for Professional Education https://ld4pe.dublincore.org Learning resources tagged by competency Thu, 19 Nov 2020 14:45:03 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.16 SPARQL and Linked Data Homework Exercises https://ld4pe.dublincore.org/learning_resource/sparql-and-linked-data-homework-exercises/ Sat, 21 Jan 2017 06:46:40 +0000 https://ld4pe.dublincore.org/learning_resource/sparql-and-linked-data-homework-exercises/ This document contains several "written" and "electronic" homework questions originally from the course "Semantic Web Topics" at LeHigh University. They include: Write a series of SPARQL queries using a provided schema; Write a SPARQL construct query that generates all triples inferred by a specific RDFS entailment rule; Write a SPARQL construct query to generate
owl:sameAs statements between domains which share specified property; Describe the pros and cons of generating links in the manner specified in the previous question; Using Jena, create a class that can read in all the files in a specified directory and create a Web page that lists a series of publications organized by topic – reading all of the files into a single model and only using SPARQL to retrieve information from the model.

URL: http://www.cse.lehigh.edu/~heflin/courses/sw-2013/hw2.pdf
Keywords: SPARQL, RDF Schema, Entailment regime, Apache Jena, Java
Author: Heflin, Jeff
Date created: 2013-02-01 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P4H
Educational use: assessment
Educational audience: teacher-educationSpecialist
Interactivity type: active

]]>
All Roads Lead To? Experiments With Gephi, Linked Data and Wikipedia https://ld4pe.dublincore.org/learning_resource/all-roads-lead-to-experiments-with-gephi-linked-data-and-wikipedia/ Sat, 14 Jan 2017 06:46:01 +0000 https://ld4pe.dublincore.org/learning_resource/all-roads-lead-to-experiments-with-gephi-linked-data-and-wikipedia/ This blog post shares an example using the Semantic Web Import plugin (available for the Gephi visualization tool) to create a rather complex geospatial visualization. This tutorial also includes good information on how to explore a dataset using SPARQL queries and how to filter query results to "clean-up" DBpedia data so that it is more suitable for use.

URL: https://johngoodwin225.wordpress.com/2014/03/26/all-roads-lead-to-experiments-with-gephi-linked-data-and-wikipedia/
Keywords: Gephi, DBpedia, Geospatial data, SPARQL
Author: Goodwin, John
Date created: 2014-03-26 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P20M

]]>
Querying the Linked Archives Hub data using SPARQL https://ld4pe.dublincore.org/learning_resource/querying-the-linked-archives-hub-data-using-sparql/ Sat, 16 Jan 2016 13:43:28 +0000 https://ld4pe.dublincore.org/learning_resource/querying-the-linked-archives-hub-data-using-sparql/ This blog post provides a few sample SPARQL queries that can be used as a starting point for exploring an unfamiliar dataset. The queries are intended to give users an idea of what is possible and a platform to build on. The dataset used in these examples is LOCAH archival data which, like most archives, is hierarchically organized into collection level and sub-levels.

URL: http://locah.archiveshub.ac.uk/tag/sparql/
Keywords: Archives, Dataset, RDF, SPARQL endpoint, SPARQL
Author: Petej
Publisher: LOCAH Project
Date created: 2011-05-10 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P30M

]]>
SPARQL Examples for the DCMI/ASIS&T Webinar https://ld4pe.dublincore.org/learning_resource/sparql-examples-for-the-dcmiasist-webinar/ Sat, 16 Jan 2016 13:43:28 +0000 https://ld4pe.dublincore.org/learning_resource/sparql-examples-for-the-dcmiasist-webinar/ These gits were created to demonstrate the SPARQL examples used in the DCMI/ASIS&T webinar, "From 0 to 60 on SPARQL queries in 50 minutes". Each git contains a fully-functional SPARQL query which can be copied and pasted into a SPARQL endpoint and successfully retrieve results. They can also be deconstructed to demonstrate a variety of useful techniques, as well as the functions of various SPARQL operators.

URL: http://numishare.blogspot.com/2015/05/sparql-examples-for-dcmiasis-webinar.html
Keywords: SPARQL
Author: Gruber, Ethan
Publisher: Nomisma.org
Date created: 2015-05-13 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M
Educational use: instruction
Educational audience: student
Interactivity type: active

]]>
XQuery/SPARQL Tutorial https://ld4pe.dublincore.org/learning_resource/xquerysparql-tutorial/ Sat, 16 Jan 2016 13:43:28 +0000 https://ld4pe.dublincore.org/learning_resource/xquerysparql-tutorial/ This page shows how to access a SPARQL endpoint using an interface provided by Talis. Potentially more valuable, it also provides several dozen example queries, including those covering: Abbreviated query syntax; Aggregate features; Generic queries; and Schema queries.

URL: https://en.wikibooks.org/wiki/XQuery/SPARQL_Tutorial
Keywords: SPARQL, SPARQL endpoint, XQuery, Talis
Publisher: Wikibooks
Date created: 2014-03-26 04:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P1H

]]>
Querying Linked Data https://ld4pe.dublincore.org/learning_resource/querying-linked-data-2/ Tue, 15 Sep 2015 02:33:09 +0000 https://ld4pe.dublincore.org/learning_resource/querying-linked-data-2/ This presentation looks in detail at SPARQL and introduces approaches for querying and updating semantic data. It covers the SPARQL algebra, the SPARQL protocol, and provides some examples for reasoning over Linked Data.
This video is part of a larger Euclid Project module which uses examples from the music domain, which can be directly tried out and ran over the MusicBrainz dataset.

URL: http://videolectures.net/eswc2013_hogan_linked_data/
Keywords: SPARQL, CRUD
Author: Hogan, Aidan
Publisher: videolectures.net
Date created: 2013-11-05 05:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M
Educational use: instruction
Educational audience: student
Interactivity type: mixed

]]>
0 to 60 on SPARQL queries in 50 minutes https://ld4pe.dublincore.org/learning_resource/0-to-60-on-sparql-queries-in-50-minutes-2/ https://ld4pe.dublincore.org/learning_resource/0-to-60-on-sparql-queries-in-50-minutes-2/#respond Thu, 13 Aug 2015 14:33:32 +0000 https://ld4pe.dublincore.org/learning_resource/0-to-60-on-sparql-queries-in-50-minutes-2/ This links to the PDF version of Ethan Gruber's webinar, which provides an introduction to SPARQL, a query language for RDF. Users will gain hands-on experience crafting queries, starting simply, but evolving in complexity. These queries will focus on coinage data at the SPARQL endpoint hosted by http://nomisma.org with numismatic concepts defined in a SKOS-based thesaurus and physical specimens from three major museum collections linked to these concepts. Results generated from these queries in the form of CSV may be imported directly into Google Fusion Tables for immediate visualization in the form of charts and maps.

URL: https://www.academia.edu/8014017/0_to_60_on_SPARQL_queries_in_50_minutes
Keywords: Geographic queries, SPARQL, Map geolocations
Author: Gruber, Ethan
Date created: 2014-08-01 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P60M
Interactivity type: mixed

]]>
https://ld4pe.dublincore.org/learning_resource/0-to-60-on-sparql-queries-in-50-minutes-2/feed/ 0
Introduction to SPARQL https://ld4pe.dublincore.org/learning_resource/introduction-to-sparql/ https://ld4pe.dublincore.org/learning_resource/introduction-to-sparql/#respond Thu, 13 Aug 2015 03:26:20 +0000 https://ld4pe.dublincore.org/learning_resource/introduction-to-sparql/ A simple (yet thorough) introduction to SPARQL query language based on the W3C documentation. Focuses on aspects of the query language present in SPARQL 1.0 and does not include features added in SPARQL 1.1 Update.

URL: http://www.slideshare.net/szeke/introduction-to-sparql?next_slideshow=2
Keywords: SPARQL, Negation, BIND
Author: Szekely, Pedro
Date created: 2013-05-21 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P45M
Educational use: instruction
Educational audience: professional
Interactivity type: expositive

]]>
https://ld4pe.dublincore.org/learning_resource/introduction-to-sparql/feed/ 0
Simple SPARQL Tutorial: Using SUM and AVG https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-using-sum-and-avg/ https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-using-sum-and-avg/#respond Thu, 13 Aug 2015 03:26:19 +0000 https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-1929-using-sum-and-avg/ Building on the previous tutorial in the series and its discussion of the COUNT keyword, this tutorial explains several other mathematical functions of SPARQL queries. Using SUM to add together all the values that are bound to the variable that is passed to it.

URL: https://www.youtube.com/watch?v=-Ld0bddQmfU
Keywords: SPARQL
Author: Sadawi, Noureddin
Date created: 2014-03-03 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P5M
Educational use: instruction
Educational audience: professional
Interactivity type: mixed

]]>
https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-using-sum-and-avg/feed/ 0
Simple SPARQL Tutorial: Counting with COUNT https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-counting-with-count/ https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-counting-with-count/#respond Thu, 13 Aug 2015 03:26:18 +0000 https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-1829-counting-with-count/ Tutorial explaining how the COUNT keyword allows one to determine the number of triples present in a dataset. Also shows how to use COUNT to determine in how many instances a variable is bound to a specific value.

URL: https://www.youtube.com/watch?v=fHoYujF-UHM
Keywords: SPARQL
Author: Sadawi, Noureddin
Date created: 2014-03-03 07:00:00.000
Language: http://id.loc.gov/vocabulary/iso639-2/eng
Time required: P10M

]]>
https://ld4pe.dublincore.org/learning_resource/simple-sparql-tutorial-counting-with-count/feed/ 0