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
SQL是使用最廣泛的數據庫語言，幾乎所有重要的DBMS都支持SQL。《SQL必知必會(第4版)》由淺入深地講解了SQL的基本概念和語法，涉及數據的排序、過濾和分組，以及表、視圖、聯結、子查詢、�標、存儲過程和觸發器等內容，實例豐富，便於查閱。新版增加了針對Apache Open Office Base、MariaDB、SQlite等DBMS的描述，並根據最新版本的Oracle、SQL Server
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
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
Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data
Get ready to make SQL easy!Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get
The #1 Easy, Common-Sense Guide to SQL Queries–All Chapters Updated for the Latest SQL Standard SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and will prove an essential reference guide for intermediate and advanced users. Step by step, John L. Viescas guides you through creating reliable queries for virtually any modern SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.
The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administra
Essential SQL Server 2017 setup, configuration, and management techniques for LinuxThis comprehensive guide covers the latest, paradigm-shifting release of SQL Server—available for the first time ever
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
本書以Microsoft SQL Server 2008中文版為平臺，系統地介紹SQL Server 2008基礎、實驗和SQL Server 2008綜合應用等內容。SQL Server 2008基礎部分在介紹數據庫的基礎知識后，系統介紹數據庫創建、表的創建和操作、數據庫的查詢和視圖、T-SQL語言、索引與數據完整性、存儲過程和觸發器、備份與恢復、系統安全管理，以及事務、鎖定、自動化和服務等。實
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
“永遠在線，永遠可用”對於任何一個現代化公司來說，不僅是一個業務目標，更是競爭需求。本書重點講述了SQL Server 2016的高可用性特性及企業實戰技術。通過學習並掌握這些技術，使讀者能夠親自打造出一個高可用性系統。主要內容包括微軟集群服務、SQL Server 2016 SQL集群、SQL數據複製、日誌傳輸、數據庫鏡像/快照、保持可用性組以及基於Azure的大數據和Azure SQL內置架構
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
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 2016數據庫應用實戰》主要包括數據庫快速入門，初識SQL Server 2016，SQL Server服務的啟動與註冊，SQL Server數據庫的創建與管理，數據表的創建與管理，約束表中的數據，插入、更新與刪除數據，T-SQL基礎，T-SQL語句的應用，數據查詢，SQL數據的高級查詢，系統函數與自定義函數，視圖的創建與應用，索引的創建與應用，存儲過程的創建與應用，觸發器
本書是為學習和掌握數據庫知識的讀者而編寫的，是基於SQL Server 2008的實驗指導書，是編者多年從事數據庫應用軟件開發和教學工作所積累的經驗的體現。 本書圍繞數據庫理論知識，圍繞SQL Server 2008的功能給出了大量實驗，詳細介紹了在SQL Server 2008系統中數據庫，數據庫表，數據操作，完整性約束，索引，視圖，數據查詢，存儲過程，觸發器，TSQL程序設計與標設計，用
本書以Microsoft SQL Server 2016中文版為平臺，系統介紹SQL Server 2016基礎、實驗和綜合應用等內容。 本書在介紹數據庫的基礎知識後，系統介紹數據庫創建、表的創建和操作、數據庫的查詢和視圖、T-SQL語言、索引和數據完整性、存儲過程和觸發器、備份與恢復、系統安全管理、事務鎖定和自動化管理等。實驗通過教程實例訓練SQL Server基本操作和基本命令。綜合應用以PH
