artfulsoftware.com
Database Resources on the Web
http://www.artfulsoftware.com/dbresources.html
Database Tutorials on the Web. Database design and Normalisation. From Artful Software Development. Ten steps to design a database. From Artful Software Development. Gentle introduction to SQL. Very clear SQL step-by-step. Database design summary from Wikipedia. SQL statement syntax in MySQL. By Oscar Zaiane at SFU. SQL Articles at ONLamp. Database basics in 5 parts by Joe Burns. For the mathematically minded. Introduction to relational databases by Tore Bastrup. For the mathematically minded.
geekroom.tibetangeeks.com
Start here for SQL .:. Geek Room
https://geekroom.tibetangeeks.com/resources/res4begin-sql
Start here for SQL – Geek Room. A tech stop for locals in mcleod ganj. ཟབ ས ང ཁང. Using the geek room. Learn to code online. Blocked in china and tibet. How to keep up. Start here for SQL updated 6 Jul 2016. Here are some good places to start when you are learning how to write SQL to access databases. 8220;SQL” is the letters for “Structured Query Language”, so it is pronounced “Ess-Que-Ell” — not “See-Quell”. Learn SQL syntax. Nice! Nice interactive tutorials. KhanAcademy.com. It is about doing. All: We...
hedykorbee.wordpress.com
Excellent advice on data journalism for those of us who don’t code | Hedy Korbee
https://hedykorbee.wordpress.com/2011/03/17/excellent-advice-on-data-journalism-for-those-of-us-who-dont-code
Adventures in online journalism. Community news sites: “make the obscure findable”. A Thread to the Past in Birch Cliff →. Excellent advice on data journalism for those of us who don’t code. March 17, 2011. I decided to try the direct approach by emailing Michelle Minkoff. After reading her tweets and posts on the NICAR. Discussion forum because she seemed approachable and I could relate to her approach to data-driven storytelling at PBS:. Showing people what to look at. It’s very inspiring and has...
csszoo.net
XMLzoo: A Gentle Introduction to xml
http://www.csszoo.net/dtd2
A Gentle Introduction to xml. XMLzoo: A Gentle Introduction to xml. Planet Node: ATTLIST with CDATA and ID. We revisit the planet XML applications. This time we take a data oriented approach, most of the details are stored in attributes rather than as text. ATTLIST values ID and IDREF. We use ID attributes and reference them with IDREF attributes. ATTLIST #REQUIRED, #IMPLIED, defaults and enumerated types. We may define a % entity - this allows us to define fragments and reused them in our DTD.
briandupreez.net
Zen in the art of IT: December 2013
http://www.briandupreez.net/2013_12_01_archive.html
Zen in the art of IT. Sunday, December 15, 2013. Predicting the next most probable part of speech. I have recently been spending some of my spare time learning and about AI and machine learning , after a couple books, a bunch of tutorials and most of Andrew Ng's Coursera. Course. I decided enough with the theory, time for some real code. During all my late night reading I also stumbled across some of the following. The Loebner Prize. And it's most recent winner Mitsuku. So, for my first bit of functional...
briandupreez.net
Zen in the art of IT: July 2014
http://www.briandupreez.net/2014_07_01_archive.html
Zen in the art of IT. Saturday, July 19, 2014. TDD, Hamcrest, Shazamcrest. Recently we have started to try get a more TDD culture started at work, having always believed in thorough testing and decent code coverage it shouldn't have been too hard. However. teaching a old dog new tricks can sometimes require quite a bit of patience. Turns out breaking coding habits formulated of more than a decade of keyboard bashing is harder than it seems. One of the tools / libraries we have included is Hamcrest. Compa...
briandupreez.net
Zen in the art of IT: January 2014
http://www.briandupreez.net/2014_01_01_archive.html
Zen in the art of IT. Sunday, January 12, 2014. BYG (Bing, Yahoo, Google) Search Wrapper. One small section of my Aria project will be to interface with the current search engines out there. To do this I will require a module that will give me a consistent interface to work with the 3 main providers; Bing, Yahoo! And Google. (and any future ones I may want to add). This is a basic example or that module. First thing required is to set up accounts / projects and the like with the relevant providers. The i...
briandupreez.net
Zen in the art of IT: February 2014
http://www.briandupreez.net/2014_02_01_archive.html
Zen in the art of IT. Sunday, February 16, 2014. Local Wikipedia with Solr and Spring Data. Continuing with my little AI / Machine Learning research project. I wanted to have a decent sized repo of English text, that was not in a complete mess like a large percentage of data on the internet. I figured I would try Wikipedia, but what to do with about 40Gb of XML? Required for this example:. Warning it is a 9.9Gb file, extracts to about 42Gb). Great Blog / Examples on Spring Data: Petri Kainulainen's blog.
