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

10 Sitios interactivos para aprender a programar online Hoy en día las ventajas que brinda Internet nos permiten acceder a conocimientos que antes llegaban solamente a un selecto grupo de personas por sus altos precios. Por lo tanto todos los que quieran aprender a programar o profundizar en un determinado lenguaje de programación podrán hacerlo fácilmente desde algunos de estos 10 sitios interactivos que encontrarán a continuación. Son 10 páginas web educativas con lecciones instantáneas e interactivas para aprender lenguajes de programación como HTML, CSS, PHP y Ruby entre otros. Espero que encuentren un curso a medida de sus necesidades y si quieren pueden recomendar o sugerir otros recursos. También lee: 12 Sitios para descargar AudioLibros gratis en varios idiomas 1.

fcamuso Vuoi diventare uno sviluppatore di software ma non sai da cosa cominciare. Qui troverai centinaia di video organizzati in playlist e percorsi per: - sviluppatori WEB: sviluppatori Desktop: sviluppatori 'mobile': sviluppatori games: 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. 6 Sitios para aprender de todo desde Internet En un post anterior te presente diez alternativas para aprender a programar online de calidad y que ofrecen resultados probados. Con el auge de la educación y los cursos en línea que complementan a la educación tradicional han emergido muchas opciones para el alumnado. En esta ocasión he compilado seis de los mejores sitios para aprender de todo y cómodamente desde tu equipo de escritorio o smartphone. La lista ofrece opciones didácticas, claras y que abarcan todas las áreas posibles e interesantes del aprendizaje (o por lo menos la gran mayoría) También lee: 12 Gestores de proyectos gratuitos y Open Source realmente útiles 1.

App Inventor Get Started Follow these simple directions to build your first app! Tutorials asdfree by anthony damico Simon Jackson's Blog - Mastering Unity 2D Game DevelopmentAnimation Curves The following blog post, unless otherwise noted, was written by a member of Gamasutra’s community. The thoughts and opinions expressed are those of the writer and not Gamasutra or its parent company. In the run up to the launch of my first published title (a book this time) I’ve done some short snippets from some of the many exciting things you will learn within its pages. The sample project and code for this snippet can be found here: – AnimationCurves.zip *Edit – seems only 5 minutes since I posted this article and already we fine other useful frameworks to assist with using AnimationCurves on their own.

How to Build a Responsive Image Gallery with Flexbox – Tania Rascia A quick and easy guide on how to set up a basic Flexbox grid for an image gallery. You may have noticed I’ve updated the site to include a front page with a grid listing all the tutorials. As you resize the screen, it goes from three columns, to two columns, to a single column on mobile.

Related: