I was given the opportunity to do a talk on the up coming CQL feature in Cassandra at the recent meet up. While it wasn't highly comprehensive I thought it went well, it was a very gentle intro to CQL which basically goes over the V1.0.0 syntax and usage... I post the full CQL V1 specification previously.
I recorded and uploaded my presentation after getting a few e-mails regarding the skills matter site below. You can watch the video here or on their website, if you get a "bandwidth exceeded" or a long page load and the player doesn't load then you can always watch it on here or over at vimeo http://www.vimeo.com/25815106 [vimeo http://www.vimeo.com/25815106 w=400&h=300]
The video is available on the skills matter site @ http://skillsmatter.com/podcast/nosql/introduction-to-cql
The slides are up on slideshare @ http://www.slideshare.net/shotaz/cql-cassandra-query-language