background preloader

Coding

Facebook Twitter

The column-store pioneer | MonetDB. Asdfree by anthony damico. Interactive tutorial on SQL. SQLZOO. Learn SQL using: SQL Server, Oracle, MySQL, DB2, and PostgreSQL. Reference: how to... How to read the data from a database. 2 CREATE and DROP How to create tables, indexes, views and other things. How to get rid of them. 3 INSERT and DELETE How to put records into a table, change them and how to take them out again. 4 DATE and TIME How to work with dates; adding, subtracting and formatting. 5 Functions How to use string functions, logical functions and mathematical functions. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. 7 Meta Data How to find out what tables and columns exist. 8 SQL Hacks Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly 9 Using SQL with PHP on Amazon EC2 servers Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers. 10 An introduction to transactions Video tutorials showing how sessions can interfere with each other and how to stop it. 11 Using SQL with C# in Visual Studio.

Www.iki.fi/sol - Tutorials - GalaXQL. Who said SQL tutorials have to be boring? Try out GalaXQL 3.0 beta! Runs on your browser. Note: heavy javascript and webgl. Needs a modern browser. Quotes / Testimonials "Incidentally, we've trained several students to be web developers using only your tutorial for SQL instruction--great work! " -- Dr Christopher Pound, Rice University "I have been looking for a good way to show SQL to analysts who need to learn it and this by far the best tool I have ever come across. " -- Julie LeMay, DELL "Noodling with GalaXQL is the most fun database tutorial I've ever seen. -- Joey deVilla at Tucows' "the farm" "Much more entertaining and freeform than ordinary attempts at tutorials, certainly exciting!

" -- Thomas Van Der Pol "I've just completed your tutorial and was very impressed! -- Stephed Bridges "[GalaXQL] rocks! -- Reuben Grinberg in his blog GalaXQL is an interactive SQL tutorial. GalaXQL 1.0 Virtual teacher (win32) GalaXQL 1.0 Virtual teacher (mac os x) Follow the instructions by your virtual teacher. Python Programming Language – Official Website. Python. Tableau Training.