Sams Teach Yourself SQL in 24 Hours, 7/e

Includes Coverage of Oracle and Microsoft SQL Implementations

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

The 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.

在不到24個小時的24課中，《SQL in 24 Hours, Sams Teach Yourself》第七版幫助您使用SQL建立有效的資料庫，高效檢索資料，並從性能到安全性管理一切。

這本書以直觀的、逐步的方式向您展示如何使用資料庫結構、物件、查詢、表格等進行工作。在短短幾個小時內，您將學習到高級技巧，包括視圖、事務、網絡連接以及強大的Oracle和SQL Server擴展功能。每一課都建立在您已經學到的基礎上，為您在實際應用中打下堅實的基礎。

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

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

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

Ryan Stephens is an entrepreneur who has built his career and multiple IT companies around SQL, data, and relational databases. He has shared his knowledge and experience with organizations, students, and IT professionals all over the world. Two of the companies he has co-founded, Perpetual Technologies, Inc. (PTI), and Indy Data Partners, have provided expert database and IT services to large-scale government and commercial clients for more than 25 years. Ryan has authored several books for Pearson, including Sams Teach Yourself SQL in 24 Hours, 6th Edition; some of his books have been translated and published internationally. Additionally, Ryan has worked for large organizations and has consulted within the areas of SQL, database design, database management, and project management. He designed and taught a database management program for Indiana University-Purdue University in Indianapolis and currently teaches online SQL and database classes for Pearson Education.

Ryan Stephens是一位企業家，他的職業生涯和多家IT公司都圍繞著SQL、數據和關聯數據庫展開。他將自己的知識和經驗與世界各地的組織、學生和IT專業人士分享。他共同創辦的兩家公司，Perpetual Technologies, Inc. (PTI)和Indy Data Partners，已經為大型政府和商業客戶提供專業的數據庫和IT服務超過25年。Ryan為Pearson出版了幾本書，包括《Sams Teach Yourself SQL in 24 Hours》第6版；他的一些書籍已經被翻譯並在國際上出版。此外，Ryan曾在大型組織工作，並在SQL、數據庫設計、數據庫管理和項目管理領域提供咨詢服務。他曾為印第安納大學普渡大學印第安納波利斯分校設計並教授數據庫管理課程，目前還在Pearson Education網上教授SQL和數據庫課程。