Category: SQL

After a series of workshops

Introduction to SQL Session
Introduction to SQL Session

We had a series of workshops in Istanbul Hackerspace about SQL and PL/SQL. Sessions are held by me, and there were three sessions, each focuses on another topic.

 

 

Our road map was:

  •  Introduction to SQL
  •  Introduction to PL/SQL
  •  Introduction to PL/SQL tuning & Oracle catalog tables.

You can find the material I’ve prepared for these workshops on http://www.canburaktumer.com/istanbulhs For me, these session were useful and succesful. I did not break the Istanbul Hackerspace tradition and had a decreasing number of participants. First day we had six participants, second day we had three participants and finally last day it was only me.

By the way, I also would like to introduce about hackerspace concept and Istanbul HS. Hackerspaces are world wide “free project ateliers”. They are basically producing projects with electronics and software. You can see a full list of hackerspaces on hackerspaces.org There are two hackerspaces in Istanbul, one in Anatolian side and one in European side. I am a volunteer in the Anatolian side, we are running an Android application project now, and we are having workshops. You can find more info on istanbulhs.org in Turkish.

That’s all for today, keep following because ODI posts will continue to come.

Test your SQLs online

Nowadays I am trying to answer questions about SQL, PL/SQL and Oracle on StackOverflow . You can see my profile card below :

 profile for Canburak Tümer at Stack Overflow, Q&A for professional and enthusiast programmers

Recently I am seeing a new web site link in answers, while I am navigating through as much questions as possible. That site called SQLFiddle where you can create an online database and try your codes.

Screenshot from web site
Screenshot from web site

As you can see above it is pretty simple, and it is really easy to use. There is different products and different versions for some products you can choose between. While I am writing this post, exact list was like below:

  • MySQL 5.5.30
  • MySQL 5.6.6 m9
  • MySQL 5.1.61
  • Oracle 11gR2
  • PostgreSQL 9.1.8
  • PostgreSQL 9.2.1
  • PostgreSQL 8.4.12
  • PostgreSQL 8.3.20
  • SQLite (WebSQL)
  • SQLite (SQL.js)
  • MS SQL Server 2008
  • MS SQL Server 2012

Jake Feasel, creator of SQLFiddle, explains why he built the site as :

I found JS Fiddle to be a great tool for answering javascript / jQuery questions, but I also found that there was nothing available that offered similar functionality for the SQL questions. So, that was my inspiration to build this site. Basically, I built this site as a tool for developers like me to be more effective in assisting other developers.

How to use

So let’s talk about how to use SQLFiddle,

First of all, you select the product you want to use from combo box on top-left corner, next to site logo. Then you should create your schema, in left editor you can create tables and insert data to your tables. When you are done with coding click Build Schema button to run your code. Now you have your tables and data. You can write your queries in the right editor and run them. Results will appear below editors.

Limitation 

There is a limitation with MySQL, that Jake Feasel explains in About page. On the right editor you can only use select if you are using MySQL, with other products feel free to use all DML operations.

Login

There are around 12 different log-in options like G+ and OpenID. When you login to site, you can see your Fiddle history, and your favorite fiddles. There is no other advantages of logging in yet.

That’s all for today. Do not hesitate to comment.

P.S. I am preparing new ODI post but I am really busy with my work these days. So follow my blog for updates.