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:  Code Academytools to learnOn-line coding toolsMore 5col_1

App Inventor Get Started Follow these simple steps to build your first app. Tutorials Select a Language Help What is repl.it? It is an online environment for interactively exploring programming languages. The name comes from the read-eval-print loop, the interactive toplevel used by languages like Lisp and Python. CSS Tutorial - Learn CSS Codes and Layouts CSS stands for Cascading Style Sheets. It is a stylesheet language that acts as the presentation layer for markup languages such as HTML and XHTML. The presence of CSS allows us to separate the layout component from the information component. In essence, the HTML document becomes the information component, while the CSS Style Sheet becomes the layout component. CSS used to be something that only a webmaster would need to learn. With the advent of blogs, however, CSS is fast becoming a computer language that reaches the masses.

7 Unique Ways To Practice Your Coding Skills I am 24 years old and just started learning coding. I want to be a programmer. Am I too late in the game? One of the upvoted answers to this on Quora.com came from graphic artist Michel Poisson. I’m 63, and eight months ago I decided to teach myself Blender 3D. A First Vim Tutorial I've started using vim again. I thought I would post some of my vim notes. I generally use vim 50% in the terminal, and now 50% as Cream (UPDATE: After learning more Vim commands I switched from Cream to regular Gvim). Cream is a version of gvim that makes using vim really easy. 3 Websites To Get Started With Learning C++ Programming Language Learning to program can be difficult for many, even with relatively easy programming languages. While Java is easier to get started with (where we have numerous articles here at MakeUseOf for Java as well as Internet scripting languages and deciding which one to learn), C++ may not be. However, those with some programming experience will find learning C++ less difficult than beginners, although there are plenty of good websites to teach yourself with. Why Learn C++? Why would you care to learn C++? It is a very powerful programming language which basically has a “trust the programmer” motto.

WebIDE - Firefox Developer Tools WebIDE enables you to create, edit, run, and debug web apps using the Firefox OS Simulator or a real Firefox OS device. It also enables you to connect the Firefox Developer Tools to a number of other browsers, including Firefox for Android, Chrome on Android, and Safari on iOS. See the Remote Debugging page for instructions on how to connect to a specific browser. PixelProspector - the indie goldmine On the 30th July 2014 the site got updated, restrutured and redesigned… however the update is still not finished and thus this new Indie Resources overview page is partly incomplete. In case you are missing something you can still check out the outdated old Indie Resources page until the update is complete. Thank you for your understanding. (Game Making Tools, Game Design, Postmortems, Programming, Project Management…)

Related:  Computer Programming Resources