SPARQL in 11 minutes

[@8bullets946]

Life was much easier 11 minutes ago. Kudos to the guy who invented this thing!!

[@MarkW2711]

Best intro to SPARQL have found, especially love the sound when generating the result from the query

[@BobDuCharme]

Thanks! I love my Korg Monotron Duo. Small size, small price, but still a proper old-school analog synth. If you listen closely you can hear that I made it pan from left to right (or right to left, depending on your setup). Korg's video about it: kzbin.info/www/bejne/rYivgKuIiNGfa7M

[@jeremygiaco]

I'm just laughing that "SPARQL" is the first word in the acronym, "SPARQL"

[@ChrisLuigiTails]

Recursion. Like the "B" in "Benoit B. Mandelbrot" stands for "Benoit B Mandelbrot".

[@charliepank528]

@@ChrisLuigiTails "WINE" stands for Wine Is Not an Emulator; "PINE" stands for Pine Is Not Elm and so on...

[@MindlessZombie2006]

@@charliepank528 And GNU is Not Unix :D

[@lorenzogabriele9533]

Recursive names are a pretty common practice in CS actually :-)

[@mariuseza812]

So the S has to have a greater meaning then just recursion

[@web3js]

Watching this at 4:43 am, and I have a presentation at 3:00pm . I have never been so proud of my procrastination attribute before.

[@malighos]

I have an exam tomorrow at noon where 1 question is just SPARQL and this is the first time I am seeing this. Gonna nail that shit :D

[@moonisali5296]

@@malighos I have an assignment submission on Saturday and believe me, I feel how it is. #Bliss

[@kayicomert7933]

How were you in the presentation? :D

[@ahmedboulahia6033]

@@malighos did you nailed it?

[@raghadmadwar8440]

Hello ,, it's meee :v ,, i have exam tomorrow :v

[@christbool]

Simplest video about SPARQL ever

[@momirgjorgjevski517]

The best short video explanation for sparql. Thanks!

[@robertbevington7548]

I looked at a number of explanations, but just could not get to grips with it. Watched your video, and now I understand the basics of SPARQL. Thanks.

[@Dylan-qk8ss]

You explained the basics of SPARQL very well. I appreciate the time you put into this video, and I plan on buying your book.

[@instaminox]

did you get his book?

[@VinniModi]

The most simple, effective and very nicely explained

[@abcd95489]

It took me 2 days to understand this 11 minutes video. But it cover all basics of sparql. Thank you.

[@charlottec.8168]

I bought the book!!! Looking forward to learning more SPARQL. Thanks for the intro.

[@suneelkanuri]

This is a excellent introduction to SPARQL. If I end up working more with it, I will definitely consider buying your book. Thank you.

[@lqv3223]

This channel is underrated.

[@hsli9003tube]

An Intro Video can not get much better than this. Thanks to the video creator.

[@yazzalashqur5988]

Extremely useful, clear, and to the point. Thank you very much!

[@BernadetteHyland]

Excellent overview of SPARQL and precursor to printed resources from the expert who wrote the O'Reilly book "Learning SPARQL". Well done Bob DuCharme

[@henryforbes4483]

Saved my Uni Degree thank you

[@SindhuraKatta]

One of the best tutorials I came across online! Thanks so much!

[@amitadhikaree1801]

Great Introduction video!!

[@GelsYT]

what exactly is the URI? can I create my own URI? or do I have to somehow base on something?

[@BobDuCharme]

You can create your own. It's best to base it on a domain name that is under your control, so that for example if you create the URI myuri.org/vocab/dog to represent a dog you can actually put some data there (in which case it will then be a URL!)

[@lisabos1159]

Very nice job, Bob, sharing with my colleagues.

[@FarizDarari]

Thanks for the tutorial! Was just wondering though at 8:10 the NOT EXISTS expression is written without FILTER (q7.rq). Would this be ok generally? As far as I understood, at least the Wikidata SPARQL endpoint requires the FILTER keyword along with NOT EXISTS.

[@BobDuCharme]

Very good point. In a quick test I see that Wikidata does seem to require the FILTER keyword before NOT EXISTS and arq doesn't. I couldn't follow the official grammar at www.w3.org/TR/sparql11-query/#sparqlGrammar well enough to find an answer there, but I did find www.w3.org/2009/sparql/wiki/Design:Negation#Syntax, which says that "The keywords EXISTS and NOT EXISTS can be used both inside and outside FILTERs."

[@Dylan-qk8ss]

Second time watching this great video, thanks.

[@mathematicsfreelancer]

Very nice explanation.

[@dimitheodoro]

Where can we find the basic table (showing in 02:28 )?what is it's name??

[@BobDuCharme]

I put a turtle file with those triples at learningsparql.com/2ndeditionexamples/sparqlIn11Minutes.ttl.

[@supersonic956]

That sound effect is certainly not obnoxious.

[@_3nlil]

lmao

[@naeemqaswar5037]

It's well explained. Nice work bro !

[@nickroberts2219]

Thank you, this was a really good description of RDF as well

[@MrJulichus]

u saved my exam

[@georgehumphrey7178]

Does anyone know of a free environment to develop RDFs in?

[@astucieuxzephyr]

protege.stanford.edu/

[@johnblue]

Does a URI, like your example "www.snee.com/hr/hireDate" have to be a live URL, or is the URI truly just a namespace and identifier? Another way to ask this is if I have some data on some media presentations, like controlName (an internal identifier for our uses, examples include 160607_wpx_becton, 160607_wpx_smith, and 160607_wpx_jones), and I need to create a URI, can I use any thing for the URI (like our web address www.trufflemedia.com) plus some identifier info to create a URI like this "www.trufflemedia.com/presentation/160607_wpx_becton"? What happens to URIs that use live URL addresses and then those domains are shut down. For example, if, in a dataset, I use a URI like "www.trufflemedia.com/presentation/160607_wpx_becton" and then the "www.trufflemedia.com" domain is shut down, is the URI still valid? thx, very helpful SPARQL info.

[@bobdc]

It doesn't have to be a URL. It's just an identifier. The Linked Data movement stresses the value of making it a dereferenceable URL, so that is even better. If the domain is shut down, the URI still functions as an identifier, but obviously won't be a Locator any more if there's nothing at that location.

[@rimaben2120]

So we can make a conclusion to make it logically clear; that SPARQL "where" {....} instruction rely all the conditions inside it with "AND" by default, and to make it OR for some certain condition, we just put "optional" before it. Please tell me if I'm wrong..

[@bobdc]

That is correct. Just be careful with OR because it's asking the query engine to do a lot more scanning, which can slow things down. See www.bobdc.com/blog/dropping-optional-blocks-from/ for more.

[@adriangg9018]

The SPARQL query processor sound is so absurd that its awesome xddddd

[@BobDuCharme]

Thanks! That's my Korg Monotron Duo.

[@bartkl]

Very useful, thanks a lot

[@abhay.sharma]

Wow !! Nice job man . good explanation

[@vickyshrestha]

Simple and sleek 👍

[@mathematicsfreelancer]

thank you sir !

[@PabloBianchiOK]

Please consider enabling the video for community contribution to add subtitles translations.

[@barkohavi535]

hi, can you please explain why can't we use "vcard" for "hiredate" and for "completeorientaion" ? you said that those properties are not available in vcard and we didn't understand why- what is the reson thanks a lot!!

[@bobdc]

+Bar Kohavi See the vcard ontology at www.w3.org/TR/vcard-rdf/ . You'll see that hireDate and completedOrientation are not part of the vcard vocabulary, so I had to make up new URIs for them, which is very easy in SPARQL.

[@studyselection2881]

Good Video.

[@emperoy8]

You posted only one video????????

[@KingGJT]

Thanks Bob!

[@rosaricci2225]

HI! Thanks very much for this video. Can you suggest a tool to verfy if the request is correct!?

[@ambicakondeti4494]

Great video

[@thekatyperrymemechannel2122]

That song at the end rocks xD

[@bobdc]

Thank you very much! I did the piano and drums with a scoring program (the parts are simple enough that I could have played them for real, but miking those well would be a pain) and then I played acoustic rhythm guitar, electric lead guitar and electric bass.

[@maclovesgeet]

super easy to follow.. thanks for this vedio

[@diegoyamada1994]

Thanks for the excellent presentation. Just a question, can the results of these queries be considered inferences?

[@bobdc]

Good question. The result of CONSTRUCT queries, which are new triples, can work as inferences. See www.bobdc.com/blog/materializing/ for more.

[@Joy-rg9qn]

Is there a great source to learn GeoSPARQL?

[@TheMaldingZucchini]

Amazing video, but I gotta ask something. How is RDF used?? We have to write an RDF file from the content we have written for example in a news website or is it generated automatically by the computers. Or is it something we only make for important stuff like Chemistry fromulas ?? I'm lost

[@bobdc]

It's popular for the metadata of content, especially when using the JSON-LD syntax, so that would be good for a news website. See www.bobdc.com/blog/json-ld/ for more on JSON-LD. (I will fix the screwy syntax highlighting in the examples sometime tomorrow.)

[@TheMaldingZucchini]

@@bobdc thank you ^___^

[@gelareh8826]

super useful thanksss!

[@jeroenbos413]

Thanks, this was very helpful!

[@saikiransimple]

bro, without inserting, how you are getting the data?

[@BobDuCharme]

That depends on the query engine. For example, with Jena arq, on the command line you specify the query file and the data file to run it against.

[@tupacca5136]

Aww, it's just a crummy advertisement? jk, very good, clear video for a total beginner.

[@paulhernandezgermany]

Great tutorial, thanks!

[@YogeshPatilTheAlchemist]

very nice video. Thank you

[@Joy-rg9qn]

Dear Sir, currently I am trying to create a website about Linked Data for my internship. I found your video very helpful in explaining, therefore I was wondering whether it would be okay to embed this video on my website. The website has informative purposes

[@BobDuCharme]

Sure

[@smtzac002]

Thank you - this is a very helpful video. I disagree that it's difficult to store a 'second completed orientation date' in such a table though (or that SPARQL makes this concept easier) (kzbin.info/www/bejne/fKeqn5ehpcZngZI). That is an implementation of SPARQL that is separate to how the query is phrased in itself. That threw me off the first couple times that I watched this video, as I couldn't figure out what you meant. in sql it's also easy to 'phrase' that same insertion statement: "insert into table values (emp1, engineer, date1), (emp1, engineer, date2);". And that would be fine in a denormalized table.

[@serapissarapis3730]

thx u so much you made my day :)

[@4umata]

Nice video, thank you for explaining this! Next time could you please go easy on that sound effect when you run a query, it gets really old really fast.

[@arifazizi4869]

thanks, really help full

[@hugopristauz3620]

great job!

[@waneneha]

Thanks a lot!

[@TheDilusha100]

this helped. thanks

[@hichamkazan9511]

Running a query sounds epic :p

[@BobDuCharme]

Thanks! That's my Korg Monotron Duo (with stereo panning!)

[@csikhlo1741]

Thank you...

[@yoonyati8892]

အသစ်ဆုံးပထမ

[@akbarkazimov8486]

bravo

[@faizvp6626]

SPARQL sucks. Looks like it was written by someone who doesn't know how SQL works. But thank you for the video. It will make it more easier if you explain what each keyword does and even make a comparison with SQL. For instance SELECT... FROM... WHERE... GROUP BY.. HAVING.. ORDER BY.. structure in SQL simplifies the selection, sourcing, filtering, aggregation, post aggregation filtering and sorting. What will be the equivalent of that in SPARQL. How is a WHERE in SQL is different (ex: order of conditions is irrelevant vs sequential filtering in SPARQL)..

[@DavidGarcia-xt5rq]

I love you

[@stuffedk]

the URI thing is dumb

[@migueldias1292]

fuk yeah

[@vuger01]

.

[@henca00]

Who the fuck uses this ? lol

[@thanhbuivan4416]

Great video! Thank you so much