当前位置: 首页 > 资源下载 > 数据库 > 查看资源

资源分类
Web开发
Java
.NET
编程语言
数据库
软件工程
图形动画
系统管理
网络通信安全
计算机理论
考试认证
人文百科
文档手册
硬件技术
办公软件

Learning SQL

Learning SQL

书名:Learning SQL

上传:石头

时间:2009-09-10

文件大小:587.52 KB

资源出处:查看资源出处 >>

收藏到网摘: n/a



作者:Alan Beaulieu
出版日期:August 2005
出版社:O'Reilly
页数:306
ISBN:0596007272
文件格式:CHM


SQL(Structured Query Language) is a standard programming language forgenerating, manipulating, and retrieving information from a relationaldatabase. If you’re working with a relational database–whether you’rewriting applications, performing administrative tasks, or generatingreports–you need to know how to interact with your data. Even if youare using a tool that generates SQL for you, such as a reporting tool,there may still be cases where you need to bypass the automaticgeneration feature and write your own SQL statements.
To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.
Learning SQLmoves you quickly through the basics and then on to some of the morecommonly used advanced features. Among the topics discussed:

The history of the computerized databaseSQL Data Statements–those used to create, manipulate, and retrievedata stored in your database; example statements include select,update, insert, and deleteSQL Schema Statements–those used to create database objects, such as tables, indexes, and constraintsHow data sets can interact with queriesThe importance of subqueriesData conversion and manipulation via SQL’s built-in functionsHow conditional logic can be used in Data StatementsBest of all, Learning SQLtalks to you in a real-world manner, discussing various platformdifferences that you’re likely to encounter and offering a series ofchapter exercises that walk you through the learning process. Wheneverpossible, the book sticks to the features included in the ANSI SQLstandards. This means you’ll be able to apply what you learn to any ofseveral different databases; the book covers MySQL, Microsoft SQLServer, and Oracle Database, but the features and syntax should applyjust as well (perhaps with some tweaking) to IBM DB2, Sybase AdaptiveServer, and PostgreSQL.
Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.
Tags:learningSQL


相关书籍

  • 《SQL 参考手册》中文版.chm
  • Oracle PL/SQL Language Pocket Reference, 4th Fourth Edition (PDF英文版)
  • Oracle8i PL/SQL 高级程序设计
  • Programming Microsoft SQL Server 2008
  • PHP and MySQL Web Development, 4/e

评论 (0) All

登陆 | 还没注册?