- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Essential Skills--Made Easy!Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated
Contents
PART I - Relational Databases and SQLChapter 1. Introduction to Relational Databases and SQLChapter 2. Working with the SQL EnvironmentChapter 3. Creating and Altering TablesChapter 4. Enforcing Data IntegrityChapter 5. Creating SQL ViewsChapter 6. Managing Database SecurityPart II - Data Access and ModificationChapter 7. Querying SQL DataChapter 8. Modifying SQL DataChapter 9. Using PredicatesChapter 10. Working with Functions and Value ExpressionsChapter 11. Accessing Multiple TablesChapter 12. Using Subqueries to Access and Modify DataPart III - Advanced Data AccessChapter 13. Creating SQL-Invoked RoutinesChapter 14. Creating SQL TriggersChapter 15. Using SQL CursorsChapter 16. Managing SQL TransactionsChapter 17. Accessing SQL Data from Your Host ProgramChapter 18. Working with XML DataPart IV - AppendicesAppendix A: Answers to SelfTestAppendix B: SQL:2006 KeywordsAppendix C: SQL Code Used in Try This ExercisesIndexNER(01): WOW
