ActiveSQL. Sakila Sample Database :: 4 Installation. SQL Fiddle. Execute SQL Script Online. 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.
Query: sql - Google Fusion Tables API. 3 Tutorial. Employees Sample Database :: 4 Employees Structure. Employees Sample Database :: 2 Installation. Setting Up the world Database. SQL Tutorial. Learn SQL The Hard Way An Introduction To The Most Popular And Least Loved Data Language In The World. Learn SQL The Hard Way Python | Ruby | C | Regex Learn SQL The Hard Way Table Of Contents Frequently Asked Questions How long does this course take?
You should take as long as it takes to get through it, but focus on doing work every day. What kind of computer do I need? You will need either a Windows, OSX or Linux computer to complete this book. Copyright (C) 2010 Zed. Credits.