An activity-oriented web application for fresh produce traceability
International Journal of Business Information Systems
| Hi-index | 0.00 |
It's been five years since Microsoft released a new version of SQL Server—which holds 39% of the Windows database market—and the latest edition of this bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench,T-SQL, automated administration tasks, security, and analysis. Table of contentsPart I: SQL Server: Basic ConceptsChapter 1: Database Systems and SQL ServerChapter 2: SQL Server Management StudioPart II: Transact-SQL Language Chapter 3: SQL ComponentsChapter 4: Data Definition LanguageChapter 5: Simple QueriesChapter 6: Complex QueriesChapter 7: Modification of a Table's Contents Chapter 8: Stored Procedures and User-Defined FunctionsChapter 9: Indices and Query OptimizationChapter 10: Views Chapter 11: Systems CatalogChapter 12: SQL Server Security Chapter 13: TriggersChapter 14: Transactions Chapter 15: SQL Server System EnvironmentPart III: SQL Server: System AdministrationChapter 16: Overview of System AdministrationChapter 17: Planning the Installation and Installing SQL ServerChapter 18: Managing Database and Database FilesChapter 19: Managing SecurityChapter 20: Backup and RecoveryChapter 21: Automating Systems Administration TasksChapter 22: Performance and TuningChapter 23: Data PartitioningChapter 24: Data ReplicationPart IV: Microsoft Analysis ServicesChapter 25: Data Warehousing: An IntroductionChapter 26: Microsoft Analysis ServicesChapter 27: Business Intelligence and SQLChapter 28: Microsoft Reporting ServicesPart V: XML SupportChapter 29: Overview of XMLChapter 30: SQL Server 2005 and XMLINDEX