SQL Server 2008 Administration (70-432): Part 1
Part 1 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system.
What you'll learn
Part 1 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimized use of SQL server FileGroups. Whether you're a beginner or experienced in SQL Server administration, you will benefit from this in-depth course.
Table of contents
- Introduction 2m
- Database Planning 2m
- Creating Databases - Overview 10m
- Creating Veronica's Veronicas Database - General Page 8m
- Creating Veronica's Veronicas Database - Options Page 7m
- Creating a New Table 4m
- Database Diagrams 2m
- Creating Database Diagrams 6m
- Database Views 4m
- Creating a New View 7m
- Creating a Synonym 1m
- Recommendations 1m
- What We Covered & Terminology 4m
- Introduction 2m
- SQL Server Security Landscape 3m
- Physical Security 1m
- Managing User Access 7m
- Creating SQL Login and SQL User Account 8m
- Testing SQL User Account 3m
- Setting SQL User Permissions 9m
- Server-Level Role vs. Database-Level Role 6m
- Schemas Overview 18m
- Protecting Your Data - Auditing SQL Server 4m
- Configuring 'Surface Area' 5m
- File Security and SQL Server Data Encryption 2m
- SQL Server SA Login and Certificate-Based SQL Server Login 3m
- Information_Schema and Sys 2m
- Best Practices 4m
- What We Covered and Terminology 5m
- Introduction 1m
- SQL Server Recovery Models 4m
- Full Recovery Model 3m
- Bulk Logged Recovery Model 4m
- Simple Recovery Model 1m
- Backup Types 6m
- Full Database Backups 6m
- Restoring a Database 7m
- Full File Backups 11m
- Recovery Requirements 3m
- Maintenance Plan Wizard 8m
- Best Practices 3m
- What We Covered and Terminology 4m
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