SQL Server: Database Creation, Configuration, and Alteration
WMV | VC-1 384kbps | English | 1024x768 | 15fps | 1h 27mins | WMA2 stereo 192kbps | 355 MB
Genre: Video Training
SQL Server databases have a wide variety of configuration options and this demo-centric course shows the options available when creating a database, and how to modify a databases's configuration after it has been created, including adding and removing files and filegroups. This course is perfect for developers, DBAs, and anyone responsible for creating and configuring SQL Server databases, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.
│ sql-server-creation-config-alteration.zip
│
├───01. Course Introduction
│ 01. Course Introduction.wmv
│ 02. A Myriad of Arguments.wmv
│ 03. Why Not Use the GUI .wmv
│ 04. Course Structure.wmv
│
├───02. Creating a Database
│ 01. Module Introduction.wmv
│ 02. Demo CREATE DATABASE Simple Version.wmv
│ 03. Demo Defining Files with Your Database Creation.wmv
│ 04. Demo Creating a Database with Multiple Data Files.wmv
│ 05. Demo Creating a Database with a User-Defined Filegroup.wmv
│ 06. Demo Defining Collation.wmv
│ 07. Demo Recovery Models.wmv
│ 08. Demo Database Ownership.wmv
│ 09. Demo DB_CHAINING and TRUSTWORTHY.wmv
│ 10. Demo Creating a Database by Attaching a File.wmv
│ 11. Demo Creating Database Snapshots.wmv
│ 12. Demo Accommodating FILESTREAM Data.wmv
│ 13. Demo Containment Settings.wmv
│ 14. Module Summary.wmv
│
├───03. Modifying Files and Filegroups
│ 01. Module Introduction.wmv
│ 02. Demo Adding and Removing Files.wmv
│ 03. Demo Adding and Removing Filegroups.wmv
│ 04. Demo Changing Growth Options.wmv
│ 05. Demo Relocating User Database Files.wmv
│ 06. Demo Changing a Logical File Name.wmv
│ 07. Demo Making a Filegroup Read-Only.wmv
│ 08. Module Summary.wmv
│
└───04. Changing Database Configurations
01. Module Introduction.wmv
02. Demo Changing Compatibility Level.wmv
03. Demo Changing AUTO Options.wmv
04. Demo Changing Database State.wmv
05. Demo Making a Database Read-Only.wmv
06. Demo Restricting Database Access.wmv
07. Demo Changing Recovery Models.wmv
08. Demo Changing Page Verification Options.wmv
09. Demo Changing Target Recovery Time Options.wmv
10. Demo Changing Collation.wmv
11. Demo Enabling Snapshot Isolation Options.wmv
12. Demo Modifying ANSI Options.wmv
13. Demo Renaming a Database.wmv
14. Demo Change Tracking Configuration.wmv
15. Demo Enabling Transparent Data Encryption.wmv
16. Demo Changing Security Options.wmv
17. Demo Enabling and Changing Service Broker Options.wmv
18. Database Mirroring and Availability Group Settings.wmv
19. Demo Changing Containment Settings.wmv
20. Module Summary.wmv
21. Course Summary.wmv
