SQL TOOLBOX: 20+ Tools and Lessons About SQL

SQL is all around us, but not everyone really knows its inner workings. We’ve gathered 20+ tools and lessons to help you learn all about it.

25 Commandments for MySQL Development – A list of 25 things all MySQL designers should keep in mind as they work.

Comparison of different SQL implementations – A simple page comparing all the different ways you can use the SQL language.

Instant SQL Formatter – Open several different forms of databases and output them in to a language of your choice including SQL.

Introduction to SQL – An introductory lesson to SQL, covering pretty much all the basics.

Learning SQL Using phpMyAdmin – A tutorial for learning the popular phpMyAdmin interface for MySQL database management.

MySQL Basics – A basic tutorial for those just starting out with learning MySQL.

MySQL Cheat Sheet – A quick reference for some of the most common commands in MySQL.

Oracle SQL Developer – A free graphical tool for developing an SQL database.

PostgreSQL.org – An open source database system developed on SQL.

SQL Designer – A site directed at teaching very basic beginners in SQL database work.

SQL Injection Attacks – A documentation of how “Injection Attacks” work on an SQL database.

SQL on Rails [PARODY] – A web framework for combining Ruby on Rails with SQL for quick deployment.

SQL.org – A large resource for all things related to SQL.

SQL-Tutorial.net – A very organized tutorial for SQL that lets you focus on one section at a time.

SQLAlchemy.org – A tool for harnessing the power of Python and SQL together.

SQLCourse.com – An interactive beginner’s course to SQL that includes an on-line SQL interpreter.

SQLinForm.com – Corrects spelling an syntax errors in your SQL code.

SQLzoo.net – An interactive tutorial that teaches you the ins-and-outs of MySQL.

SSWUG.org – A site to get help with any troubles you may be having with SQL databases.

Stump The SQL Guru – From the 4GuysFromRolla.com, ask tough questions of an SQL expert.

W3 Schools SQL Tutorials – An extensive tutorial on SQL that includes quizzes and recommended reading list.

JAVASCRIPT TOOLBOX: 25+ Tools & Tutorials For JavaScript

JavaScript is one of the most often used languages on the web, and it seems to be gaining in popularity each day. We’ve gathered 25+ tools and tutorials which will be useful to any JavaScript programmer – novice or pro.

ActiveWidgets.com – A component library that gives you AJAX-style fuctions with common visual elements.

Agile Partners Photo Resizing Tutorial – A tutorial on how to use the Prototype and script.aculo.us libraries to build an interactive photo resizer.

ByteFX – A low-level framework for simple JavaScript effects.

DevGuru – Defines all the terms of JavaScript and gives you code samples of what they do.

DojoToolkit.org – An open source DHTML toolkit built in JavaScript and based on several other tools.

Drag & Drop Sortable Lists – Tutorial for creating sortable lists with drag & drop functions.

DynamicDrive.com – A large collection of DHTML and JavaScripts for your use.

Firebug – An extension for the Firefox browser that allows you to do web development from directly inside the browser, including JavaScript.

JavaScript-reference.info – A reference site that teaches you both how to read and write JavaScript.

JavaScriptKit.com – A list of JavaScript objects, properties, and methods that include examples.

jQuery.com – A JavaScript library with a small footprint and concise coding for as few lines as possible.

Learn JavaScript in 10 Minutes – As the name implies, learn the basics of JavaScript in 10 minutes from this very straightforward tutorial.

Lightbox2 – A JavaScript for overlaying photos on the current page with a semi-transparent background.

LightWindow – Another overlay window system that allows you to do it with multiple media file types and even other websites.

MochiKit.com – A set of JavaScript libraries that takes ideas from Python and Objective-C, and uses them in JavaScript.

Moo.fx – JavaScript effects library that works with the Prototype.js and Mootools frameworks.

Mootools.net – An object-oriented JavaScript framework for intermediate to advance users.

Prototype Windows Class – Allows you to add an overlay window to your HTML.

Prototypejs.org – A JavaScript framework that is built with Web 2.0 in mind, includes Ajax integration.

QuirksMode.org – The personal site of a professional web developer who offers over a 120 tricks for defeating browser incompatibility issues of CS and JavaScript.

Reflection.js – A small JavaScript to add reflections to your image.

script.aculo.us – A JavaScript library that integrates easily with numerous frameworks.

ThickBox – Works with jQuery to provide an AJAX hybrid for image overlays.

TinyMCE JavaScript Content Editor – A content editor written completely in JavaScript and converts HTML text areas in to editor instances.

W3Schools JavaScript Tutorials – 100 Examples to learn JavaScript by.

WebTeacher.com – Takes the point of view of teaching JavaScript to a programming novice.

Walter Zorn Drag & Drop – A cross-browser JavaScript DHTML library that allows you to turn any image in to a layer that can be dragged and dropped where the user chooses.

.NET TOOLBOX: 25+ Tools and Tips For Working With .NET

Microsoft is going to be letting developers take a look at the source code for .NET, but for those of you still in the trenches, coding away, we’ve gathered 25+ tools to help you with your daily tasks.

Related: 20+ Flash Tools, 20+ PHP Tools, 20+ AJAX Tools, 20+ Java Tools, 20+ RoR Tools, 20+ Perl Tools

4GuysFomRolla.com – A rich site of articles and tutorials on using .NET.

ASP.net – Home of the .NET framework with news and starter lessons.

ASPTheme.net – Web themes for your ASP .NET projects.

Channel9 – Wikis, forums, podcasts and more related to all the Microsoft tools, especially .NET.

CodePlex.com – An open source clearing house for .NET projects, downloads, discussion forums and more.

CodeProject.com – A resource for articles and tutorials on Visual Basic and .NET.

Coding4Fun.com – A Microsoft site for detailing how to use .NET with other other tools to code for Windows, the web, gaming, and hardware.

DotNetJunkies.com – Features Quickstart guides and forums.

DotNetNuke.com – An open source web framework for enterprise class web development.

DotNetRocks.com – It’s not every programming language that gets a talk radio show dedicated to it.

GotDotNet.com – A user community for .NET developers that also features code sharing.

LearnVisualStudio.net – A large selection of video tutorials to get you going with .NET.

Lutz Roeder’s Programming .NET – Offers several tools for .NET such as Reflector and Resourcer.

MbUnit.com – A unit test framework for .NET, includes advanced features to test all aspects of your project.

Mono-Project.com – An open development project that lets you run .NET on Linux, Solaris, Mac OS X, Windows, and Unix.

MSDN Library – A resource for users of .NET and includes sample code, documentation, technical articles, and reference guides.

NAnt – A free .NET build tool.

NDepend.com – A tool built with the idea of controlling complex .NET coding, includes online demos.

NDoc – Generates class library documentation for your projects built in .NET.

NUnit.org – A unit-testing framework for all iterations of the .NET language.

ReSharper – An add-in to Visual Studio that adds in unit testing, refactoring, and more.

Snippet Compiler – A program that allows you to run small pieces of .NET code without having to build an entire Visual Studio project for it.

TestDriven.net – Adds unit testing to Visual Studio and makes it as easy as a one click.

The Regulator – A free tester for regular expressions.

TheServerSide.net – Specializing inserver side development of enterprise level projects using .NET.

W3Schhols – Features a collection of tutorials and code snippets for your use.