Intelligentedu
Free Computer and I.T. Books


April 27, 2010

Phoenix eBook Library

Update: This site no longer hosts any of these ebooks.

Phoenix eBook Library hosts many, many freely downloadable computer, I.T., and programming ebooks in many areas, as linked here below. These computer ebooks are mostly in pdf format.


eBook Categories for Phoenix eBook Library:

 - Artificial Intelligence
 - Audio Books
 - C and C++ programming
 - Computer Science
 - Cryptography
 - Database and SQL
 - Discrete Mathematics
 - Ebooks.For.Dummies.Collection
 - Encryption
 - Java programming
 - Linux
 - Load Balancing
 - Misc
 - Mobile Wireless Development
 - Networking
 - PHP
 - Parallel Programming
 - Patterns
 - Project Management
 - Python programming
 - Requirement Engineering
 - SNMP Networking
 - Storybooks
 - UML
 - Visual Studio .NET
 - XML & Web Services
 - jQuery



Tags for this post>> | | | | | | | |


Filed under: Free Computer and I.T. Books — computer_teacher @ 9:10 pm


January 20, 2010

43 Database related eBooks

Here are 43 Database related eBooks, available for download at DataMens' Geekifed Library of Geekdom. These database ebooks are all in pdf format.


Database Apps and Topics covered by these ebooks:

 - SQL Server
 - Oracle
 - My SQL
 - SQL
 - Access
 - Database Design
 - Database Programming
 - Visual Studio
 - Web Design



Tags for this post>> | | |


Filed under: Free Computer and I.T. Books — computer_teacher @ 12:06 pm


November 4, 2009

Oracle Database 10g Documentation Library

Here is the Oracle Database 10g Documentation Library for Oracle 10g Release 2 (10.2), hosted at web.njit.edu. These freely available Oracle books and guides will help you to get started using Oracle Database 10g, along with assisting with installing and administering it. In addition, there are books to help you use it with PL-SQL. Also, here are some mirrors of this library: stanford, csueastbay, njit, and wtamu.


Getting Started


These books provide background information for new users:

2 Day DBA: HTML  PDF
Concepts: HTML  PDF
Administrator's Guide: HTML  PDF
Master Glossary: HTML   
New Features Guide: HTML  PDF


Most Popular


These books contain the most commonly used information for general database administration and application development:

2 Day DBA: HTML  PDF
Concepts: HTML  PDF
Administrator's Guide: HTML  PDF
Application Developer's Guide - Fundamentals: HTML  PDF
Reference: HTML  PDF
Performance Tuning Guide: HTML  PDF
PL/SQL User's Guide and Reference: HTML  PDF
SQL Reference: HTML  PDF


Installation Guides

Installation documentation, READMEs, and release notes are on the product media for your operating system. If you have an Internet connection, you can find the latest editions on the Oracle Technology Network site.

Access Manager for AS/400 Installation and User's Guide for IBM iSeries OS/400: HTML  PDF
Backup Installation Guide: HTML  PDF
Enterprise Manager Grid Control Installation and Basic Configuration for Linux x86: HTML  PDF
HTML DB Installation Guide: HTML  PDF
Installation Guide for AIX 5L Based Systems (64-Bit): HTML  PDF
Installation Guide for hp-ux Itanium: HTML  PDF
Installation Guide for hp-ux PA-RISC (64-Bit): HTML  PDF
Installation Guide for IBM z/OS (OS/390): HTML  PDF
Installation Guide for IBM zSeries Based Linux: HTML  PDF
Installation Guide for Linux Itanium: HTML  PDF
Installation Guide for Linux on POWER: HTML  PDF
Installation Guide for Linux x86: HTML  PDF
Installation Guide for Linux x86-64: HTML  PDF
Installation Guide for Microsoft Windows: HTML  PDF
Installation Guide for Microsoft Windows (64-Bit) on Intel Itanium: HTML  PDF
Installation Guide for Microsoft Windows (x64): HTML  PDF
Installation Guide for Solaris Operating System (SPARC 64-Bit): HTML  PDF
Installation Guide for Solaris Operating System (x86-64): HTML  PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for AIX: HTML  PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for hp HP-UX PA-RISC (64-Bit): HTML  PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for Microsoft Windows Platforms: HTML  PDF
Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for Solaris Operating System (SPARC 64-Bit): HTML  PDF
Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux: HTML  PDF
Universal Installer and OPatch User's Guide for Windows and UNIX: HTML  PDF
Vault Installation Guide for Linux: HTML  PDF


Upgrade Information

If you are familiar with earlier Oracle releases and are moving to Oracle Database 10g, these books describe the new features, and explain how to upgrade your database.

New Features Guide: HTML  PDF
Upgrade Guide: HTML  PDF



Tags for this post>> | |




August 24, 2009

10 IT and Programming eBooks

Here are 10 IT and Programming eBooks from bookboon.com, along with four more that will be available in the near future. These free ebooks provide you with an introduction to programming and core issues within information technology. In the future, books covering specific programming languages will be available for free download at this site, these will be for learning how to program in C, C + +, C #, PHP and Java. To access the download links, simply select a study program and the state where you reside from the 2 drop-downs.



An Introduction to Relational Database Theory 

Download



C Programming in Linux

Download



Java: The Fundamentals of Objects and Classes

Download

Java: Classes in Java Applications

Download



Java: Graphical User Interfaces

Download



Prolog Techniques

Download



Business Information Management

Download


Business Information Management Exercises

Download!


Mathematics for Computer Scientists

Download


Law for Computing Students

Download


An introduction to relation Database theory

Coming soon

Information Systems Development

Coming soon


Computer Systems Networking

Coming soon



Managing Business Systems

Coming soon



Tags for this post>>
| | |


Filed under: Free Computer and I.T. Books — computer_teacher @ 10:41 pm


April 8, 2009

500 Computer and Progamming eBooks

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



Tags for this post>> | | | | | | | | | | | |


Filed under: Free Computer and I.T. Books — computer_teacher @ 8:46 pm


March 21, 2009

19 Database Tutorials

The 19 Database Tutorials below are found at devhood.mit.edu and explain how to access and work with databases using C#, VB and XML. Put simply, databases are a collection of records that are structured to meet a specific standard. These, for example, may be records of employees, payroll or even an inventory. Various applications are allowed to manipulate the data stored in a database. These applications can be written in a variety of languages with each language having its own interface to connect to a database. These database tutorials will provide you with tips to get you up and going to start working with database programming.


General Database Tutorials:

 -  Querying an OLAP-datasource using C#
 -  Data-Binding Windows Forms with ADO.NET
 -  How to copy data from one recordset to another using ADO
 -  An Even Smarter Database Manager
 -  A Smarter Database Manager for C#
 -  Mysql Database: Creation & Usage with C#
 -  Using Indexing to Increase Performance
 -  Using Connection Pooling in Database Driven Applications
 -  SQL Connection Management
 -  SQL Server Queries over HTTP with XML
 -  Simple SQL Aggregate Functions
 -  Constructing SQL Queries - Intermediate Level
 -  Database Normalization part II -- Second and Third Normal Forms
 -  Database Normalization
 -  SQL_Primer
 -  SQL Server Stored Procedures
 -  Unbound Data Sources with ADO in VB 6
 -  Doing an Indexed Search Using 'Containstable', 'Contains'
 -  Setting up Full Text Search with Sql Server 2000 Enterprise Manager



Tags for this post>> | |


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 10:42 pm


February 27, 2009

eBooks and Technical Docs from ebook-search-engine.com

Here is a great search site for free ebooks: ebook-search-engine.com. It returns many links around the web for ebooks, tutorial documents, manuals, and help sheets covering many computer, I.T., and technical areas. Most of the documents returned by this site are pdf and doc files.


Here are some result pages from this site:

 - Java programming
 - C++ programming
 - C# programming
 - AJAX
 - JavaScript
 - PHP
 - Ruby
 - Python Programming
 - Google Web Toolkit
 - Linux
 - Oracle
 - Windows
 - SQL Server
 - VB .NET
 - .NET



Tags for this post>> | | | | | |




February 22, 2009

SQL Tutorial from intermedia.net

Here is a pretty good SQL Tutorial hosted by intermedia.net. SQL allows you to access, manipulate, and edit data stored in a relational database management system. This SQL tutorial also provides examples to help you understand the concepts being presented. The SQL used in this document is "ANSI", or standard SQL.


Table of Contents of SQL Tutorial:

 - Basics of the SELECT Statement
 - Conditional Selection
 - Relational Operators
 - Compound Conditions
 - IN & BETWEEN
 - Using LIKE
 - Joins
 - Keys
 - Performing a Join
 - Eliminating Duplicates
 - Aliases & In/Subqueries
 - Aggregate Functions
 - Views
 - Creating New Tables
 - Altering Tables
 - Adding Data
 - Deleting Data
 - Updating Data
 - Indexes
 - GROUP BY & HAVING
 - More Subqueries
 - EXISTS & ALL
 - UNION & Outer Joins
 - Embedded SQL
 - Common SQL Questions
 - Nonstandard SQL
 - Syntax Summary
 - Important Links



Tags for this post>> |


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 12:51 am


December 24, 2008

Oracle For Beginners Online Book

Here is an online book titled Oracle For Beginners, written by P.Srikanth. This Oracle book shows you how to use Oracle to store, retrieve, manipulate and process data. It reviews the basics of relational database management system and then discussed more advanced topics, including native dynamic SQL and distributed databases. The book's 24 chapters cover the Oracle8i database, and the author has provided further articles and tutorials that discuss many of the new features of Oracle9i, Oracle10g, and Oracle11g databases, which are linked below.


Oracle Book Chapters:

1. Introduction to RDBMS
2. Introduction to Oracle
3. Getting started with Oracle
4. Creating sample tables
5. Changing structure and data
6. Arithmetic and Date Functions
7. String, Conversion,and Miscellaneous functions
8. Grouping Data
9. Joining Tables
10. Views
11. Subqueries
12. Indexing, clustering, sequence, and pseudo columns
13. Security
14. Report Generation using SQL*PLUS commands
15. Introduction to PL/SQL
16. Control structures
17. Exception handling
18. Cursor Handling
19. Procedures,functions and packages
20. Database Triggers
21. LOBs
22. Object Types
23. VARRAY and Nested Table
24. Native Dynamic SQL


Tutorials covering new Oracle database functionality:
 - New Features of Oracle9i
 - Installing and using Oracle Databsae 10g Express Edition
 - Accessing Oracle10g Express Edition From Java
 - Getting started with Oracle Database 10g
 - Regular Expressions in Oracle10g
 - New Features of Oracle Database 11g


Here are 3 more Oracle articles from the author:
 - Oracle History
 - Accessing Oracle using Pro*C
 - Using SQL Commands In Pro*C


Here are SQL scripts for creating sample tables and inserting data into those tables. You can run these scripts at SQL prompt in SQL*PLUS using START command.
 - Script to create sample tables
 - Script to insert data into sample tables



Tags for this post>> | |


Filed under: Free Computer and I.T. Books — computer_teacher @ 10:57 pm


Database Design Tutorial

Here is a informative tutorial that teaches you how to do Database Design, from theparticle.com. This tutorial explains the conceptual framework for designing database schemas. It is most relevant to relational databases, but can also be applied to object databases. If you’re already familiar with SQL or have worked with relational databases, but need more help or understanding putting together designs, then this database design tutorial will be helpful to you. Database design starts with the need to know what we are building, what information we are dealing with, and how we can apply it. The topics covered are listed below.


Contents of Database Design Tutorial:
 - Objects
 - Events
 - Properties
 - Object Relationships
 - Optimization
 - Repeating Properties
 - Property Value History
 - Adding Indexes
 - Reducing Number of Tables
 - Data Redundancy



Tags for this post>>


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 5:33 pm


October 23, 2008

JDBC Slides, Labs, Code, and Tutorials

Here is a complete set of Slides, Lab Exervises, Code, and Tutorials covering JDBC (Java Database Connectivity).

Here is the Java Code and the practice database, and here are the exercises: JDBC Lab 1 Exercises and JDBC Lab 2 Exercises.


JDBC Slides Set 1: Introduction to Java Database Connectivity
Provides background on JDBC to help with the lab exercises
(39 slides, 445kb, ppt format)

1. What is JDBC?
2. The JDBC-ODBC Bridge
3. Four Kinds of JDBC Drivers
4. JDBC Pseudocode
5. simpJDBC.java
6. Meta Data
7. Books.mdb as an ODBC Data Source
8. Table in Books.mdb
9. More Information


JDBC Slides Set 2: Advanced Java Database Connectivity
Looks at some of the advanced parts of JDBC to help with the lab exercises
(43 slides, 345kb, ppt format)

1. SQL Statements
2. Executing DDL and DML
3. PreparedStatement Objects
4. Database Metadata
5. More Information


MySQL Tutorial  covers the following topics:
 - Starting and Stopping MySQL Server
 - Connecting to MySQL
 - Creating User Accounts
 - Using MySQL
 - MySQL Administration
 - Accessing MySQL using Java
 - mysqljdbc.jar

Tutorial for MS Access
covers the following topics:
 - Creating Databases and Executing SQL
 - Creating ODBC Data Source
 - Accessing Database Using Java



Tags for this post>> |


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 9:10 pm


August 20, 2008

Database Course from Mount Holyoke College

Mount Holyoke College's Database Course provides the following lecture slides that will help you understand these important database concepts and topics, and to put them into practice. These go into a great amount of detail on the areas covered and also give examples and coding samples where applicable.


Database Course Lectures:

Introduction to Databases:
Chapter 1

Entity / Relationship Model, Relational Model:
Chapter 2
Chapter 3

Relational Algebra and Calculus:
Chapter 4a
Chapter 4b

SQL:
Chapter 5

Building Database Applications:
Chapter 6

Database-Backed Internet Applications:
Chapter 7

Normal Forms, Storage and Indexing:
Chapter 19
Chapter 8
Chapter 9.6, 9.7

Query Evaluation:
Chapter 12

Transaction Management, Security:
Chapter 16
Chapter 21

Deductive Databases, Information Retrieval:
Chapter 24
Chapter 27a  , Chapter 27b Chapter 27c,  Chapter 27d 

Spatial Databases, Data Warehousing:
Chapter 28
Chapter 25, Chapter 25b

Datamining:
Chapter 26



Tags for this post>>


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 8:33 pm


August 4, 2008

MySQL Essentials

MySQL is a free, open source database management system that is easy to install, implement and maintain. It also provides quick performance and is very reliable, while being widely implemented throughout the world. MySQL brings the power of a scalable relation database application to anyone with the skills to build a data driven application or web site. 

Here is another excellent, free online book, MySQL Essentials, hosted by techotopia.com. The objective of MySQL Essentials, is to provide step-by-step instructions on how to implement and administer MySQL. The book teaches you the fundamentals of relational databases and how to configure and install MySQL. It then covers all the tasks you need to know and perform so you can successfully build, maintain and secure MySQL based databases. The topics of MySQL Essentials are listed and linked below in the table of contents.


Table of Contents of MySQL Essentials:

About MySQL Essentials

Database Basics
 - What is a Database?
 - Understanding Database Tables
 - Introducing Database Schema
 - Columns and Datatypes
 - Database Rows
 - Introducing Primary Keys
 - What is SQL?

MySQL Database Architecture

The mysql Command-Line Tool
 - The mysql Command-line Utility
 - mysql Command-Line Arguments
 - mysql Commands

The MySQL Administrator Tool
 - Getting and Installing MySQL Administrator
 - Connecting to the Database Server
 - Using the MySQL Administator

The MySQL Query Browser
 - Getting and Installing MySQL Query Browser
 - Connecting the MySQL Query Browser to a Database Server
 - A Tour of MySQL Browser
 - Executing SQL Statements

Creating New Databases and Tables with MySQL Administrator
 - Creating a New Database
 - Creating New Tables

Creating Databases and Tables Using SQL Commands
 - Creating a New MySQL Database
 - Creating Tables with SQL
 - Understanding NULL and NOT NULL Values
 - Primary Keys
 - AUTO_INCREMENT
 - Defining Default Values During Table Creation
 - MySQL Database Engine Types

Updating and Deleting MySQL Tables
 - Altering a MySQL Table
 - Adding and Deleting Table Columns
 - Renaming Tables and Columns
 - Changing The Data Type of a Column
 - Deleting a Database Table

Inserting Data into a MySQL Database
 - The Basics of Data Insertion
 - Inserting a Complete Row
 - Adding Multiple Rows to a Table
 - Inserting Results from a SELECT Statement
 - Reducing the INSERT Performance Load
 - Reducing the INSERT Performance Load

Updating and Deleting MySQL Data
 - Updating Database Data
 - Ignoring Update Errors
 - Deleting Database Data

Retrieving Data From a MySQL Database
 - Retrieving a Single Column
 - Using SELECT to Retrieve Mutiple Columns
 - Restricting Number of Results
 - Eliminating Duplicate Values from Results

Sorting Data Retrieved from a MySQL Database
 - Sorting Data from a SELECT Statement
 - Sorting on Multiple Columns
 - Sorting Data in Descending Order

Using WHERE to Filter MySQL Data
 - The Basics of the WHERE Clause
 - Comparison Operators
 - Checking for NULL Values
 - Searching within Range Values

Advanced MySQL Data Filtering - AND, OR, NOT and IN
 - Filtering Data Using the OR Operator
 - Filtering Data Using the AND Operator
 - Combining AND and OR Operators
 - Understanding Operator Precedence
 - Specifying a Range of Conditions using the IN Clause
 - Using the NOT Operator

MySQL Wildcard Filtering using LIKE
 - What are Wildcards?
 - Single Character Wildcards
 - Multiple Character Wildcards

MySQL Regular Expression Searches
 - What are Regular Expressions?
 - Regular Expression Character Matching
 - Matching from a Group of Characters
 - Matching from a Range of Characters
 - Handling Special Characters
 - Regular Expressions and Whitespace Characters
 - Matching by Character Type
 - Regular Expression Repetition Metacharacters
 - Matching by Text Position

Joining Tables in MySQL
 - How Does a Join Work?
 - Performing a Cross-Join
 - Equi-Join (aka the Inner Join)
 - Performing a Left Join or a Right Join
 - Creating Joins with WHERE and USING

An Introduction to MySQL Views
 - Creating a Basic View
 - Joins and Views
 - Getting Information About a View
 - Deleting a View
 - Replacing a View

MySQL Calculations and Concatenations
 - Performing Calculations on Retrieved Data
 - Concatenating Data Fields
 - Trimming Trailing Whitespace from Text
 - Trimming Leading Whitespace from Text

Manipulating Text in MySQL
 - MySQL String Manipulation Functions

MySQL Mathematical Functions
 - MySQL Arithmetic Functions

Working with Dates and Times in MySQL
 - Date and Time Formats
 - Creating Date and Time Fields
 - Date and Time Formats
 - Date and Time Functions
 - Inserting Date and Time Values into Table Columns
 - Retrieving Data Based on Date and Time Criteria

MySQL Data Aggregation Functions
 - The MySQL Aggregate Functions
 - Using the Aggregate Functions
 - Using the MySQL AVG() Function
 - Using the MySQL COUNT() Function
 - Using the MySQL MAX() Function
 - Using the MySQL MIN() Function
 - Using the SUM() Function
 - Using Multiple Aggregate Functions

MySQL Users and Security
 - MySQL Security
 - Getting Information About Users
 - Creating a New MySQL User
 - Deleting a MySQL User
 - Renaming a MySQL User
 - Changing the Password for a MySQL User
 - User Privileges



Tags for this post>> |




July 4, 2008

Library and Tutorials for Oracle and PL-SQL

Here are some great learning and tutorial documents for Oracle Database. The first one listed and linked below is the whole Oracle 10g Documentation Library, hosted by California State University, and includes a search form to help you find what you're looking for. The second is a group of Oracle and PL-SQL tutorials from Stanford University.


Oracle Database 10g Release 2 (10.2) Documentation Library

Getting Started:
These books provide background information for new users or to get you started using Oracle 10g:

  - 2 Day DBA:  HTML  PDF
  - Concepts:  HTML  PDF
  - Administrator's Guide:  HTML  PDF
  - Master Glossary:  HTML  
  - New Features Guide:  HTML  PDF  


Most Popular Oracle Books:
These books contain the most commonly used information for general database administration and application development:

  - 2 Day DBA:  HTML  PDF
  - Concepts:  HTML  PDF
  - Administrator's Guide:  HTML  PDF
  - Application Developer's Guide - Fundamentals:  HTML  PDF
  - Reference:  HTML  PDF
  - Performance Tuning Guide:  HTML  PDF
  - PL/SQL User's Guide and Reference:  HTML  PDF
  - SQL Reference:  HTML  PDF


Main Sections of Oracle 10g Library:

  - Books
  - Administration
  - Application Development
  - OLTP
  - Data Warehousing
  - Grid Computing
  - Unstructured Data
  - Information Integration
  - Windows

Search Oracle 10g Library:

All Oracle Books


Oracle and PL-SQL Tutorials from Stanford University:

  - Using Oracle PL/SQL
  - Oracle Dates and Times
  - Oracle 9i SQL versus Standard SQL
  - Constraints and Triggers
  - Introduction to Pro*C Embedded SQL



Tags for this post>> | |




Powered by WordPress