[PostgreSQL] SQL基础教程
本书是畅销书《SQL基础教程》第2版，介绍了关系数据库以及用来操作关系数据库的SQL语言的使用方法。书中通过丰富的图示、大量示例程序和详实的操作步骤说明，让读者循序渐进地掌握SQL的基础知识和使用技巧，切实提高编程能力。每章结尾设置有练习题，帮助读者检验对各章内容的理解程度。另外，本书还将重要知识点总结为“法则”，方便读者随时查阅。第2版除了将示例程序更新为对应*新的DB的SQL之外，还新增了一章，介绍如何从应用程序执行SQL。
This book is the second edition of the best-selling book "SQL basic course". It introduces the use of relational database and SQL language used to operate relational database. Through abundant diagrams, a large number of sample programs and detailed operation steps, the book enables readers to master the basic knowledge and skills of SQL step by step, so as to improve their programming ability. Exercises are set at the end of each chapter to help readers test their understanding of each chapter. In addition, this book also summarizes the important knowledge points as "rules", which is convenient for readers to consult at any time. In addition to updating the sample program to the SQL corresponding to the * new DB, version 2 also added a chapter on how to execute SQL from the application. (2021-04-08, SQL, 11373KB, 下载0次)
[数据库编程] databasesql
数据库是企业信息的核心，其应用水平的高低直接影响到企业管理水平。选择了一个高性能的数据库产品不等于就有一个好的数据库应用系统，如果数据库系统设计不合理，不仅会增加客户端和服务器端程序的编程和维护的难度，而且还会影响系统实际运行的性能。本专题主要讲解数据库各种性能优化技术，从而避免磁盘I/O瓶颈、减少CPU利用率和减少资源竞争。希望对广大读者有益。
The database is the core of enterprise information, the application level of a direct impact on the enterprise management level. Selected a high-performance database product does not mean that there is a good database application system, database system design is unreasonable, will not only increase the difficulty of the client and server side programming and maintenance, but also affect the system, the actual operation properties. The topic to explain the database of various performance optimization techniques, in order to avoid disk I/O bottlenecks, reducing CPU utilization and reduce competition for resources. I hope the readers useful. (2012-07-06, SQL, 30559KB, 下载5次)
[数据库编程] jiaocaiguanli
（一）本系统要求采用数据库存储数据,并在图形用户接口方式下进行工作,编程语言可自选,比如C#、VB、VB.NET、CBuilder、Delphi等均可。
该系统主要包括以下功能:
教材信息处理（包括增加、删除和修改）
教材查询处理（包括精确查询、模糊查询等，实现多条件查询）
教材发放和回收处理
统计处理等。
(A) The system requires a database to store data, and the graphical user interface mode, programming languages can be optional, such as C#, VB, VB.NET, CBuilder, Delphi and other can be. The system includes the following features: teaching materials (including the increase in information processing, deletions, and modifications) textbooks query processing (including the exact queries, fuzzy queries, etc., to achieve multi-criteria query) textbook issuance and disposal of statistical processing. (2012-06-03, SQL, 3607KB, 下载9次)
[WEB开发] MySQL-manual
MySQL是一个精巧的SQL数据库管理系统，虽然它不是开放源代码的产品，但在某些情况下你可以自由使用。由于它的强大功能、灵活性、丰富的应用编程接口（API）以及精巧的系统结构，受到了广大自由软件爱好者甚至是商业软件用户的青睐，特别是与Apache和PHP/PERL结合，为建立基于数据库的动态网站提供了强大动力。
MySQL is a sophisticated SQL database management system, although it is not open source products, but in some cases you can freely use. Because of its powerful features, flexibility, rich application programming interface (API) as well as sophisticated system architecture by a majority of free software enthusiasts and even commercial software users of all ages, especially combined with Apache and PHP/PERL for the establishment of database-based dynamic web site to provide a powerful force. (2012-05-20, SQL, 449KB, 下载2次)
[SQL Server] exam_Data
SQL是高级的非过程化编程语言，是沟通数据库服务器和客户端的重要工具，允许用户在高层数据结构上工作。它不要求用户指定对数据的存放方法，也不需要用户了解具体的数据存放方式，所以，具有完全不同底层结构的不同数据库系统，可以使用相同的SQL语言作为数据输入与管理的接口。它以记录集合作为操作对象，所有SQL语句接受集合作为输入，返回集合作为输出，这种集合特性允许一条SQL语句的输出作为另一条SQL语句的输入，所以SQL语句可以嵌套，这使它具有极大的灵活性和强大的功能，在多数情况下，在其他语言中需要一大段程序实现的功能只需要一个SQL语句就可以达到目的，这也意味着用SQL语言可以写出非常复杂的语句。
SQL is advanced the process programming language, is communication database server and client important tool that allows users to work on top in data structure. It does not require the user to the storage of data specified method, also do not need to users understand the specific data storage way, so, with a fully different ground floor of the different structure database system, can use the same SQL language input and management as data interface. It set a record as the operation object, all the SQL statement accept set as input, return to set as the output, this set features allow an SQL statement output as another an SQL statement input, so the SQL statement may be nested, this make it has great flexibility and powerful functions, in most cases, in other languages need a large section of the program of the realization of the function only need a SQL statement be able to achieve a goal, it also means using SQL language can write very complex statement.
(2012-05-01, SQL, 98KB, 下载2次)
[行业发展研究] chaoshishouyinshitongsheji
随着现代科学技术的迅猛发展，计算机技术已渗透到各个领域，成为各行业必不可少的工具。在当今激烈的市场竞争中,让顾客享受既实惠又快捷的购物服务是商战中制胜的一大要素。改革开放的今天,各种大型超市林立,超市已成为消费者日常活动的主要场所。而超市商品也非常之多,建立一套方便快捷的超市收费系统是企业必然要解决的一个问题。系统采用的编程工具是Delphi 7.0版本与Access作为数据库。
With the rapid development of modern science and technology, computer technology has penetrated into every field, become the necessary tools for various industries. In the furious market competition, let the customer enjoy both affordable and rapid shopping service is putting a big factor in winning. The reform and open policy the today, with various kinds of large supermarket, the supermarket has become the principal place of consumer daily activities. And the supermarket is very many commodities, and a set of convenient supermarket fee system is the enterprise must solve a problem. The system of the programming tool is Delphi 7.0 version and Access as a database. (2011-12-27, SQL, 318KB, 下载2次)
[Oracle数据库] ORACLE-training-plan-
ORACLE的简单介绍，以及各种sql语法的简单介绍，ORACLE公司是一家提供综合技术产品、方案、服务的数据库公ORACLE数据库设计成可大量存储数据，快速查询数据，保证数据的安全和一致性，跨网络的分布式管理及客户-服务器的配置等。RACLE SQL语法符合ANSI 1986标准SQL和数据库交流的命令式语言
QL*PLUS ORACLE的一种工具, 用来运行SQL和PL/SQL语句PL/SQL ORACLE的过程化编程语言
ORACLE s simple introduction, and all sorts of SQL syntax of simple introduction, ORACLE company is to provide a comprehensive technology products, solutions and services database and ORACLE database designed to a large store data, fast inquires, ensure data security and data consistency across the network, the distributed management and client/server configuration, etc. RACLE SQL syntax meet ANSI 1986 standard SQL database and the language communication imperative
From QL* PLUS the ORACLE a tool, used to run the SQL and PL/SQL statements PL/SQL ORACLE s process programming language (2011-06-22, SQL, 70KB, 下载7次)
[Oracle数据库] Oracle_11g_Beginer_Guide
《Oracle Database 11g初学者指南》能使读者快捷地掌握Oracle Database 11g的基础知识。通过自我评估教程，介绍了核心数据库技术、管理员职责、高可用性以及大型数据库特性。本书带领读者循序渐进地学习数据库设置、管理、编程、备份和恢复。还深入介绍了SQL和PL/SQL。为了易于学习，这本独特的Oracle Press指南是这样组织的：
● 核心概念——Oracle Database 11g主题呈现在按逻辑组织的章节中
● 主要内容——每章要介绍的具体内容列表
● 实践练习——演示如何应用在每章学到的关键技术
● 学习效果测试——对学习效果的快速自我评估
● 注意——与所介绍主题相关的额外信息
● 章节测验——每章结束时的测验测试读者对所学知识的掌握程度
"Oracle Database 11g A Beginner s Guide" enables readers to quickly grasp the basics of Oracle Database 11g. Through self-assessment tutorial introduces the core database technology, administrator duties, high availability and large database features. This book takes the reader step by step learning database setup, management, programming, backup and recovery. Additional details of SQL and PL/SQL. For ease of learning, this unique Oracle Press guide is organized like this:
● Core Concepts- Oracle Database 11g logical organization of topics presented in the chapter by
● main content- each chapter a list of the specific content to be introduced
● practical exercises- how to use the learned in each chapter the key technology
● learning test- on the fast learning self-assessment
● Note- with the introduction of additional information relevant to the subject
● chapter test- the test at the end of each chapter test readers mastery of the knowledge
(2010-11-14, SQL, 3859KB, 下载44次)
[Oracle数据库] Oracle_Trigger_Storaged_Procedure_Programming
数据库专家Kevin Owens是美国财政部计算机中心的Oracle数据库管理员，他将与您共同探讨PL/SQL——Oracle的结构化查询语言（SQL），并教您如何通过构建健壮、大型的数据库来解决您的业务问题。
本书语言通俗易懂，并引入大量代码示例。书中详细介绍了许多技术来利用Oracle的特性，如触发器和存储过程等。这些特性支持数据库结合业务规则，并可以根据业务的发展变化对规则进行管理和修改。本书讨论的主题包括：
· 查看数据字典中的约束
· 实施复杂的规则
· PL/SQL程序单元和语言特性
· 数据类型和复合结构
· 错误处理和异常
· 进程间的通信
· 声明性约束，包括主键约束、惟一性约束、外键约束和检查约束等
《Oracle触发器与存储过程高级编程》对于希望构建和维护智能化大型数据库的开发人员、设计人员和项目负责人来说，都是不可多得的宝贵资源。
Database expert Kevin Owens is the U.S. Treasury Department s Oracle database administrator computer center, he will work with you to discuss PL/SQL- Oracle s Structured Query Language (SQL), and teach you how to build robust, large databases to solve your business problems.
Book easy to understand language, and introduces a lot of code examples. The book details the many techniques to take advantage of Oracle features such as triggers and stored procedures. These features combined with business rules to support the database and may change based on the development of business rules to manage and modify. Topics discussed in this book include:
* View the data dictionary bound
• implementation of complex rules
· PL/SQL program units and language features
• Data types and composite structure
* Error handling and exceptions
* Inter-process communication
* Declarative constraints, including the primary key constraint, uniqueness constraint, foreign key constraints and che (2010-10-29, SQL, 29901KB, 下载10次)
[教育系统应用] SQL_Training_Course_Design_Manual
本文较为详细地阐述了开发方法与开发步骤，并对于教学管理系统从需求分析、功能分析、系统数据库设计等方面给出了较为全面、完整的系统设计方法，，按照数据库设计理论一步一步地给出了系统需求说明书、全局ER图、建立了数据库.然后进行了具体的程序设计，设计充分利用SQL数据库技术的强大力量，提高了编程效率和可靠性。四个模块分别为教师基本信息模块、学生基本信息模块、成绩基本信息模块、课程基本信息模块。
This more detailed description of the development method and development process, and for teaching management system from requirements analysis, functional analysis, system design, the database gives a more comprehensive, integrated system design approach, according to database design theory step by step to out the system requirements specification, global ER diagram, build a database. and then a specific program design, design take full advantage of the power of SQL database technology to improve the programming efficiency and reliability. Four modules are basic information modules for teachers, students basic information module, basic performance information module, course basic information module. (2010-06-13, SQL, 184KB, 下载11次)
[其他] 20081224
参考文献
[1]SQL Server 2000数据库及应用徐人凤曾建华高等教育出版社 2004年1月 [2]软件编程规范徐人凤孙宏伟王梅2005年7月高等教育出版社
[3]《SQL Server数据库开发经典案例解析》，清华大学出版社，2006年
[4]《SQL SERVER 2000开发与应用》，机械工业出版社，2003年7月
[5]《数据库系统概论（第三版）萨师煊 王珊
References [1] SQL Server 2000 database and application has Jianhua Feng Xu person Higher Education Press in January 2004 [2] software programming norms Hongwei Wang Feng Xu people in July 2005 Higher Education Press [3] SQL Server database development Case Study Analysis, Tsinghua University Press, 2006 [4] SQL SERVER 2000 Development and Application , Mechanical Industry Press, July 2003 [5] An Introduction to Database Systems (third edition) division Xuan Wang Shan Sa (2008-12-24, SQL, 286KB, 下载4次)
[MySQL数据库] MySQL
MySQL是一个精巧的SQL数据库管理系统，虽然它不是开放源代码的产品，但在某些情况下你可以自由使用。由于它的强大功能、灵活性、丰富的应用编程接口（API）以及精巧的系统结构，受到了广大自由软件爱好者甚至是商业软件用户的青睐，特别是与Apache和PHP/PERL结合，为建立基于数据库的动态网站提供了强大动力。
MySQL is a sophisticated SQL database management system, although it is not open source products, but in some cases, you are free to use. Because of its powerful features, flexibility, rich application programming interface (API), as well as sophisticated system architecture, by the vast number of free software enthusiasts and even commercial software customers, especially with Apache and PHP/PERL combination for database based on dynamic Web site provides a powerful driving force. (2008-11-06, SQL, 437KB, 下载3次)
[其他书籍] csdn_sql
CSDN上的优秀SQL编程代码集
这些SQL语句不是原创，均是本人从CSND上收集来的。由于时间关系，其中少量SQL语句的确性没有验证。
本文档对初学SQL Server的人很有帮助，其内容涵盖了触发器、作业、角色、备份还原、导入导出、游标、安全、索引排序、日期操作、XML、统计、交叉表、文件存储、分页、等等
CSDN excellent SQL programming code set these SQL statements are not original, are I learned from the CSND collected. Because of the time, in which a small amount of SQL statements is true of the absence of a certification. This document for beginner SQL Server people helpful, its content covers the trigger, operations, roles, backup and restore, import, export, cursor, security, index to sort, date operations, XML, statistics, cross-tables, file storage, paging, etc. (2008-10-08, SQL, 555KB, 下载33次)
[WEB开发] MySQLcankaoshoucel
MySQL是一个精巧的SQL数据库管理系统，虽然它不是开放源代码的产品，但在某些情况下你可以自由使用。由于它的强大功能、灵活性、丰富的应用编程接口（API）以及精巧的系统结构，受到了广大自由软件爱好者甚至是商业软件用户的青睐，特别是与Apache和PHP/PERL结合，为建立基于数据库的动态网站提供了强大动力。
MySQL is a sophisticated SQL database management system, although it is not open source products, but in some cases, you are free to use. Because of its powerful features, flexibility, rich application programming interface (API), as well as sophisticated system architecture, by the vast number of free software enthusiasts and even commercial software customers, especially with Apache and PHP/PERL combination for database based on dynamic Web site provides a powerful driving force. (2008-03-11, SQL, 911KB, 下载3次)
[SQL Server] shujuku
根据事务需求（详见所给材料）中的每一项要求，写出相关的存储过程。
说明：
1）“创建”记录就是在存储过程中使用Insert语句实现插入新记录的功能；
2）“维护”记录包括更新和删除数据库中的记录，要求完成更新功能，删除功能可选；
3）查询功能要求较多，灵活运用所学SQL编程知识来完成。
In accordance with Service requirements (see the given material) in each of the requirements, write a stored procedure-related. Description: 1) create records in the stored procedure is used to achieve Insert statement to insert a new record function 2) preserve records including updating and deleting database records, the requirements to complete the update function, delete function optional 3) query the functional requirements of more flexible use of learned knowledge to the completion of SQL programming. (2007-12-09, SQL, 9KB, 下载4次)
[数据库编程] databasedesign
数据库的设计范式是数据库设计所需要满足的规范，满足这些规范的数据库是简洁的、结构明晰的，同时，不会发生插入 （insert）、删除（delete）和更新（update）操作异常。反之则是乱七八糟，不仅给数据库的编程人员制造麻烦，而且面目可憎，可能存储了 大量不需要的冗余信息。 设计范式是不是很难懂呢？非也，大学教材上给我们一堆数学公式我们当然看不懂，也记不住。所以我们很多人就根本不按照范式来设计数据库。 实质上，设计范式用很形象、很简洁的话语就能说清楚，道明白。本文将对范式进行通俗地说明，并以笔者曾经设计的一个简单论坛的数据库为例来讲解怎样将这些范式应用于实际工程。 (2007-10-26, SQL, 3KB, 下载14次)
http://www.pudn.com/Download/item/id/350928.html[界面编程] vcbian20031209
cj60lib界面库 ,ado数据库编程 使用方法： 调试代码必须装有cj60lib界面扩展库 cj60lib的使用方法参看有关文档 不知道是不是我的cj60lib出问题，release版的动态链接会提示出错，静态链接还可以，动态链接时必须复制CJ60Libd.dll到当前目录中 所用数据库为access数据库，格式参看自带的vc.mdb（注：数据库datastab表中第一条记录即id为1的记录是为了防止数据库为空，运行时不会显示，还有另一个原因防止主题中记录为空，在程序中可以看出来）
cj60lib interface library, ado database programming Usage: debug code cj60lib interface must be installed to expand the use of library cj60lib refer to the relevant documents do not know whether my cj60lib problems, release version of the dynamic-link will be prompted to make mistakes, static link also Yes, dynamic-link must be copied into the current directory CJ60Libd.dll used in the database to access database, see the format (2007-08-14, SQL, 428KB, 下载9次)
[SQL Server] SQLServerMobile2005
第一节课：概述
SQL Server Mobile 概述
SQL Server Mobile 的功能
与 SQL Server 2005 集成
与 Visual Studio 2005 集成
第二节课：数据库引擎
数据库引擎的编程
查询分析器的使用
独有的数据访问对象
利用数据源快速创建应用程序
第三节课：结果集
什么是 SqlCeResultSet？
强类型的 SqlCeResultSet
SqlCeResultSet 的数据绑定
第四节课：远程数据访问
配置 Web 同步向导
远程数据访问（RDA）
SqlCeRemoteDataAccess 的属性
SqlCeRemoteDataAccess 的方法
演示用 RDA 方式同步数据
第五节课：合并复制
原理和架构
支持的功能
创建发布
创建订阅
与RDA的比较
first course : SQL Server Mobile outlined SQL Server Mobile outlined the functions and SQ L Integration Server 2005 and Visual Studio 2005 Integration Section II class : database engine database engine analyzers programming inquiries to the exclusive use of the data access object data sources used to be the rapid creation Section III classes of procedures : What is the result set SqlCeResultSet? Strong SqlCeResultSet SqlCeResultSet types of data bundled with section IV Course : Remote Data Access Web Configuration Synchronization Wizard Remote Data Access (RDA) SqlCeRemoteDat aAccess attributes SqlCeRemoteDataAccess the demonstration using RDA V mode synchronous data lesson : copy merger principle and structure of the functional support the creation and publication subscriptions to the cre (2007-05-19, SQL, 5037KB, 下载155次)
[MySQL数据库] MySQL-msz
MySQL中文参考手册.rar
MySQL是一个精巧的SQL数据库管理系统，虽然它不是开放源代码的产品，但在某些情况下你可以自由使用。由于它的强大功能、灵活性、丰富的应用编程接口（API）以及精巧的系统结构，受到了广大自由软件爱好者甚至是商业软件用户的青睐，特别是与Apache和PHP/PERL结合，为建立基于数据库的动态网站提供了强大动力。
MySQL有瑞典的T.c.X公司负责开发和维护，MySQL的用户手册很单纯，只有一个集中的<MySQL Reference Manual>，但其内容覆盖了MySQL的所有信息，因此该手册是了解和掌握MySQL的绝佳文献。
虽然对MySQL的开发不能出一份力，但可为它的推广使用尽一份心，面对500多页的参考手册，知道要精确译出它决非易事，但愿几个月的心血能为大家提供一丝微薄的帮助。
由于本人水平有限，文中肯定有不准确的地方，敬请在阅读过程中不吝指出。文中不明之处，请参阅手册原文。
本文的内容针对MySQL 3.23.7alpla，实际上很多内容是通用的。另外，参考手册的几个附录也是很有价值的，但由于时间有限，未能译出，可参见原文。
MySQL reference manual. Rar MySQL is a sophisticated SQL database management system Although it is not open source products, but in some cases you can freely use. Because of its strong capabilities, flexibility, rich application programming interface (API) and the elegance of the structure, by the vast number of free software enthusiasts even commercial software users favored especially with Apache and PHP/PERL combination for the establishment of the dynamic database-based web site provided a powerful impetus. MySQL Sweden T.c.X the company responsible for the development and maintenance of the MySQL user manual is very simple, Only a concentration of (2007-01-16, SQL, 437KB, 下载13次)
[SQL Server] sql2
SQL学习宝典2.0的使用说明：
1.在win95,win98下要安装PWS(win98安装盘里有）.
2.把sql2目录设为虚拟目录。
2.在浏览器中运行http://localhost/sql2/index.asp.
SQL学习宝典2.0的功能说明：
1.学习和检验SQL语句,输入SQL语句即可执行，及时显示结果。
2.assess数据库显示，显示数据库中的所有表名和所有表的记录，
包括字段类型。可以在conn.inc文件中把xx.mdb换成你自己的数据库名，
其他程序不用修改即可使用。
3.收藏大量经典SQL语句，用户可以添加收藏。
4.所有程序均有详细说明。是ASP+ACCESS的最好实例。是ASP程序员的好帮手。
使用对象：ASP编程人员，学习和使用SQL语句的人
book learning SQL 2.0 for use : 1. In win95. win98 installed under PWS (win98 installation of a tray). 2. put sql2 Set Virtual Directory Contents . 2. The browser running http :// localhost/sql2/index.asp. learning SQL 2.0 treasury functions Note : 1. learning and testing the SQL statements in SQL input can be executed, timely result will be displayed. 2.assess database, the database shows all the tables in the name of the table and all records, including field type. The documents include the conn.inc xx.mdb replaced by your own database name. other procedures need not be amended in order to use. 3. A collection of classic SQL statements, users can add collections. 4. All procedures were detailed description. ACCESS ASP is the best example. ASP programmer is a good helper. Using Object : (2006-07-13, SQL, 19KB, 下载2次)