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
Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guid
Containing 64 songs designed to promote language, social and musical development, this book accompanies the Tuning In Cards so you can perform the songs and integrate the activities into your own prac
本書全面講述了數據庫的基本概念、安全和SQL Server 2008的技術和應用,全書以理論夠用、實踐第一為原則,使讀者能夠快速、輕鬆地掌握SQL Server數據庫技術與安全相關知識。全書分三部分: 第一部分講述SQL Server 2008的數據庫技術基礎,內容包括SQL Server 2008概述、數據庫和表的基本概念和操作、數據庫查詢、TSQL編程、視圖和索引、存儲過程和觸發器、事務和併
Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for
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
本書主要講述SQL Server 2016的安裝和配置方法、數據庫的操作方法、數據表的操作方法、Transact-SQL語言基礎、Transact-SQL語句的使用方法、認識函數、Transact-SQL查詢、數據的更新、規則、默認和完整性約束、創建和使用索引、事務和鎖、�標、存儲過程和自定義函數、視圖操作、觸發、SQL Server 2016的安全機制、數據庫的備份與恢復, 最後給出一個綜合案例
本書全面、翔實地介紹了應用SQL Server 2012資料庫管理系統進行資料庫管理的各種操作以及資料庫程式開發所需的各種知識和技能,主要內容包括:資料庫技術基礎,資料庫操作,表操作,查詢操作,視圖操作,索引操作,T-SQL程式設計和存儲過程操作,觸發器操作,游標、事務和鎖,資料庫安全操作,資料庫管理操作和SQL Server資料庫程式開發。作者在多年的資料庫教學與資料庫程式應用開發經驗的基礎上,
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The bo
《SQL Server 2005實用教程(第3版)》是根據教育部提出的高等學校計算機基礎教學“技能―能力―思維”三個層次要求組織編寫的。本書主要講述大型數據庫管理系統SQL Server 2005的功能、操作和實用開發技術。 《SQL Server 2005實用教程(第3版)》以SQL Server 2005為平臺,用一個實例貫穿全書來詳細講解SQL Server 2005的安裝和配置、數據庫的創
This book is an exploration on how to program the Microsoft SQL Server 2017. The author begins by guiding you on how to get with SQL Server 2017 by setting up the environment. For users to enjoy the u
Take a deep dive into one of the most significant SQL Server features–support for In-Memory Online Transaction Processing. The latest developments are covered, including support of off-row storage, co
Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-761 Querying Data with Transact-SQL certification exam, the first of two exams required for MCSA: SQL 2016 Dat
Proven database optimization solutions—fully updated for Oracle Database 12c Release 2Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard
Suddenly, program optimization is crucial again. Yesterday’s “automatic” increases in computer performance have effectively stopped. iOS devices such as the iPhone, iPad, iPod touch, and Apple TV have
Optimize reporting and BI with Microsoft SQL Server 2016Professional Microsoft SQL Server 2016 Reporting Services and Mobile Dashboardsprovides a comprehensive lesson in business intelligence (BI), op
With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new proje
Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports
A fully updated, definitive guide to SQL Server 2016 Reporting ServicesCreate, deploy, and manage robust business intelligence reports using the expert tips and best practices contained in this thorou
本書以大型資料庫管理系統SQL Server 2012為平臺,通過一個貫穿全書的實例“天意購物”資料庫,詳細講解了SQL Server 2012的安裝和配置,資料庫的創建與管理,表、視圖、索引、T-SQL語言、存儲過程和觸發器,資料庫的備份恢復與導入導出,SQL Server的安全管理等內容。 本書共分為緒論和6個專案,內容包括資料庫基礎知識、“天意購物”資料庫設計與實現、“天意購物”資料庫中資料
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explai
The fifth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database features. It's a companion to
Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines
全面進擊!職場DB實務技能符合業界所需的資料庫人才技能為導向,搭配最新SQL Server 2014開發環境,由淺入深地介紹資料庫系統相關知識與實務應用。為達到易學、通透之目的,書中運用大量圖解及實務的範例,輔以SQL語意圖解表達法來解說抽象且生硬的資料庫原理。 專業資料庫人才的最佳實務培訓手冊 ★穩紮穩打的專業基礎,建立資料庫設計的正確觀念★獨創的概念式圖解,加強與活化SQL語意教學★增加實用案
Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features
Learn Essential SQL and Database SkillsKnowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programm
Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala—the massively parallel processing SQL query engine for Apache Hadoop. The best practices in
SummaryLearn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performanc
PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good w
Learn the latest SQL Server 2014 database design methods for career advancement; among them in-memory OLTP tables, FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teac