Intelligentedu Best New Free Computer IT Training Tutorial Resources

Here is an SQL Tutorial from Brown University. Learning SQL can be very rewarding and this tutorial covers the SQL (Structure Query Language) syntax and its commands. SQL is used to modify and access data or information from a database, usually a relational database such as Oracle, SQL Server, or MySQL. This SQL Tutorial explains how we can select, insert, update, and delete records in database tables, rows (records), and columns (fields). The SQL concepts discussed in this tutorial can be applied to almost any database system. Commands covered by this tutorial include the SELECT statement, UPDATE statement, INSERT INTO statement, DELETE statement, WHERE clause, ORDER BY clause, GROUP BY clause, ORDER clause, Joins, Views, and GROUP functions with examples.


SQL features described:

 - SELECTing data from one table
 - SELECTing data from multiple related tables
 - Why we JOIN tables on a specified field
 - UPDATE queries
 - DELETE queries
 - INSERT INTO queries

Popularity: 7% [?]

Here are many Technical and Programming ebooks for open source development technologies and platforms, as shown below. These computer ebooks are in pdf format.


Topics covered by these Computer and Programming eBooks:

 - Java Programming
 - JavaBeans
 - JSP
 - JBoss
 - J2ME
 - Struts
 - C++ Programming
 - C Programming
 - Ruby Programming
 - Python Programming
 - Perl Programming
 - Ruby Programming
 - XML
 - Ant
 - Linux Programming
 - Linux Networking
 - Linux Administration
 - Linux Security
 - Linux iptables
 - Red Hat RHCE
 - Bash Shell Scripting
 - Unix
 - OpenBSD, FreeBSD
 - PL-SQL
 - Oracle Database
 - Apache Module programming
 - Apache and Tomcat
 - LAMP
 - PHP
 - Ajax
 - Regular Expressions
 - Web Performance
 - MySQL Database
 - PostgreSQL Database
 - DB2 Database
 - SSL
 - VPN
 - Solaris
 - Sun Networking
 - Zope
 - Snort
 - Linux and Windows Integration

Popularity: 9% [?]

Here are Web Programming Tutorials from alistapart.com, covering Scripting (JavaScript and Ajax), Server Side (Ruby on Rails and Ajax), and XML. Client and Server Side Scripting is important when it comes to handling requests and responses to and from the client (browser) and the web server, while XML allows individual levels of customization.


Scripting Tutorials:
Scripting or a scripting language is a programming langauge that provides contorl of applications, either one or many. These scripting tutorials primarily provide a good coverage on Javascript and Ruby-on-Rails programming that include script enahancement and debugging, along with development in CSS.

 - Advanced Debugging with JavaScript
 - Progressive Enhancement with JavaScript
 - Progressive Enhancement with CSS
 - Understanding Progressive Enhancement
 - Test-Driven Progressive Enhancement
 - CSS Sprites2 - It's JavaScript Time
 - Getting Out of Binding Situations in JavaScript
 - Creating More Using Less Effort with Ruby on Rails
 - Getting Started with Ruby on Rails
 - Take Control of Your Maps


Web Server Side Tutorials:
Unlike client-side scripting, server side scripts or scripting is present on servers and generate dynamic web pages based on user requests. These tutorials start off with Ruby-on-Rails and then move onto Ajax scripting that covers the basics and move to the advanced topics.

 - A More Useful 404
 - Getting Started with Ruby on Rails
 - Creating More Using Less Effort with Ruby on Rails
 - Graceful E-Mail Obfuscation
 - Sliced and Diced Sandbags
 - Automatic Magazine Layout
 - Getting Started with Ajax
 - A Better Image Rotator
 - Smarter Image Hotlinking Prevention
 - Dynamic Text Replacement


XML Tutorials:
XML is a specification for creating custom markup languages. It is termed extensible since it can be extended to suit each users needs. These tutorials provide details on creating and validating Document Type Definitions (DTDs), using XML inline and explain W3C specifications. As a quick crash course, an easy-to-understand primer on XML is also provided.

 - Getting Started with Ajax
 - More About Custom DTDs
 - Validating a Custom DTD
 - Inline XML
 - Using XML
 - Fix Your Site With the Right DOCTYPE!
 - Understanding Web Services
 - What the Hell is XML?
 - How to Read W3C Specs
 - This HTML Kills: Thoughts on Web Accessibility

Popularity: 7% [?]

Here are 20 Computer and Web Programming eBooks, covering the following topics.  Separate directories on this site contain 6 XML ebooks, 3 Linux ebooks, and 4 web services ebooks.


eBook Topics:

 - Java Programming
 - Java Data Structures
 - SOAP
 - XSLT
 - XML
 - JSP
 - Java Web Services
 - Web Services Programming and SOAP
 - ASP.NET
 - SCJP
 - Linux
 - Debian Linux
 - Visual Studio 2005
 - Algorithms

Popularity: 10% [?]

Here are 53 ASP .NET Tutorials, located in the tutorials section at mit.edu's DevHood. These tutorials are for ASP .Net developers, from the level of a beginner all the way to an expert. ASP .Net is part of the Microsoft .Net framework, and is a powerful tool for creating dynamic, interactive web pages.

These tutorials start out with a brief introduction to ASP .NET, its usefulness, and its advantages over traditional ASP. This is followed by advanced topics that cover threading, sending mails, integrating XML with ASP .NET, transaction processing and managing session state. These ASP .NET tutorials should set you up and have you good to go with using this dotNET web development technology.


53 ASP .NET Tutorials:

 -  How to use Treeview in ASP .Net 1.1
 -  What's new in ASP .Net ver. 2
 -  Beginners Introduction to ASP .Net
 -  ASP .Net XML/XSL Transforms
 -  String type object seems to act like a value type even it is reference type!
 -  Using the PlaceHolder Control
 -  Apply Single-Sign-On to your application
 -  Building a File Upload and Administration Tool
 -  Protecting Files and Email
 -  How to duplicate an MS Access table and its data using ADOX
 -  Understanding the Garbage Collector
 -  Displaying the progress in a popup-window while waiting
 -  Protecting Your Email's and Files
 -  Making A Server Name
 -  Global Properties Using Reflection
 -  Performing Web Authentication and Administration with LDAP - ASP .NET
 -  Implement a Custom Error Page
 -  Performing Web Authentication and Administration with LDAP - ASP .NET
 -  Creating a Threaded News Browser in ASP .NET
 -  Sending Email from ASP .NET page
 -  ClipLink: System Tray and ShellExecute
 -  How to create an MD5 hash from a String using .NET framework
 -  Auto Updating Photo Album
 -  Validating Portions of an ASP .NET Page
 -  Creating dynamic images in ASP .NET
 -  SQL Transactions with the SqlTransaction Class
 -  Custom Error Pages and logging errors
 -  Role-based Security with Forms Authentication
 -  Using SQLXML Templates with ASP .NET
 -  Introduction to Delegates
 -  Paging with Datalists (and other controls without built in support)
 -  Browsing Your (Server's) Hard Drive Through ASP .NET
 -  An Introduction to SessionState and Cookies
 -  Uploading files in ASP .NET
 -  Setting up IIS to access your computer via Remote Desktop
 -  Performance Testing Visual Studio .NET
 -  Embedded Windows User Controls into Internet Explorer
 -  XML Site Summary Consumption using ASP .NET
 -  Search Pages using Data-bound Controls, Index Server, and ASP .NET
 -  Using ASP Formmail (web to e-mail gateway) to send e-mail from your Microsoft Web Server
 -  Data Caching with ASP .NET
 -  Creating Voice applications with VXML and ASP .NET
 -  Creating and Using Custom Attributes Part I : Attribute Creation
 -  Quick and Dirty Email without System.Web.Mail.SendMail
 -  Adding assembly to GAC
 -  Adding Customized Tags in web.config
 -  Forms Authentication Tutorial
 -  Guestbook .NET - a beginner tutorial to ASP .NET
 -  ASP .NET Validator Controls
 -  Sending Email with .NET
 -  A Simple ASP .NET Web Application
 -  Implementing Passport Single Sign-in for ASP .NET pages
 -  ASP .NET: Email Web Page

Popularity: 7% [?]

Here are over 250 Computer eBooks covering many techinical areas, including Java, C++, XML, Cisco, Wireless, Use Cases, UML, CIW, and dotNet. These programming and computer ebooks are in pdf format.


eBook Topics:

 - C++ Programming
 - Java Programming
 - Java Networking and Security
 - J2EE, J2ME, JSP
 - EJB, JavaBeans
 - JDBC and Database Programming
 - PHP Programming
 - Algorithms
 - CIW Certification
 - A++ Certification
 - MySQL and Oracle Database
 - SQL, Database Design
 - XML Programming, SOAP
 - Cisco, CCIE, CCDA, CCNP, CCNA
 - Networking, SNMP
 - Wireless, WLAN, WPAN
 - 3G Mobile Communications
 - Security, SSCP Certification
 - Neural Networks
 - Fiber Optics Communications
 - Linux Shell Scripting
 - Real-Time Designs and Patterns
 - UML, Use Cases
 - Software Architecture
 - ANT
 - Solaris, SCSA, SCPJ, SCEA
 - Visual Studio
 - .NET Framework and Architecture
 - C# (C Sharp) Programming
 - Visual Basic .NET, VB .NET
 - Visual C++ .NET
 - Windows 2003
 - Windows XP
 - Citrix

Popularity: 11% [?]

Here is an ftp repository containing over 500 Computer and Progamming eBooks, in pdf and chm formats. The topics and areas covered by these computer and programming ebooks are listed below. This site is working fine at this time, but may become busy as it becomes known.


eBook Topics:

 - Java Programming
 - Java Certification
 - Java Algorithms
 - Wireless and Bluetooth Java
 - Java Performance and Security
 - JSP, Java Servlets, EJB, JDBC
 - C++ Programming
 - C++ Network Programming
 - JavaScript
 - PHP Programming
 - SOAP and Web Services
 - Perl Programming
 - Python Programming
 - XML, XSLT
 - Linux Administration, LAMP
 - Red Hat Linux, Debian Linux
 - Linux Networking, Beowulf Cluster
 - Unix, Solaris
 - Shell Scripting
 - Apache Modules Perl and C
 - Networking, TCP-IP
 - Assembly Language
 - SQL
 - MySQL
 - PostgreSQL
 - DB2 Database
 - Oracle Database
 - Oracle Applications
 - SQL Server
 - Windows Server 2003
 - Windows XP
 - C Sharp (C#) Programming
 - ASP .NET, ADO .Net
 - dotNET (.NET) Programming with Security
 - Visual Basic .NET
 - Windows Forms Programming
 - Active Directory
 - MCSA, MCCE 70-293 70-298 70-299
 - MCAD, MCSD
 - PC Hardware

Popularity: 13% [?]

Here are several excellent Real-Time Linux Tutorials at isd.mel.nist.gov that introduce and demonstrate a version of the Linux operating system which interacts and communicates with users in real time. These Real-Time Linux Tutorials cover the basics of real time Linux followed by the communication in FIFO (First In First Out) mode. They also explain how tasks are prioritized in a real time operating system; explain the concept of shared communication and semaphores. Examples of real time systems are explained using a servomotor and an LED wand clock.


Real-Time Linux Tutorials:

The Basics
This subdirectory describes about the Linux Task, Kernel Modules and Linux programs. It also tells us that C is the preferred language for Linux programming.

A Single Periodic Task
This example demonstrates a single fixed-period task to read and write I/O address.

Two Periodic Tasks
This example explains about the way two periodic tasks that use shared variables where one task changes the variable and the other one uses this variable.

A Variable-Period Task
This example demonstrates how to set the varying frequency to a single task using timer.

FIFO Communication
FIFO (first-in, first out) is a mechanism of storing data in the using data queue. This example explains how to set up a FIFO data queue to share data between application and tasks.

Interrupt Service Routines
This example shows how to call the functions when an interrupt is triggered from hardware such as timer chips, printers, disk drives, Ethernet controllers, etc.

Shared Memory Communication
Shared Memory is an efficient means of passing data between programs. This example explains how the RT Linux tasks and normal Linux processes pass data using the Shared Memory.

Semaphores
To restrict the simultaneous access to the resources we can use Semaphores. This example explains how to achieve this.

RC Airplane Servomotor Control
This example demonstrates how to control a pair of radio-controlled (RC) airplane servomotors via the parallel port using the GUI.

LED Wand Clock
This Fantazein LED wand clock example demonstrates the implementation of tasking, FIFO and interrupt service routines.

Determining Stack Size
This example demonstrate how to determine the stack size, this helps to allocate the stack size efficiently.

Measuring Timing Jitter
In real time code it is important to quantify timing uncertainty and derive its impact. This example describes that with a pure periodic task, using the Pentium's built-in Time Stamp Counter (TSC).

Floating Point in RT Tasks
This example demonstrates the use of floating-point math in real time tasks.

Data Consistency Techniques
This supplementary material describes various data consistency techniques used to protect the shared data structures. In this supplementary material talks about data consistency techniques such as Dekker's- and Peterson's Algorithms, N-Process Mutual Exclusion using Hardware, N-Reader, 1-Writer Mutual Exclusion using Head/Tail Flags, Semaphores, Mutexes etc.

Popularity: 4% [?]

Here is another computer and programming ebook hosting site, containing many ebooks in pdf and chm formats that cover several technical areas, as shown below.


Computer and Programming eBook topics in chm format:

 - Java Programming ebooks
 - C Programming ebooks
 - PHP Programming ebooks
 - Perl ebooks
 - Oracle Database
 - MySQL
 - Linux
 - Unix ebooks


Computer and Programming eBook topics in pdf format:

 - Java Programming ebooks
 - Java JDBC, JNDI, and JAXP
 - Linux Programming ebooks
 - Linux Security
 - Linux iptables
 - Bash Shell Scripting
 - PHP Programming ebooks
 - MySQL and PHP
 - MySQL
 - Oracle PL-SQL
 - Perl Programming
 - OpenBSD
 - Unix
 - Snort
 - Zope
 - Apache Module using Perl and C

Popularity: 10% [?]

Here 61 PHP Tutorials and Articles at phpro.org that delve into the more complex topics in PHP and explain them in detail. These PHP tutorials explain the integration of PHP with MySQL and SimpleXML. It introduces Xajax, which is an open source class library of AJAX for PHP; they also discuss XSL and video conversion with FFMPEG, and they introduce the various design patterns in PHP and pagination with PHP and PDO.

Some of these PHP tutorials introduce the concept of eZ components, which is a PHP component library; others show how to filter data with PHP and offer some good PHP tips. Also explained is the difference between PHP and .Net, along with a demonstration of PHP Sessions, Templating, embedding PHP in CSS, and a brief overview of PHP6.


61 PHP Tutorials And Articles:

 - Introduction to PHP and MySQL
 - Introduction To SimpleXML With PHP
 - Xajax-In An Object Oriented Environment
 - SPL AppendIterator
 - Introduction To Xajax
 - Easy Access With PDO CRUD
 - Class Hierachies And Overriding
 - SPL Autoload
 - SQLite - On Duplicate Key Update
 - Introduction to SPL DirectoryIterator
 - Introduction to SPL ArrayAccess
 - PHP Security
 - Preventing Multiple Submits
 - Introduction to PHP Regex
 - Creating A PHP Application
 - Video Conversion With FFMPEG
 - XML And XSL
 - Tagging With PHP And MySQL
 - Imagick extension for PHP
 - Asynchronous Form Submission With Xajax
 - Geo Targetting With PHP And MySQL
 - Dropdown Select With PHP and MySQL
 - Design Patterns
 - Introduction To Arrays
 - Run Script From Cron
 - Introduction To eZ Components part 3
 - Pagination with PHP and PDO
 - Creating Dropdowns with PHP and Xajax
 - Basic Login Authentication with PHP and MySQL
 - Introduction To eZ Components part 2
 - Introduction To eZ Components part 1
 - Managing Hierarchical Data with PHP and MySQL
 - Filtering Data with PHP
 - Introduction to the Standard PHP Library (SPL)
 - PHP Coding Style
 - PHP Type Casting
 - Storing Images in MySQL with PHP
 - Object Oriented Programming with PHP
 - PHP Exceptions
 - Introduction to PHP PDO
 - Validating User Input
 - Introduction To PHP Sessions
 - Introduction to PHP templating
 - Embedding PHP In CSS
 - Difference Between isset empty is-null
 - Application Configuration
 - Namespace Changes Separator Again
 - The Future Of PDO
 - 50 PHP Tips
 - Companies Using PHP
 - Google Summer Of Code 2008
 - eZ Components Alpha Release
 - eZ Components Cache
 - Highlight Search Words
 - PHP v NET
 - Custom 404 Error Page
 - Why is sqlite so cool and why should I care
 - MySQL Error Codes
 - PHP4 End Of Life
 - PHP6 Preview
 - Coverty Report

Popularity: 5% [?]