The Practical SQL Handbook: Using SQL Variants

最新推荐文章于 2024-08-17 02:00:18 发布

原创最新推荐文章于 2024-08-17 02:00:18 发布 · 465 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #microsoft #database #sybase #nested #include

Sql Language 专栏收录该内容

46 篇文章

订阅专栏

本书从SQL基础知识入手，逐步介绍如何使用SQL命令创建数据库、表格及索引，并进行数据增删改查等操作。此外还详细讲解了如何利用SELECT命令检索特定数据、处理关系型数据库中的NULL值、实现表格联接（包括自联接和外联接）、运用子查询获取多表数据、创建视图以提供定制化的数据访问方式等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL's most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.

Highlights include:
*Detailed coverage of SQL commands for creating databases, tables, and indexes, and for adding, changing, and deleting data
*Using the SELECT command to retrieve specific data
*Handling NULL values (missing information) in a relational database
*Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)
*Working with nested queries (subqueries) to get data from multiple tables
*Creating views (virtual tables) to provide customized access to data
*Using SQL functions

http://rapidshare.com/files/51753609/0201703092.zip