The Language of SQL: How to Access Data in Relational Databases (Paperback)

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

大多數SQL教材試圖成為SQL語法的百科全書參考資料，但這種方法是不產生效果的，因為這些資訊在主要數據庫供應商發布的線上參考資料中已經很容易獲得。對於SQL初學者來說，一本書更重要的是專注於一般概念，並提供清晰的解釋和示例，以說明各種語句的功能。這本書就是為初學者而設計的。《SQL語言》在入門SQL書籍中具有一些獨特的特點。首先，您不需要下載軟件或在閱讀文本時坐在電腦前。這本書的目的是提供SQL使用的示例，通過閱讀就能理解。其次，主題按照直觀和邏輯的順序組織。SQL關鍵字逐一介紹，讓您在遇到新詞和概念時能夠建立在先前的理解基礎上進一步學習。最後，本書涵蓋了三個廣泛使用的數據庫的語法：Microsoft SQL Server、MySQL和Oracle，並提供了特殊的“數據庫差異”框，顯示這三個數據庫之間的語法差異，以及獲取和安裝免費版本數據庫的說明。這是您獲得SQL和關聯數據庫工作知識所需的唯一一本書。