Course
Skills Expanded
SQL Server: Database Creation, Configuration, and Alteration
Learn how to create and configure databases, files, and filegroups correctly, for developers and DBAs from SQL Server 2005 onward
What you'll learn
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.
Table of contents
Course Introduction
5mins
Creating a Database
33mins
- Module Introduction 1m
- Demo: CREATE DATABASE Simple Version 5m
- Demo: Defining Files with Your Database Creation 3m
- Demo: Creating a Database with Multiple Data Files 2m
- Demo: Creating a Database with a User-Defined Filegroup 2m
- Demo: Defining Collation 2m
- Demo: Recovery Models 2m
- Demo: Database Ownership 2m
- Demo: DB_CHAINING and TRUSTWORTHY 2m
- Demo: Creating a Database by Attaching a File 3m
- Demo: Creating Database Snapshots 3m
- Demo: Accommodating FILESTREAM Data 3m
- Demo: Containment Settings 3m
- Module Summary 0m
Modifying Files and Filegroups
14mins
Changing Database Configurations
35mins
- Module Introduction 1m
- Demo: Changing Compatibility Level 2m
- Demo: Changing AUTO Options 4m
- Demo: Changing Database State 2m
- Demo: Making a Database Read-Only 2m
- Demo: Restricting Database Access 3m
- Demo: Changing Recovery Models 1m
- Demo: Changing Page Verification Options 2m
- Demo: Changing Target Recovery Time Options 1m
- Demo: Changing Collation 1m
- Demo: Enabling Snapshot Isolation Options 1m
- Demo: Modifying ANSI Options 1m
- Demo: Renaming a Database 2m
- Demo: Change Tracking Configuration 3m
- Demo: Enabling Transparent Data Encryption 2m
- Demo: Changing Security Options 2m
- Demo: Enabling and Changing Service Broker Options 2m
- Database Mirroring and Availability Group Settings 1m
- Demo: Changing Containment Settings 1m
- Module Summary 1m
- Course Summary 0m
