Intelligentedu Fri dator och I.T. Bokar

Här är innehålla för ftp-repository över 500 dator- och Progamming eBooks, i pdf och chm formaterar. Ämnena och områdena som täckas av dessa datoren och programmeraebooks, är listat nedanfört. Denna plats är den funktionsdugliga boten på denna tid, men kan bli, upptagen som den blir bekant.


eBookämnen:

- Java programmera
- Java attestering
- Java algoritmer
- Radio och Bluetooth Java
- Java kapacitet och säkerhet
- JSP, Java Servlets, EJB, JDBC
- Programmera för C++
- C++ knyter kontakt att programmera
- JavaScript
- Programmera för PHP
- TVÅL och rengöringsduken servar
- Programmera för Perl
- Programmera för pytonorm
- XML, XSLT
- Linux administration, LAMPA
- Röd hatt Linux, Debian Linux
- Linux nätverkande, Beowulf samla i en klunga
- Unix, Solaris
- Shell skriva
- Apache enhetsPerl och C
- Nätverkande, TCP-IP
- Enhetsspråk
- SQL
- MySQL
- PostgreSQL
- Databas DB2
- Oracle databas
- Oracle applikationer
- Sql-server
- Windows server 2003
- Windows XP
- Programmera för c-kor (C#)
- ASP .NET, ADO. Netto
- dotNET (.NET) som programmerar med säkerhet
- Visuellt hjälpmedel grundläggande .NET
- Windows bildar att programmera
- Aktivarkiv
- MCSA, MCCE 70-293 70-298 70-299
- MCAD, MCSD
- PCmaskinvara

Popularitet: 10% [?]

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

Popularity: 5% [?]

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

Popularity: 10% [?]

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

Popularity: 5% [?]

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

Popularity: 18% [?]

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

Popularity: 9% [?]

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

Popularity: 16% [?]

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

Popularity: 9% [?]

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

Popularity: 17% [?]

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

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

Popularity: 9% [?]