Trending on TikTok

Buldak

Sunscreen

Sanrio

English

{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}

View Cart & Check Out

Nickname

Let us know how to properly address you.

Update Your Name

xxxxxxx@yamibuy.com

Account Orders Favorites

Points 0

Coupons 0

Gift Card Balance $0.00

Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

We will notify you by email when the item back in stock.

Your email: {{remindEmail}}

Cancel

Jingdong book

SQL学习指南（第2版修订版）

View Cart & Check Out

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Books Computers & Internet Database

Jingdong book

SQL学习指南（第2版修订版）

Name: SQL学习指南（第2版 修订版）
Brand: Jingdong book
SKU: 3118021581
Price: 32.35 USD
Availability: OutOfStock

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}

Ends in

{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}

{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}

Sale ends in

Sale will starts after Sale ends in

{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details

Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.

Sold Out

Details

Full product details

Content Description

《SQL学习指南（第2版修订版）》全面系统地介绍了SQL语言各方面的基础知识以及一些高级特性，包括SQL数据语言、SQL方案语言、数据集操作、子查询以及内建函数与条件逻辑等内容。书中每个章节讲述一个相对独立的主题，并提供了相关示例和练习。《SQL学习指南（第2版修订版）》内容以SQL92标准为蓝本，涵盖了市场上常用数据库的最新版本（MySQL 6.0、Oracle 11g及Microsoft SQL Server 2008）。
《SQL学习指南（第2版修订版）》适合数据库应用开发者、数据库管理员和高级用户阅读。针对开发基于数据库的应用程序，以及日常的数据库系统管理，《SQL学习指南（第2版修订版）》都展现了大量经过实践检验的方法和技巧。读者可以通过对《SQL学习指南（第2版修订版）》循序渐进地学习快速掌握SQL语言，也可以在实际工作中遇到问题时直接翻阅《SQL学习指南（第2版修订版）》中的相关章节以获取解决方案。

Author Description

Alan Beaulieu，从事设计、构建和实现应用数据库已有15个年头，他目前经营自己的顾问公司，专门提供金融和电信领域的Oracle数据库设计与支持服务。Alan使用了Oracle的诸多特性，如并行查询、分区和并行服务器等，以构建OLTP和OLAP环境下的大型数据库。Alan获得了康奈尔大学工程学院的运筹学学士学位，现在和妻子以及两个女儿一起住在马萨诸塞州，可以通过电子邮箱albeau_mosql@yahoo.com与他联系。

Comments

★“如果你决定开始学习SQL语言，那么请卷起袖子大干一场吧，不过别忘了让本书成为你的伙伴。阅读本书并完成书中每个实践练习，可以为创建基于数据库的解决方案做好准备。数据库无所不在，本书向你提供作者在工作中经过实践检验的宝贵经验。”
——Roy Owens 来自CBORD Group公司的数据库专家

Catalogue

第1章背景知识
1.1 数据库简介
1.1.1 非关系数据库
1.1.2 关系模型
1.1.3 一些术语
1.2 什么是SQL
1.2.1 SQL语句的分类
1.2.2 SQL：非过程化语句
1.2.3 SQL示例
1.3 什么MySQL
1.4 内容前瞻

第2章创建和使用数据库
2.1 创建MySQL数据库
2.2 使用mysql命令行工具
2.3 MySQL数据类型
2.3.1 字符型数据
2.3.2 数值型数据
2.3.3 时间数据
2.4 表的创建
2.4.1 第1步：设计
2.4.2 第2步：精化
2.4.3 第3步：构建SQL方案语句
2.5 操作与修改表
2.5.1 插入数据
2.5.2 更新数据
2.5.3 删除数据
2.6 导致错误的语句
2.6.1 主键不唯一
2.6.2 不存在的外键
2.6.3 列值不合法
2.6.4 无效的日期转换
2.7 Bank方案

第3章查询入门
3.1 查询机制
3.2 查询语句
3.3 select子句
3.3.1 列的别名
3.3.2 去除重复的行
3.4 from子句
3.4.1 表的概念
3.4.2 表连接
3.4.3 定义表别名
3.5 where子句
3.6 groupby和having子句
3.7 orderby子句
3.7.1 升序或降序排序
3.7.2 根据表达式排序
3.7.3 根据数字占位符排序
3.8 小测验

第4章过滤
4.1 条件评估
4.1.1 使用圆括号
4.1.2 使用not操作符
4.2 构建条件
4.3 条件类型
4.3.1 相等条件
4.3.2 范围条件
……
第5章多表查询
第6章使用集合
第7章数据生成、转换和操作
第8章分组与聚集
第9章子查询
第10章再谈连接
第11章条件逻辑
第12章事务
第13章索引和约束
第14章视图
第15章元数据
附录A 示例数据库的ER图
附录B MySQL对SQL语言的扩展
附录C 练习答案

Specifications

Brand

Jingdong book

Brand Origin

China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use

Scan to Share

Add to favorites

{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}

Clip coupons

Quantity

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Sold by JD@CHINA

Ship to

Free shipping over 69

Genuine guarantee

View details

Region

Added to Cart

Keep Shopping

More to Consider

Coupons

Clip Clipped Over

Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Fulfilled by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Yami-China FC

Service Guarantee

Cross-store Free Shipping over $69

30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69

Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)

Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

Download the Yami App

Feedback

Back Top

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review

{{i}} star

{{i}} stars

{{ parseInt(commentRatingList[i]) }}%

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Load more reviews

Review

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Change Your Zip Code

Location History

SQL学习指南（第2版 修订版）

SQL学习指南（第2版修订版）