SQL(Structured Query Language)是關系數據庫的基本操作語言,它主要包括數據查詢(Query statements)、數據操縱(Data Manipulation Language statements)、數據定義(Data Definition Language statements)等功能,是應用程序與數據庫進行交互操作的接口。PL/SQL(Procedural La
Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the
Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and addr
SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users
Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business applicati
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maxim
本書通過對Oracle 12c和SQL Server 2016對應內容的對比講解,使相關技術人員能夠快速適應從Oracle到SQL Server或從SQL Server到Oracle的轉變,並對兩者的運作方式及體系結構有較深的理解。主要內容包括用戶端工具、SQL 語言、體系結構、事務及鎖、備份恢復等資料庫技術人員所需的各種必備知識。本書適合Oracle技術人員學習SQL Server或SQL Se
This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12cThis comprehensive study guide from Oracle Press e