background preloader

SQLZOO

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

http://sqlzoo.net/wiki/SQL_Tutorial

Related:  Programacion

a friendly place for Java greenhorns - Certification Info JavaRanch Certification Info To pass the SCJP you must: You gotta read books; you gotta write some code. Give yourself 3 months (less if you're a C++ programmer). Get some examples from the CodeBarn, and stories at the Campfire. Instant SQL Formatter Plugin for Notepad++UltraEditeclipse1.1KShare Instant SQL Formatter (Ver4.0.2 Updated: 09-19-2014) Database Output: Meaning of Halflife I'd like to illustrate what this really means. If living creatures had halflives the way radioactive atoms do, the world would be a very different place. What do you mean? Suppose there's an alien species with a halflife of, say, 70 years. You randomly pick out 16 baby aliens and track them to see how long they live. After 70 years, of course, 8 of them will still be alive.

GNAT Programming Studio What is GPS? GPS, the GNAT Programming Studio, is a cutting-edge Free Software IDE that streamlines the interaction between developers and their software. With its intuitive interface, GPS is easy to use, simplifying source navigation and highlighting the fundamental ideas in the program. By displaying core application structures, such as call graphs, program entity graphs, and project dependencies, GPS facilitates the development of systems. ceriousproductions Changelog and Updates The following websites were part of the original list but they are either no longer available or have been replaced with better alternatives. 327k Shares

Ada Style Guide Ada Quality and Style Guide Guidelines for Professional Programmers Contents[edit] Free textures for your next web project. Nothing like a field of beautiful flowers. Download Download These lovely water-colorful dots will make your designs pop.

The Math Forum @ Drexel University The Math Forum has a rich history as an online hub for the mathematics education community. A debt of gratitude is owed to the dedicated staff who created and maintained the top math education content and community forums that made up the Math Forum since its inception. NCTM will continue to make many of the most popular parts of the Math Forum content accessible to the mathematics education community. We hope that you will join or continue to be a member of the NCTM community to access even more high-quality resources for teaching and the learning of each and every student.

Related:  Programmation / Développement