SQL语言_数据库_计算机类_最新资料_得益网

SQL语言艺术

2008-08-07 16:47:49

资深SQL专家Stephane Faroult倾力打造，软件架构设计》作者温昱最新译作，巧妙借鉴《孙子兵法》的智慧结晶。传授25年的SQL性能与调校经验，深入探讨9种常见查询方案及其性能。
　　“一部SQL力作。对于在其他书中止步于理论的难点，本书提供了实际的经验技巧，效果卓然。”
　　　　　　——Sean Hull，资深咨询顾问，Heavyweight百联网集团
　　“一本真正‘聪明’的SQL书，注重实践而非课堂上的理论，解决数据库专业人员遇到的问题。”
　　　　　——Anlhony Molinaro，首席数据库工程师，Wi reless Generation公司
　　你是否把数据库应用看作一场战役？你是否把数据看作一排排需要筛选并打退的敌军纵队？SQL专家Stephane Faroult就是这么做的。
　　《SQL语言艺术》的作者St6phane Faroult借用《孙子兵法》的智慧处理SQL性能方面的问题。开发数据库应用好比一场战役，设计即战略，而每次数据库访问就是与敌军在战术上的对决。
　　Stephane对SQL性能问题的论述，视角独特，一丝不苟。如何才能更好地使用SQL?本书结合一线实践的案例，强调了：
应从最开始就综合设计数据库和应用的性能。“只强调某个最重要方面的设计是错误的”。
应避免只考虑单个SQL语句。“关注总的目标，SQL语句再好也挽救不了糟糕的处理流程”。
必须明白为哪些字段建立索引、为何建立索引。“索引过多是设计不确定的表现”。
Stephane还对你的实际工作提出了具体建议。九种SQL经典查询方案，以及对其性能影响的讨论，非常便于实践。书中有一章专门讨论树状结构，可帮助你解决层次结构数据的问题。另外，当你必须基于别人的数据库设计进行工作时，“精于计谋：挽救响应时间”这一章会助你成功。

数据库基础视频

2008-07-11 12:15:16

Flash全程教学,通俗易懂

Teach Yourself SQL in 24 Hours 4th Edition (24小时自学SQL 第四版 2008最新版)

2008-06-20 09:20:32

In just 24 lessons of one hour or less, you will learn professional
techniques to design and build efficient databases and query them to
extract useful information. Using a straightforward, step-by-step
approach, each lesson builds on the previous one, allowing you to learn
the essentials of ANSI SQL from the ground up.

Example code demonstrates the authors’ professional techniques, while
exercises written for MySQL offer the reader hands-on learning with an
open-source database. Included are advanced techniques for using views,
managing transactions, database administration, and extending SQL.

Step-by-step instructions carefully walk you through the most common SQL
tasks.
Q&As, Quizzes, and Exercises at the end of each chapter help you test
your knowledge.
Notes and Tips point out shortcuts and solutions.
New terms are clearly defined and explained.

Learn how to…
- Use SQL-2003, the latest standard for the Structured Query Language
- Design and deploy efficient, secure databases
- Build advanced queries for information retrieval
- Sort, group, and summarize information for best presentation
- Tune databases and queries for maximum performance
- Understand database administration and security techniques

For more than ten years the authors have studied, applied, and
documented the SQL standard and its application to critical database
systems.

Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders
of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and
consulting firm which specializes in database technologies. They taught
database courses for Indiana University—Purdue University in
Indianapolis for five years and have authored more than a dozen books on
Oracle, SQL, database design, and the high availability of critical
systems.

Arie D. Jones is Senior SQL Server database administrator and analyst
for PTI. He is a regular speaker at technical events and has authored
several books and articles.

Introduction................................................................................ 1
Part I: A SQL Concepts Overview
HOUR 1 Welcome to the World of SQL ........................................................ 7
Part II: Building Your Database
HOUR 2 Defining Data Structures ............................................................. 27
3 Managing Database Objects ........................................................ 41
4 The Normalization Process .......................................................... 61
5 Manipulating Data .................................................................... 73
6 Managing Database Transactions................................................. 87
Part III: Getting Effective Results from Queries
HOUR 7 Introduction to the Database Query ............................................ 101
8 Using Operators to Categorize Data............................................. 117
9 Summarizing Data Results from a Query ..................................... 141
10 Sorting and Grouping Data........................................................ 151
11 Restructuring the Appearance of Data ......................................... 165
12 Understanding Dates and Times ................................................. 185
Part IV: Building Sophisticated Database Queries
HOUR 13 Joining Tables in Queries ........................................................... 203
14 Using Subqueries to Define Unknown Data................................... 221
15 Combining Multiple Queries into One ......................................... 235
Part V: SQL Performance Tuning
HOUR 16 Using Indexes to Improve Performance ........................................ 253
17 Improving Database Performance ............................................... 265
Part VI: Using SQL to Manage Users and Security
HOUR 18 Managing Database Users ......................................................... 283
19 Managing Database Security...................................................... 297
Part VII: Summarized Data Structures
HOUR 20 Creating and Using Views and Synonyms..................................... 313
21 Working with the System Catalog ............................................... 329
Part VIII: Applying SQL Fundamentals in Today’s World
HOUR 22 Advanced SQL Topics ................................................................ 343
23 Extending SQL to the Enterprise, the Internet, and the Intranet........ 359
24 Extensions to Standard SQL........................................................ 369
Part IX: Appendixes
A Common SQL Commands ......................................................... 381
B Using MySQL for Exercises ......................................................... 387
C Answers to Quizzes and Exercises ................................................ 391
D CREATE TABLE Statements for Book Examples ................................ 435
E INSERT Statements for Data in Book Examples .............................. 437
F Bonus Exercises ........................................................................ 441
Glossary.................................................................................. 447
Index ..................................................................................... 451

Beginning SQL Queries. From Novice to Professional

2008-04-30 07:34:15

Beginning SQL Queries. From Novice to Professional

Author: Clare Churcher
Publisher: Apress
Number Of Pages: 240
Publication Date: 2008-04-09
ISBN-10/ASIN: 1590599438
ISBN-13/EAN: 9781590599433
Binding: Paperback

Clare Churcher's Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.

Does not bore with syntax!
Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
Provides exceptionally clear examples and explanations
Is academically sound while being practical and approachable

What you'll learn?
Write simple queries to extract data from a single table.
Understand relational algebra and calculus and why they are important.
Combine data from many tables into one business result.
Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
Summarize large amounts of data for reporting purposes.
Apply set theory to the problems of manipulating data and generating reports.

Who is this book for?
Beginning SQL Queries is aimed at intelligent laypeople who need to extract information from a database, and at developers and other IT people who are new to SQL. The book is especially useful for business intelligence analysts who must ask more complex questions of their database than their GUI–based reporting software supports. Such people might be business owners wanting to target specific customers, scientists and students needing to extract subsets of their research data, or end users wanting to make the best use of databases for their clubs and societies.

About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You'll start your journey by seeing what you need to know—but without needless theory and filler. You'll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!

Related Titles
Beginning Database Design: From Novice to Professional
Date on Database: Writings 2000-2006
Applied Mathematics for Database Professionals

Contents
Beginning SQL Queries: From Novice to Professional 1
Contents at a Glance 7
Contents 9
About the Author 15
About the Technical Reviewer 17
Acknowledgments 19
Introduction 21
Unknown
Two-Pronged Approach 21
Who This Book Is For 22
Objective of This Book 22
Relational Database Overview 23
What Is a Relational Database? 23
Introducing Data Models 24
Introducing Tables 26
Inserting and Updating Rows in a Table 27
Designing Appropriate Tables 29
Maintaining Consistency Between Tables 31
Retrieving Information from a Database 32
Relational Algebra: Specifying the Operations 33
Relational Calculus: Specifying the Result 35
Why Do We Need Both Algebra and Calculus? 36
Summary 37
Simple Queries on One Table 39
Retrieving a Subset of Rows 42
Relational Algebra for Retrieving Rows 42
Relational Calculus for Retrieving Rows 42
SQL for Retrieving Rows 43
Retrieving a Subset of Columns 44
Relational Algebra for Retrieving Columns 44
Relational Calculus for Retrieving Columns 44
SQL for Retrieving Columns 45
Using Aliases 45
Combining Subsets of Rows and Columns 46
Saving Queries 47
Specifying Conditions for Selecting Rows 47
Comparison Operators 48
Logical Operators 49
Dealing with Nulls 51
Comparing Null Values 53
Finding Nulls 54
Managing Duplicates 54
Ordering Output 57
Performing Simple Counts 57
Avoiding Common Mistakes 58
Misusing Select to Answer Questions with the Word fbothf 60
Misusing Select Operations to Answer Questions with the Word fiotf 61
Summary 61
A First Look at Joins 63
Joins in Relational Algebra 63
Cartesian Product 63
Inner Join 65
SQL for Cartesian Product and Join 66
Joins in Relational Calculus 67
Extending Join Queries 68
An Algebra Approach 69
Order of Algebra Operations 72
A Calculus Approach 73
Expressing Joins Through Diagrammatic Interfaces 75
Other Types of Joins 76
Summary 80
Nested Queries 83
IN Keyword 83
Using IN with a Nested Query 84
Being Careful with NOT and <> 86
EXISTS Keyword 89
Different Types of Nesting 91
Inner Queries Returning a Single Value 92
Inner Queries Returning a Set of Values 94
Inner Queries Checking for Existence 94
Using Nested Queries for Updating 95
Summary 97
Self Joins 99
Self Relationships 99
Creating a Self Join 101
Queries Involving a Self Join 102
What Are the Names of the Coaches? 103
Who Is Being Coached by Someone with a Higher Handicap? 103
List the Names of All the Members and the Names of Their Coaches 103
Who Coaches the Coaches, or Who Is My Grandmother? 105
A Calculus Approach to Self Joins 107
Questions Involving fiBthf 110
A Calculus Approach to Questions Involving fiothf 112
An Algebra Approach to Questions Involving fiothf 113
Summary 114
Self Relationships 114
Questions Involving the Word fBothf 115
More Than One Relationship Between Tables 117
Representing Multiple Relationships Between Tables 117
Algebra Approach to Two Relationships Between Tables 119
Calculus Approach to Two Relationships Between Tables 123
Business Rules 124
Summary 127
Set Operations 129
Overview of Basic Set Operations 130
Union-Compatible Tables 131
Union 133
Ensuring Union Compatibility 134
Selecting the Appropriate Columns 135
Uses for Union 136
Intersection 139
Uses of Intersection 139
The Importance of Projecting Appropriate Columns 142
Managing Without the INTERSECT Keyword 144
Difference 145
Uses of Difference 146
Managing Without the EXCEPT Keyword 148
Division 149
Projecting Appropriate Columns 151
SQL for Division 152
Summary 154
Aggregate Operations 155
Simple Aggregates 155
The COUNT Function 155
The AVG Function 158
Other Aggregate Functions 160
Grouping 161
Filtering the Result of an Aggregate Query 165
Using Aggregates to Perform Division Operations 167
Nested Queries and Aggregates 169
Summary 172
Efficiency Considerations 175
Indexes 175
Types of Indexes 176
Indexes for Efficiently Ordering Output 179
Indexes and Joins 180
What Should We Index? 182
Query Optimizer 183
What Does the Query Optimizer Consider? 183
Does the Way We Express the Query Matter? 184
Summary 189
How to Approach a Query 191
Understanding the Data 191
Determine the Relationships Between Tables 191
The Conceptual Model vs. the Implementation 193
What Tables Are Involved? 195
Look at Some Data Values 196
Big Picture Approach 196
Combine the Tables 197
Find the Subset of Rows 198
Retain the Appropriate Columns 199
Consider an Intermediate View 200
Spotting Key Words in Questions 201
And, Both, Also 201
Not, Never 204
All, Every 205
No Idea Where to Start? 205
Find Some Helpful Tables 205
Try to Answer the Question by Hand 205
Write Down a Description of the Retrieved Result 206
Is There Another Way? 207
Checking Queries 208
Check a Row That Should Be Returned 209
Check a Row That Should Not Be Returned 209
Check Boundary Conditions 209
Check Null Values 210
Summary 210
Common Problems 213
Poor Database Design 213
Data That Is Not Normalized 213
No Keys 216
Similar Data in Two Tables 217
Wrong Types 218
Problems with Data Values 219
Unexpected Nulls 219
Wrong or Inconsistent Spelling 219
Extraneous Characters in Text Fields 220
Inconsistent Case in Text Fields 221
Diagnosing Problems 222
Check Parts of Nested Queries Independently 223
Understand How the Tables Are Being Combined 223
Remove Extra WHERE Clauses 223
Retain All the Columns 224
Check Underlying Queries in Aggregates 224
Common Symptoms 224
No Rows Are Returned 224
Rows Are Missing 225
Should You Have an Outer Join? 225
Have Selection Conditions Dealt with Nulls Appropriately? 225
Are You Looking for a Match with a Text Value? 226
Have You Used AND Instead of OR? 226
Do You Have Correct Columns in Set Operations? 227
More Rows Than There Should Be 227
Did You Use NOT Instead of Difference? 227
Have You Dealt with Duplicates Appropriately? 228
Statistics or Aggregates Incorrect 229
The Order Is Wrong 229
Common Typos and Syntax Problems 229
Summary 230
Sample Database 231
Index 233

Head First SQL

2008-03-31 10:55:42

HEAD FIRST系统经典好书。
AMAZON五星评价。

目录：
Table of Contents (Summary)
Table of Contents (the real thing)
Your brain on SQL. Here you are trying to learn something, while here
your brain is doing you a favor by making sure the learning doesn’t stick. Your
brain’s thinking, “Better leave room for more important things, like which wild
animals to avoid and whether naked snowboarding is a bad idea.” So how do you
trick your brain into thinking that your life depends on knowing SQL?
Intro
Who is this book for? xxvi
We know what you’re thinking xxvii
Metacognition xxix
Bend your brain into submission xxxi
Read me xxxii
The technical review team xxxiv
Acknowledgments xxxv
Intro xxv
1 Data and Tables: A place for everything 1
2 The SELECT Statement: Gifted data retrieval 53
3 DELETE and UPDATE: A change will do you good 119
4 Smart Table Design: Why be normal? 159
5 ALTER: Rewriting the past 197
6 Advanced SELECT: Seeing your data with new eyes 235
7 Multi-table Database Design: Outgrowing your table 281
8 Joins and Multi-table Operations: Can’t we all just get along? 343
9 Subqueries: Queries Within Queries 379
10 Outer Joins, Self Joins, and Unions: New maneuvers 417
11 Constraints, Views, and Transactions: Too many cooks spoil the database 455
12 Security: Protecting your assets 493

SQL Queries for Mere Mortals. A Hands-On Guide to Data Manipulation in SQL, 2nd Edition (新版)

2007-11-28 13:32:03

SQL Queries for Mere Mortals. A Hands-On Guide to Data Manipulation in SQL, 2nd Edition (新版)

Author: John L. Viescas, Michael J. Hernandez
Publisher: Addison-Wesley Professional
Number Of Pages: 672
Publication Date: 2007-10-04
ISBN-10 / ASIN: 0321444434
ISBN-13 / EAN: 9780321444431
Binding: Paperback

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book!
--Graham Mandeno, Database Consultant

SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries
--Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee

I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the "watch out for this trap" items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database.
--Kenneth D. Snell, Ph.D., Database Designer/Programmer

I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd's original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy.
--Arvin Meyer, MCP, MVP

Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what's usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I'm sure it'll get so much use that it won't spend much time on the shelf!
-- Doug Steele, Microsoft Access Developer and author

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users.

The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

SQL必知必会(第3版)

2007-09-15 13:28:44

SQL是目前使用最为广泛的数据库语言之一。本书没有涉及理论，而是从实践出发，由浅入深地讲解了广大读者所必需的SQL 知识，适用于各种主流数据库。实例丰富，便于查阅。本书涉及不同平台上数据的排序、过滤和分组，以及表、视图、联结、子查询、游标、存储过程和触发器等内容，通过本书读者可以系统地学习到SQL 的知识和方法。.
本书注重实用性，操作性很强，适合于SQL 的初学者学习和广大软件开发及管理人员参考。
SQL语法简洁，使用方式灵活，功能强大，已经成为当今程序员不可或缺的技能。..
本书是深受世界各地读者欢迎的SQL经典畅销书，内容丰富，文字简洁明快，针对Oracle、SQL Server、MySQL、DB2、Sybase、PostgreSQL、Access等各种主流数据库提供了大量简明的实例。与其他同类图书不同，它没有过多阐述数据库基础理论，而是专门针对一线软件开发人员，直接从SQL SELECT开始，讲述实际工作环境中最常用和最必需的SQL知识，实用性极强。通过本书，读者能够从没有多少SQL经验的新手，迅速编写出世界级的SQL！
本书是麻省理工学院、伊利诺伊大学等众多大学的参考教材。除了作为教程之外，独特的编排方式还使本书成为方便的快速查询手册

Chapter 2 Data Warehouse and OLAP Technology for Data Mining

2007-09-13 16:22:38

本书阐述了数据挖掘（通常称为数据库知识发现）的概念、方法和应用。从强调数据分析入手，介绍了数据库和数据挖掘的概念，指出数据挖掘是对大型数据库、数据构件库和其他大型信息资源中标识知识含义的那些类型的自动的或便捷的提取，并通过一个通用的框架回顾了当前的市场可供产品。数据挖掘是一个跨学科的知识领域，汲取了数据库技术、人工智能、机器学习、神经网络、统计学、模式识别、知识库系统、知识获取、信息检索、高性能计算、数据可视化等方面的成果，本书内容从数据库的视角，描述了数据挖掘系统的原型、结构、特征、方法，重点讲解了数据挖掘的可行性、实用性、有效性和大型数据库中模型发现的可测量性等问题。本书逐章讲解了数据分类、预测、联结和分组的概念和技术，这些专题都配有实例，对各类问题都分别列举了最佳算法，并对怎样运用技术给出了经过实践检验的实用型规则。这种讲述方式决定了本书的可读性强，能够使读者从中学到数据挖掘领域的知识，了解产业最新动向。本书适用于计算机科学系的学生、应用软件开发人员、商业领域的专家和相关知识领域的科技研究人员。

Chapter 1 Introduction

2007-09-13 16:21:05

自我管理数据库-自动的sql调优

2007-08-17 14:01:00

oreilly, inside sqlite, apr 2007

2007-08-03 19:01:19

SQLite is different from most other modern SQL databases in the sense that its primary design goal is to be simple. SQLite strives to be simple, even if it leads to occasional inefficient implementations of some features. It is simple to maintain, customize, operate, administer, and embed in C applications. It uses simple techniques to implement ACID properties.

PostgreSQL Essential Reference

2007-06-27 14:13:48

PostgreSQL is the fastest, most comprehensive guide to PostgreSQL, this book provides you with:

A complete SQL command reference

A full listing of the built-in PostgresSQL operators, data types, and functions

The necessary tools for programming PostgreSQL with Perl, Python, PHP, C and C++, ODBC, and JDBC

A noteworthy accomplishment of this book is the layout - all the subjects are clearly presented, and the reference style makes looking up information quick and easy. Each topic is arranged both by task and alphabetically, and includes important information such as feature notes, syntax, and example code.

嵌入式数据库简介-SQLite

2007-06-05 21:27:26

纲要
SQLite介绍
SQLite的发展
SQLite的优势
SQLite的缺憾
SQLite的内部结构
SQLite数据库的使用
SQLite的命令行接口
SQLite命令行使用
SQLite数据库的编程接口
C/C++接口
简单应用
自定义简单函数
自定义聚合函数
自定义排序函数
PERL接口
SQLite数据库在ASTRAL中的应用
SQLite在多级关联中的应用
SQLite在IPIS中的应用
SQLite在web中的应用

The Programmer's Guide to SQL

2007-06-01 23:26:18

The book covers the latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications.

Table of Contents
The Programmer's Guide to SQL
Introduction
Chapter 1 - Understanding SQL and Relational Databases
Chapter 2 - Retrieving Data with SQL
Chapter 3 - Modifying Data
Chapter 4 - Summarizing and Grouping Data
Chapter 5 - Performing Calculations and using Functions
Chapter 6 - Combining SQL Queries
Chapter 7 - Querying Multiple Tables
Chapter 8 - Hiding Complex SQL with Views
Chapter 9 - Using Stored Procedures
Chapter 10 - Transactions
Chapter 11 - Users and Security
Chapter 12 - Working with Database Objects
Chapter 13 - Triggers
Chapter 14 - Case Study: Building a Product Catalog
Chapter 15 - Case Study: Implementing Role-Based Security
Appendix A - Executing SQL Statements
Appendix B - Setting up the InstantUniversity Database
Appendix C - Data Types
Index
List of Figures
List of Tables
List of Examples
List of Sidebars

东南大学SQL数据库基础视频教学全42讲(3-9)

2007-05-14 14:18:12

东南大学SQL数据库基础视频教学全42讲(27-32)

2007-05-14 14:18:10

东南大学SQL数据库基础视频教学全42讲(26)

2007-05-14 13:00:50

东南大学SQL数据库基础视频教学全42讲(25)

2007-05-14 13:00:50

东南大学SQL数据库基础视频教学全42讲(24)

2007-05-14 13:00:50

东南大学SQL数据库基础视频教学全42讲(23)

2007-05-14 13:00:49

东南大学SQL数据库基础视频教学全42讲(22)

2007-05-14 13:00:49

东南大学SQL数据库基础视频教学全42讲(21)

2007-05-14 12:54:47

东南大学SQL数据库基础视频教学全42讲(20)

2007-05-14 12:54:47

东南大学SQL数据库基础视频教学全42讲(2)

2007-05-14 12:54:46

东南大学SQL数据库基础视频教学全42讲(19)

2007-05-14 12:54:46

东南大学SQL数据库基础视频教学全42讲(18)

2007-05-14 12:54:43

东南大学SQL数据库基础视频教学全42讲(17)

2007-05-14 12:54:43

东南大学SQL数据库基础视频教学全42讲(16)

2007-05-14 12:54:42

东南大学SQL数据库基础视频教学全42讲(15)

2007-05-14 12:54:41

东南大学SQL数据库基础视频教学全42讲(14)

2007-05-14 12:54:41

东南大学SQL数据库基础视频教学全42讲(13)

2007-05-14 12:54:39

东南大学SQL数据库基础视频教学全42讲(12)

2007-05-14 12:43:13

东南大学SQL数据库基础视频教学全42讲(11)

2007-05-14 12:43:12

东南大学SQL数据库基础视频教学全42讲(10)

2007-05-14 12:43:12

东南大学SQL数据库基础视频教学全42讲(1)

2007-05-14 12:43:11

Joe Celko's SQL for Smarties Advanced SQL Programming (3rd Edition)

2007-04-29 11:05:09

This book is for the working SQL programmer who wants to pick up some advanced programming tips and techniques. It assumes that the reader is an SQL programmer with a year or more of experience. It is not an introductory book.

SQL in Nutshell

2007-04-26 17:19:58

Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are
registered trademarks of O’Reilly & Associates, Inc. The association between the
image of a chameleon and the topic of SQL is a trademark of O’Reilly & Associates,
Inc.
Many of the designations used by manufacturers and sellers to distinguish their
products are claimed as trademarks. Where those designations appear in this book,
and O’Reilly & Associates, Inc. was aware of a trademark claim, the designations
have been printed in caps or initial caps.
While every precaution has been taken in the preparation of this book, the publisher
assumes no responsibility for errors or omissions, or for damages resulting from the
use of the information contained herein.

基于P2P的分布式数据库模型研究

2007-04-24 18:35:05

基于P2P的分布式数据库模型研究

SQL入门到精通

2007-04-24 16:23:28

XML-to-SQL Query Translation

2007-04-17 10:08:16

xml 转成　sql 查询

Real_Time_SQL的设计和实现.nh(caj)

2007-04-16 08:28:07

摘要:
Real-Time SQ以RTSQL)是用户管理、控制实时数据库的标准接口。RTSQL对于实时
数据库的作用，如同SQL对于传统的关系型数据库的作用一样重要。
与传统关系数据库相比，实时数据库具有三个特征:数据的时态一致性、事务的时态
一致性、实时事务执行时必须具有可预测性。由于这些特征的存在，传统关系型数据库的
SQL语言(SQL92)不能直接应用于实时数据库系统，需要为实时数据库系统设计专用的
RTSQL语言。目前国内外研究RTSQL所采用的一般方法，是结合实时数据库的特点，对
SQL92进行扩展，使其支持实时特性。
本论文主要讨论如何对SQL92语言进行实时扩展，以构造实时数据库系统的结构化
查询语言RTSQL。对SQL92的扩展主要体现在:数据时态一致性约束的表达和检测，事
务执行时态一致性约束的表达和检测，为提高事务执行的可预测性而对其使用的系统资源
进行限制性说明，以及为了更好适应实时要求而提供灵活ACID特性的事务结构说明。
本文另一成果是设计了一种基于ODBC标准的RTSQL实现框架，并开发了一个原型
系统—Agilor RTSQLo Agilor RTSQL是针对实时数据库系统Agilor的数据操作语言。
关键词:实时数据库，数据操作语言，RTSQL} SQL

PLsql developer用户指南

2007-04-11 22:09:36

这个关于PLSQL dEVELOPER的，我个人认为教的很详细，容易懂。有兴趣的朋友可以看一下。

TERADATA 培训资料

2007-04-10 09:05:35

TERADATA 培训资料,PPT文档,NCR中文培训

The.Art.of.SQL

2007-03-24 15:25:07

The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

已编译的ADO HTML 帮助文件

2007-03-15 17:52:36

收集来的已编译的ADO HTML 帮助文件
简体中文

最易入门SQL语句教程

2007-03-12 15:50:09

目录
SQL语句教程(01) SELECT
SQL语句教程(02) DISTINCT
SQL语句教程(03) WHERE
SQL语句教程(04) AND OR
SQL语句教程(05) IN
SQL语句教程(06) BETWEEN
SQL语句教程(07) LIKE
SQL语句教程(08) ORDER BY
SQL语句教程(09) 函数
SQL语句教程(10) COUNT
SQL语句教程(11) Group By
SQL语句教程(12) HAVING
SQL语句教程(13) ALIAS
SQL语句教程(14) 连接
SQL语句教程(15) 外部连接
SQL语句教程(16) Subquery
SQL语句教程(17) UNION
SQL语句教程(18) UNION ALL
SQL语句教程(19) INTERSECT
SQL语句教程(20) MINUS
SQL语句教程(21) Concatenate
SQL语句教程(22) Substring
SQL语句教程(23) TRIM
SQL语句教程(24) Create Table
SQL语句教程(25) Create View
SQL语句教程(26) Create Index
SQL语句教程(27) Alter Table
SQL语句教程(28) 主键
SQL语句教程(29) 外来键
SQL语句教程(30) Drop Table
SQL语句教程(31) Truncate Table
SQL语句教程(32) Insert Into
SQL语句教程(33) Update
SQL语句教程(34) Delete

SQL语法手册之htm版

2007-02-27 21:02:43

SQL语法手册之htm版

sql for dummies, 6th edition

2007-01-31 13:15:26

Introduction:
Relational database management systems are vital to many organizations.
People often think that creating and maintaining these systems are extremely
complex activities — the domain of database gurus who possess enlightenment
beyond that of ordinary mortals. This book sweeps away the database
mystique. In this book, you
 Get to the roots of databases.
 Find out how a DBMS is structured.
 Discover the major functional components of SQL.
 Build a database.
 Protect a database from harm.
 Operate on database data.
 Determine how to get the information you want out of a database.
The purpose of this book is to help you build relational databases and get valuable
information out of them by using SQL. SQL is the international standard
language used around the world to create and maintain relational databases.
This edition covers the latest version of the standard, SQL:2003, as augmented
in 2005 with a thorough treatment of the use of XML with SQL.
This book doesn’t tell you how to design a database (I do that in Database
Development For Dummies, also published by Wiley Publishing, Inc.). Here I
assume that you or somebody else has already created a valid design. I then
illustrate how you implement that design by using SQL. If you suspect that
you don’t have a good database design, by all means, fix your design before
you try to build the database. The earlier you detect and correct problems in
a development project, the cheaper the corrections will be.

SQL认证题库

2007-01-22 15:00:28

供考认证的同学参考

sql经典教程

2007-01-17 18:21:59

通用SQL的经典教程包括 SQL基础、中级SQL、高级SQL