Sams Teach Yourself SQL in 24 Hours, 6/e (Paperback)

In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.

This book’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success.

Step-by-step instructions carefully walk you through the most common SQL tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge and stretch your skills.
Notes and tips point out shortcuts and solutions.

Learn how to…
• Define efficient database structures and objects
• “Normalize” raw databases into logically organized tables
• Edit relational data and tables with DML
• Manage transactions
• Write effective, well-performing queries
• Categorize, summarize, sort, group, and restructure data
• Work with dates and times
• Join tables in queries, use subqueries, and combine multiple queries
• Master powerful query optimization techniques
• Administer databases and manage users
• Secure databases and protect data
• Use views, synonyms, and the system catalog
• Extend SQL to the enterprise and Internet
• Master important Oracle and Microsoft extensions to ANSI SQL

Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.

包含 Oracle 和 Microsoft SQL 實作的內容

在短短 24 個小時或更少的時間內，《Sams Teach Yourself SQL in 24 Hours, Sixth Edition》幫助您使用 SQL 建立有效的資料庫，高效擷取資料，並從性能到安全性進行管理。

本書採用直觀的逐步方法，向您展示如何使用資料庫結構、物件、查詢、表格等進行工作。僅需數小時，您就能應用高級技巧，包括視圖、交易、網路連接以及強大的 Oracle 和 SQL Server 擴展功能。每個課程都建立在您已經學到的基礎上，為您在實際應用中打下堅實的基礎。

逐步指導仔細引導您完成最常見的 SQL 任務。實用的實例示範如何應用所學知識。測驗和練習幫助您測試知識並提升技能。註解和提示指出快捷方式和解決方案。

學習如何...
• 定義高效的資料庫結構和物件
• 將原始資料庫「規範化」為邏輯有序的表格
• 使用 DML 編輯關聯資料和表格
• 管理交易
• 撰寫有效且高效的查詢
• 分類、總結、排序、分組和重組資料
• 處理日期和時間
• 在查詢中連接表格，使用子查詢並結合多個查詢
• 掌握強大的查詢優化技巧
• 管理資料庫和使用者
• 保護資料庫和數據安全
• 使用視圖、同義詞和系統目錄
• 將 SQL 擴展到企業和互聯網
• 掌握重要的 Oracle 和 Microsoft 擴展功能以符合 ANSI SQL

請在 informit.com/register 註冊您的產品，以便方便地獲取下載、更新和修正資訊。