<STRONG>The Programmer's Guide to SQL</STRONG> provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL), the standard that defines how to create and manipulate databases and the data that they store. Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all the major SQL statements that you're likely to need when programming databases, with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access. In each case, it demonstrates how the SQL standard is implemented, and in some cases extended, by each database system vendor. It discusses:</P>
- Querying, modifying and summarizing data using SQL </P>
- SQL Functions</P>
- Complex nested queries and joins </P>
- Programming database stores procedures, triggers and views </P>
- Creating tables, indexes and other database objects</P>
- How to write transaction-safe SQL </P>
- How to implement basic database security </P>
The book covers the very latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications. As such, it is ideal for any programmer, analyst, or database administrator in search of an SQL reference that also demonstrates how to use SQL to solve real business problems.</P>
具體描述
讀後感
用戶評價
相關圖書
本站所有內容均為互聯網搜索引擎提供的公開搜索信息，本站不存儲任何數據與內容，任何內容與數據均與本站無關，如有需要請聯繫相關搜索引擎包括但不限於百度，google,bing,sogou 等
© 2025 onlinetoolsland.com All Rights Reserved. 本本书屋 版权所有