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: 10% [?]

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: 12% [?]