Geometry.Net - the online learning center
Home  - Computer - Sql
e99.com Bookstore
  
Images 
Newsgroups
Page 1     1-20 of 82    1  | 2  | 3  | 4  | 5  | Next 20

         Sql:     more books (99)
  1. Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta, 2004-04-10
  2. Microsoft SQL Server 2008 R2 Unleashed by Ray Rankins, Paul Bertucci, et all 2010-09-26
  3. Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer) by Itzik Ben-Gan, 2008-10-22
  4. Learning SQL by Alan Beaulieu, 2009-04-20
  5. Microsoft SQL Server 2008 Management and Administration by Ross Mistry, 2009-01-02
  6. Microsoft SQL Server 2008 Internals (Pro - Developer) by Kalen Delaney, Paul S. Randal, et all 2009-03-11
  7. SQL For Dummies by Allen G. Taylor, 2010-02-02
  8. Microsoft SQL Server 2008 Reporting Services by Brian Larson, 2008-08-21
  9. SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition) by John L. Viescas, Michael J. Hernandez, 2007-10-04
  10. Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, et all 2010-01-07
  11. MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008-Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance (PRO-Certification) by Mike Hotek, 2009-02-18
  12. Inside Microsoft SQL Server 2008: T-SQL Querying by Itzik Ben-Gan, Lubor Kollar, et all 2009-03-25
  13. Microsoft SQL Server 2008 Step by Step (Step by Step (Microsoft)) by Mike Hotek, 2008-11-12
  14. SQL Cookbook (Cookbooks (O'Reilly)) by Anthony Molinaro, 2005-12-16

1. SQL - Wikipedia, The Free Encyclopedia
sql is a standard interactive and programming language for querying and modifying data and managing databases. Although sql is both an ANSI and an ISO
http://en.wikipedia.org/wiki/SQL
SQL
From Wikipedia, the free encyclopedia
Jump to: navigation search SQL Paradigm multi-paradigm Appeared in Designed by Donald D. Chamberlin and Raymond F. Boyce Developer IBM Latest release SQL:2003/ 2003 Typing discipline static strong Major implementations ... Many SQL Structured Query Language pronounced /ɛskjuːˈɛl/ officially, although the unofficial pronunciation /ˈsiːkwəl/ is often used ( see below )) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management. SQL is a standard interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows the retrieval, insertion, updating, and deletion of data, and performing management and administrative functions. SQL also includes a call-level interface (SQL/CLI) for accessing and managing data and databases remotely. The first version of SQL was developed at IBM by Donald D. Chamberlin

2. SQL Tutorial
In this tutorial you will learn how to use sql to access and manipulate data in Oracle, Sybase, sql Server, DB2, Access, and other database systems.
http://www.w3schools.com/sql/default.asp

HOME

SQL Basic

SQL HOME

SQL Intro

SQL Select

SQL Where
...
SQL Delete

SQL Demo
SQL Try It

SQL Advanced SQL Order By SQL In SQL Between SQL Aliases ... SQL Summary SQL Quiz SQL Quiz Selected Reading Web Statistics Web Glossary Web Hosting Web Quality ... Helping W3Schools
SQL Tutorial
SQL Tutorial
SQL is a standard computer language for accessing and manipulating databases. In this tutorial you will learn how to use SQL to access and manipulate data in Oracle, Sybase, SQL Server, DB2, Access, and other database systems. Start learning SQL!
Table Of Content
SQL Intro An introduction to SQL. SQL SELECT How the SELECT statement is used to select data from a database. SQL WHERE How the WHERE clause is used to conditionally select data. SQL INSERT INTO How the INSERT INTO statement inserts new records (rows) into a database table. SQL UPDATE How to modify data in a database using the UPDATE statement. SQL DELETE How to delete records (rows) in a database, using the DELETE statement.
SQL Demo
SQL Try-It-Yourself Try some SQL statements of your own.
SQL Advanced
SQL ORDER BY The ORDER BY keyword is used to sort the result.

3. Welcome - SQL Database Reference Material - Learn Sql, Read An Sql Manual, Follo
sql.org aims to be both a portal to sql resources on the internet, and a source of original sqlrelated content.
http://www.sql.org/
Welcome
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. We can't possibly do it all alone. If you have any links you wish to share with us, or if you wish to write new content for our site, please contact us Expect new content to be coming online over the coming weeks. Home
Online Resources

General

Beginner Tutorials
...
Contact Us
Random quote of the moment:
You have a deep interest in all that is artistic.
http://www.sql.org/

Proudly designed and hosted by OmegaSphere , providers of all your Web Hosting SSL Certificate , and Domain Name needs!

4. Microsoft SQL Server 2005 Home
Visit this portal for all the latest news and articles to help you evaluate Microsoft sql Server 2005 for your data management and analysis needs.
http://www.microsoft.com/sql/default.mspx
Click Here to Install Silverlight United States Change All Microsoft Sites Search Microsoft.com for:
SQL Server: Home
Site Map Worldwide Free Newsletters ... Microsoft Servers Related Sites SQL Server TechCenter SQL Server Developer Center SQL Server Support Center Trusted platform
Run your most demanding applications Better decisions
Turn insight into action and make better decisions, faster Faster Results
Build, debug, and operate applications faster and more efficiently Highlights
Spotlight: Productive Data Platform
Take a closer look Looking Ahead: SQL Server 2008

5. SQLCourse - Interactive Online SQL Training For Beginners
sqlCourse.com an interactive online training course for sql beginners.
http://www.sqlcourse.com/

6. A Gentle Introduction To SQL
An interactive tutorial. Allows access to tables using any of Oracle, sql Server, Mysql, Access or Postgresql engines.
http://sqlzoo.net/
//Code to deal with "memory" - this inserts previous attempts //Prevent node from collapsing google_ad_client = "pub-0803888854272698"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text"; google_ad_channel = "0392706983"; google_color_border = "336699"; google_color_bg = "FFFFFF"; google_color_link = "0000FF"; google_color_text = "000000"; google_color_url = "008000"; //> Zoo tutorials: SQL SQLzoo.cn Linux Java ... zoo.net Enter your search terms Submit search form Web SQLzoo.net
Quick Ref.
SELECT Functions SELECT
WHERE ...
table
Functions
date number string
Data Types
date number string
Interactive SQL tutorial, learn about: SQL Server Oracle MySQL Mimer PostgreSQL SQLite and Access
Tutorial Section
SELECT:
In which we query the BBC country profile table.
More practice with SELECT:
Additional practice of the basic features using a table of Nobel Prize winners.
SELECT in SELECT:
In which we form queries using other queries.
SUM and COUNT:
In which we apply aggregate functions. more the same
The JOIN operation:
In which we join two tables;

7. JCC Consulting, Inc. Services Page
A source of information about sql standards.
http://www.jcc.com/sql.htm
JCC's SQL Standards Page Home Consulting Training Products ... Search Engine This page is designed to be a central source of information about the SQL standards process and its current state. It also contains pointers to other sources of information about the SQL standard. The information available here is:
  • Current Status
  • Parts of the SQL Standard and Timeline
    Current Status
    While the SQL Standard is often perceived as established technology, rather than the innovative, cutting edge technology it was when the standards process started in early 1980's, it is still an expanding, evolving, relevant standard. The original SQL standard was completed as a USA ANSI (American National Standards Institute) standard in 1986, and adopted as an ISO (International Standards Organization) standard in 1987. Expansions and revisions were released in 1989 and 1992. To allow relevant pieces to progress at different rates, the SQL standard has been divided into multiple parts. Two of these parts were completed in the 1990's, as additions to SQL-1992. SQL/CLI (Call Language Interface) was completed in 1995 and SQL/PSM (Persistent Stored Modules) was completed in 1996. Revisions and expansions to Parts one through five were completed in 1999. Following the completion of SQL:1999, there has been significant work on SQL with Java (a Sun trademark) and XML, as well as the use of SQL to manage data external to an SQL database.

8. SQL Tutorial - SQL Reference And Programming Examples
This sql tutorial aims to teach beginners the building blocks of database language sql. This is also a reference site for sql statements.
http://www.1keydata.com/sql/sql.html
SQL Tutorial

SQL (Structured Query Language) is a computer language aimed to store, manipulate, and retrieve data stored in relational databases. The first incarnation of SQL appeared in 1974, when a group in IBM developed the first prototype of a relational database. The first commercial relational database was released by Relational Software (later becoming Oracle). Standards for SQL exist. However, the SQL that can be used on each one of the major RDBMS today is in different flavors. This is due to two reasons: 1) the SQL standard is fairly complex, and it is not practical to implement the entire standard, and 2) each database vendor needs a way to differentiate its product from others. In this tutorial, such differences are noted where appropriate. This SQL programming help site lists commonly-used SQL statements, and is divided into the following sections:
  • SQL Commands : Basic SQL statements for storing, retrieving, and manipulating data in a relational database. Table Manipulation : How SQL statements are used to manage tables inside the database.

9. What Is SQL? - A Word Definition From The Webopedia Computer Dictionary
This page describes the term sql and lists other pages on the Web where you can find additional information.
http://www.webopedia.com/TERM/S/SQL.html
You are in the: Small Business Computing Channel ECommerce-Guide Small Business Computing Webopedia ... Refer-It Enter a word for a definition... ...or choose a computer category. choose one... All Categories Communications Computer Industry Companies Computer Science Data Graphics Hardware Internet and Online Services Mobile Computing Multimedia Networks Open Source Operating Systems Programming Software Standards Types of Computers Wireless Computing World Wide Web Home
Term of the Day

New Terms

Pronunciation
...
Be a Commerce Partner

SQL Last modified: Wednesday, March 10, 2004 Abbreviation of s tructured q uery l anguage , and pronounced either see-kwell or as separate letters. SQL is a standardized query language for requesting information from a database . The original version called SEQUEL s tructured E nglish que ry l anguage) was designed by an IBM research center in 1974 and 1975. SQL was first introduced as a commercial database system in 1979 by Oracle Corporation. Historically, SQL has been the favorite query language for database management systems running on minicomputers and mainframes . Increasingly, however, SQL is being

10. SQL Tutorial - Learn SQL
sql tutorial featuring a guide to sql language concepts and sql commands.
http://www.sql-tutorial.net/
SQL Tutorial - Learn SQL
SQL Tutorial
SQL Database Table

SQL SELECT

SQL SELECT INTO
...
SQL Hosting
SQL Tutorial
SQL is short for S tructured Q uery L anguage and is a widely used database language, providing means of data manipulation (store, retrieve, update, delete) and database creation. Almost all modern Relational Database Management Systems like MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix use SQL as standard database language. Now a word of warning here, although all those RDBMS use SQL, they use different SQL dialects. For example MS SQL Server specific version of the SQL is called T-SQL, Oracle version of SQL is called PL/SQL, MS Access version of SQL is called JET SQL, etc. Our SQL tutorial will teach you how to use commonly used SQL commands and you will be able to apply most of the knowledge gathered from this SQL tutorial to any of the databases above.
SQL Tutorial Table of Contents
SQL Tutorial
Learn what SQL (Structured Query Language) is, and where and how it is used.

11. SQL Task
Executes a series of sql statements via JDBC to a database. Statements can either be read in from a text file using the src attribute or from between the
http://ant.apache.org/manual/CoreTasks/sql.html
Sql
Description
Executes a series of SQL statements via JDBC to a database. Statements can either be read in from a text file using the src attribute or from between the enclosing SQL tags. Multiple statements can be provided, separated by semicolons (or the defined delimiter ). Individual lines within the statements can be commented using either , // or REM at the start of the line. The autocommit attribute specifies whether auto-commit should be turned on or off whilst executing the statements. If auto-commit is turned on each statement will be executed and committed. If it is turned off the statements will all be executed as one transaction. The onerror attribute specifies how to proceed when an error occurs during the execution of one of the statements. The possible values are: continue execution, only show the error; stop execution and commit transaction; and abort execution and transaction and fail task. Proxies . Some JDBC drivers (including the Oracle thin driver), use the JVM's proxy settings to route their JDBC operations to the database. Since Ant1.7, Ant running on Java1.5 or later defaults to using the proxy settings of the operating system . Accordingly, the OS proxy settings need to be valid, or Ant's proxy support disabled with

12. SQL Server Welcome
sql Server Magazine is the technical guide to managing, mining, building and developing sql Server databases. The magazine includes tips on data recovery,
http://www.sqlmag.com/
SQL Server Magazine
in partnership with Windows IT Pro Monthly Online Pass - Full Web Access + Free Digital Edition
Search
Browse By: Issue Author Subject Department ... Reprints and Licensing var s_account="pentonroadblocks"; var tcdacmd="dt"; var tcdacmd="dt"; var tcdacmd="cc=ady; dt";

13. Welcome To SQL Server Central
Free Microsoft sql Server articles, news, forums, scripts and FAQs.
http://www.sqlservercentral.com/
Log in Register Not logged in Home Articles Editorials Forums ... Write for us
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 693,657 DBAs,developers and SQL Server users
Help us with the Question of the Day! We’re doing a little research into how we might change our popular question of the day and have put together a short survey. It will take less than 5 minutes and you will be entered to win one of three $50 Amazon Gift Certificates. Take the Survey! Headlines today March 31, 2008
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability. Read more... By Timothy A Wiseman Source: SQLServerCentral.com Category: CTE Rating: (not yet rated) Discuss Briefcase 536 reads
Same Report but Different Methods in SQL Server Reporting Services
In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods. Read more...

14. SQL Reference Page
sql Reference Page. This page is obsolete. The authors of this page have not examined many of the tools and resources listed here, and do not make any
http://www.contrib.andrew.cmu.edu/~shadow/sql.html
SQL Reference Page
This page is obsolete. The authors of this page have not examined many of the tools and resources listed here, and do not make any guarantees as to their usefulness. If you discover that a link is out of date, or would like to see something appear here that is missing, send email to
General Information
SQL syntax information
Programming Resources
SQL Software
SQL Tools
Miscellaneous
DBMS info
See Also
Last updated 7/26/95 by Derrick Brashear

15. SQL Tutorial [Introduction]
Complete sql Tutorial using sql92.
http://www.firstsql.com/tutor.htm
SQL Tutorial
Version 2.1
This document is a general tutorial on the database sublanguage - SQL. It is not product oriented but rather uses standard SQL (SQL92). The tutorial doesn't cover all of SQL92; it concentrates on a subset of the standard that is both usable and commonly supported. Note: This tutorial describes the subset of SQL92 supported by FirstSQL/J 100% Java ORDBMS . Feel free to download and use the database for learning and educational purposes. The subset is primarily SQL92 Intermediate Level but has some Entry Level features. The tutorial only describes pure SQL92 capabilities. No proprietary extensions are included. For questions, notes and suggestions on this tutorial contact us at info@firstsql.com
Introduction
SQL (Structured Query Language) is a database sublanguage for querying and modifying relational databases. It was developed by IBM Research in the mid 70's and standardized by ANSI in 1986. The Relational Model defines two root languages for accessing a relational database Relational Algebra and Relational Calculus. Relational Algebra is a low-level, operator-oriented language. Creating a query in Relational Algebra involves combining relational operators using algebraic notation. Relational Calculus is a high-level, declarative language. Creating a query in Relational Calculus involves describing what results are desired. SQL is a version of Relational Calculus. The basic structure in SQL is the

16. SQL Tutorial
This page is a tutorial of the Structured Query Language (also known as sql) and is a pioneering effort on the World Wide Web, as this is the first
http://www.geocities.com/SiliconValley/Vista/2207/sql1.html
Introduction to Structured Query Language
James Hoffman This page is a tutorial of the Structured Query Language (also known as SQL ) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is "ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. It is recommended that you print this page, so that you can easily refer back to previous examples. Table of Contents

17. SQL For Web Nerds
A nicely structured manuscript on sql by Philip Greenspun, based on the Oracle database. Queries, transactions, triggers, and RDBMS concepts are covered.
http://philip.greenspun.com/sql/
SQL for Web Nerds
by Philip Greenspun Preface
  • Introduction
  • Data modeling ...
  • simple queries : one table, one table with subquery, JOIN, JOIN with subquery, OUTER JOIN
  • more complex queries : GROUP BY, aggregates, HAVING
  • Transactions (inserts and updates)
  • triggers
  • views
  • style
  • escaping to the procedural world : PL/SQL and Java executing inside the Oracle server
  • trees
  • handling dates in Oracle
  • limits in Oracle; how they will bite you and how to work around them
  • tuning , what to do when your query runs too slowly
  • data warehousing , what to do when your query doesn't answer your questions
  • foreign and legacy data , making foreign Web sites look like local SQL tables
  • normalization
    Afterword

    Appendix A: Setting up your own RDBMS
    Appendix B: Getting real work done with Oracle More: philg@mit.edu
  • 18. SQL Cheatsheet
    sql Cheatsheet. KEY Curly braces group alternatives together, and alternatives are separated by pipes {this that t other} Clauses in brackets are
    http://www.3gwt.net/demo/SQL_redux.html
    SQL Cheatsheet
    return to 3gwt index

    19. SQL Manager: Database Management Tools For MySQL, SQL Server, PostgreSQL, InterB
    Database Management Tools for Mysql, sql Server, Postgresql, InterBase, Firebird, Oracle, DB2.
    http://www.sqlmanager.net/
    Spring flavour breaking through... Prices taking a fresh turn... Best spring rates for EMS software! ... de en
    Live Chat with Sales rep.
    Sorry, Live Chat operators are offline now. Please, leave a message and we will get back to you ASAP. Learn More
    Main News
    EMS Spring offerings for software and Maintenance purchase
    Check out our spring flavored price offerings! 15% OFF all EMS software till the end of March!
    EMS SQL Tools are now available for Mac and Linux users!

    Parallels desktop virtualization software - trusted solution for launching EMS SQL Tools on Mac and Linux platforms... News Subscribe More News
    Product News
    SQL Manager for MySQL version 4.3 released
    SQL Manager for PostgreSQL version 4.3 released

    SQL Manager 2008 for InterBase/Firebird released

    Support of DB triggers, journaling and incremental backup, support of UTF-8 and Unicode, wizards running in the background mode, many other improvements and new features…
    SQL Manager for SQL Server version 3.1 released

    Support of server objects in Extract Database, Print Metadata, Duplicate Object and other tools; possibility to interrupt report generation, a great number of improvements and bug-fixes…
    Advanced Data Import version 3.0 released

    20. PL/SQL Technology Center
    PL/sql is Oracle s procedural extension to industrystandard sql. PL/sql naturally, efficiently, and safely extends sql. Its primary strength is in
    http://www.oracle.com/technology/tech/pl_sql/index.html

    Page 1     1-20 of 82    1  | 2  | 3  | 4  | 5  | Next 20

    free hit counter