2013
Pluralsight
Mel Haynes
5h 1m
English

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.

-01. Introduction to SQL Server 2008 Administration
01. Introduction.wmv
02. What's Covered in This Course.wmv
03. The Environment.wmv

-02. Welcome to SQL Server 2008
01. Introduction.wmv
02. Solutions.wmv
03. Data Engine.wmv
04. Analysis and Integration Services.wmv

-03. Installing SQL Server 2008
01. Introduction.wmv
02. SQL Server 2008 Editions.wmv
03. SQL Server 2008 Requirements.wmv
04. Downloading SQL Software.wmv
05. SQL Server Security 101.wmv
06. SQL Server Installation Center Overview.wmv
07. Launching SQL Server 2008 Management Studio.wmv
08. What We Covered & Terminology.wmv

-04. Introduction to SQL Server 2008 Tools
01. Introduction.wmv
02. SQL Server Business Intelligence Development Studio Overview.wmv
03. Analysis Services and Configuration Tools Overview.wmv
04. Windows PowerShell 1.0 Overview.wmv
05. SQL Server Management Studio Overview.wmv
06. Query Interface Overview.wmv
07. What We Covered & Terminology.wmv

-05. Creating SQL Server 2008 Databases
01. Introduction.wmv
02. Database Planning.wmv
03. Creating Databases - Overview.wmv
04. Creating Veronica's Veronicas Database - General Page.wmv
05. Creating Veronica's Veronicas Database - Options Page.wmv
06. Creating a New Table.wmv
07. Database Diagrams.wmv
08. Creating Database Diagrams.wmv
09. Database Views.wmv
10. Creating a New View.wmv
11. Creating a Synonym.wmv
12. Recommendations.wmv
13. What We Covered & Terminology.wmv

-06. Configuring SQL Server 2008 Security
01. Introduction.wmv
02. SQL Server Security Landscape.wmv
03. Physical Security.wmv
04. Managing User Access.wmv
05. Creating SQL Login and SQL User Account.wmv
06. Testing SQL User Account.wmv
07. Setting SQL User Permissions.wmv
08. Server-Level Role vs. Database-Level Role.wmv
09. Schemas Overview.wmv
10. Protecting Your Data - Auditing SQL Server.wmv
11. Configuring 'Surface Area'.wmv
12. File Security and SQL Server Data Encryption.wmv
13. SQL Server SA Login and Certificate-Based SQL Server Login.wmv
14. Information_Schema and Sys.wmv
15. Best Practices.wmv
16. What We Covered and Terminology.wmv

-07. Implementing Disaster Recovery
01. Introduction.wmv
02. SQL Server Recovery Models.wmv
03. Full Recovery Model.wmv
04. Bulk Logged Recovery Model.wmv
05. Simple Recovery Model.wmv
06. Backup Types.wmv
07. Full Database Backups.wmv
08. Restoring a Database.wmv
09. Full File Backups.wmv
10. Recovery Requirements.wmv
11. Maintenance Plan Wizard.wmv
12. Best Practices.wmv
13. What We Covered and Terminology.wmv

http://pluralsight.com/

Download File Size:410.66 MB

---