Links: Database related

Root Reference Development Database related

Sub Categories:

Database design

MySQL

SQL Server

Links:

Introduction To Structured Query Language (SQL) - Part 1

* Topics and references * Relational databasesn overview * SQL overview * DML: Data retrieval SELECT statement (examples) * DML: Data retrieval SELECT statement (criteria) * SQL for SELECT exercises with criteria * CREATE TABLE statement (from existing table) * CREATE TABLE statement (with column definitions) * CREATE TABLE statement (syntax) * INSERT statement * CREATE INDEX statement * ALTER TABLE statement * DROP statement *UPDATE statement* DELETE statement 

Clicked: 34 Added: 2005-07-23 19:07:50 - Bad URL? Report it

Introduction To Structured Query Language (SQL) - Part 2

Topics by page * Queries and views: Overview * SELECT two tables: Examples * Types of JOIN * SELECT from two tables: Exercises * SELECT from two tables: Syntax * Multiple table SELECT * OUTER JOIN example * Set operations: UNION * UNION query: Exercises * Pass-through queries (concept) 

Clicked: 64 Added: 2005-07-23 19:07:20 - Bad URL? Report it

Postgre SQL

PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, SunOS, Tru64), BeOS, and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. An enterprise class database, PostgreSQL boasts sophisticated features such as the Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead log for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and in is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in sheer quantity of data it can manage and and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.  

Clicked: 196 Added: 2003-04-11 17:57:05 - Bad URL? Report it

SQL

Welcome to SQL.org! Our goal is to build a resource that will help those using or wanting to make use of an SQL database find the resources and reference materials they are looking for: an sql tutorial, manual, introduction, SQL hosting provider, or someone to help them out. We hope to provide a broad range of material so that we can be as useful to those who are just beginning to learn SQL as we are to experienced SQL fanatics. Our materials are currently limited to MySQL, PostgreSQL, Oracle, mSQL and Microsoft SQL, as well as materials that are applicable to any SQL server or relational database. 

Clicked: 199 Added: 2002-12-28 15:40:23 - Bad URL? Report it

SQL Injection Whitepaper [PDF]

SQL injection is a technique for exploiting web applications that use client-supplied data in SQL queries without stripping potentially harmful characters first. Despite being remarkably simple to protect against, there is an astonishing number of production systems connected to the Internet that are vulnerable to this type of attack. The objective of this paper is to educate the professional security community on the techniques that can be used to take advantage of a web application that is vulnerable to SQL injection, and to make clear the correct mechanisms that should be put in place to protect against SQL injection and input validation problems in general. 

Clicked: 19 Added: 2005-07-25 17:57:56 - Bad URL? Report it

SQL Server vs Access

Often people in newsgroups ask about some comparison of Access and SQL Server databases. In this article, I want to tell you about some general characteristics of Access 97/2000 and SQL Server 7.0/2000, about their restrictions, and about the comparison of these products. 

Clicked: 10 Added: 2005-07-25 12:39:46 - Bad URL? Report it

SQL Whores

The home of the Undernet IRC channel #sql. Articles provided by the regulars and operators of the channel to solve frequently asked questions and more complex issues. 

Clicked: 6 Added: 2006-01-10 18:45:34 - Bad URL? Report it

<< Previous | 1| 2| 3| Next >>
Total number of links: 602 in 81 (sub)categories - Suggest a link