SQL Server 2008 Advanced Database Administration: Part 1
Part 1 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security.
What you'll learn
Part 1 of 3 in the SQL Server 2008 Advanced Database Administration series. This course will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
Table of contents
- Introduction 2m
- Indexes in SQL Server 2008 2m
- Clustered and Non Clustered Indexes 6m
- XML Indexes 2m
- Spatial Indexes 2m
- User Account Setup 10m
- Creating a Clustered or Non Clustered Index 2m
- Creating a Spatial Index 1m
- Creating an XML Index 2m
- Using T-SQL for Indexes 4m
- Rebuilding and Dropping an Index 2m
- Filtered Indexes 5m
- Indexed Views 5m
- Index Performance: Disabling Query Statistic Collection 4m
- Index Performance: Fragmentation and Fill Factor 4m
- Reorganizing vs. Rebuilding an Index 1m
- The Database Engine Tuning Advisor 11m
- What We Covered 1m
- Introduction 2m
- Overview of Topics 4m
- Pros and Cons 3m
- Full-Text Search Terminology 4m
- Installing Full-Text Search 3m
- Introduction to Full-Text Catalogs and Full-Text Indexes 1m
- Using the Full-Text Indexing Wizard 3m
- The Like Expression vs. the Contains Statement 4m
- Configuring Full-Text Searches 4m
- Using the Inflectional Statement 7m
- Troubleshooting Full-Text Search 1m
- Using Dynamic Management Views 6m
- Full-Text Search Error Logs 1m
- What We Covered 1m
About the author
Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK. As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching. Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in... more