- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Publisher's Noteguaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Essential Microsoft SQL Server 2012 Skills Made EasyGet up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.Install, configure, and customize SQL Server 2012Create and modify database objects with Transact SQL statementsWrite stored procedures and user-defined functionsHandle backup and recoveryAutomate administrative tasksTune your database system for optimal performance, availability, and reliabilityImplement security measures using authentication, encryption, and authorizationWork with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence toolsStore, display, and query XML documents Manage spatial dataQuery documents using MS Full-Text Search (FTS)
Contents
Part IChapter 1. Relational Database Systems: An IntroductionChapter 2. Planning the Installation and Installing SQL ServerChapter 3. SQL Server Management StudioPart II: Transact-SQL LanguageChapter 4. SQL ComponentsChapter 5. Data Definition LanguageChapter 6. QueriesChapter 7. Modification of a Table's ContentsChapter 8. Stored Procedures and User-Defined FunctionsChapter 9. System CatalogChapter 10. IndicesChapter 11. ViewsChapter 12. Security System of the Database EngineChapter 13. Concurrency ControlChapter 14. TriggersPart III: SQL Server: System AdministrationChapter 15. System Environment of the Database EngineChapter 16. Backup, Recovery, and System AvailabilityChapter 17. Automating System Administration TasksChapter 18. Data ReplicationChapter 19. Query OptimizerChapter 20. Performance TuningPart IV: SQL Server and Business IntelligenceChapter 21. Business Intelligence: An IntroductionChapter 22. SQL Server Analysis ServicesChapter 23. Business Intelligence and Transact-SQLChapter 24. SQL Server Reporting ServicesChapter 25. Optimizing Techniques for Relational Online Analytical ProcessingPart V: Beyond Relational DataChapter 26. SQL Server and XMLChapter 27. Spatial DataChapter 28. SQL Server Full-Text SearchIndexNER(01): WOW
