MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Database Creation, Configuration, and Alteration

Course Summary

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 fil

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ A Myriad of Arguments
        ◦ Why Not Use the GUI?
        ◦ Course Structure
    ● Creating a Database
        ◦ Module Introduction
        ◦ Demo: CREATE DATABASE Simple Version
        ◦ Demo: Defining Files with Your Database Creation
        ◦ Demo: Creating a Database with Multiple Data Files
        ◦ Demo: Creating a Database with a User-Defined Filegroup
        ◦ Demo: Defining Collation
        ◦ Demo: Recovery Models
        ◦ Demo: Database Ownership
        ◦ Demo: Creating a Database by Attaching a File
        ◦ Demo: Creating Database Snapshots
        ◦ Demo: Accommodating FILESTREAM Data
        ◦ Demo: Containment Settings
        ◦ Module Summary
    ● Modifying Files and Filegroups
        ◦ Module Introduction
        ◦ Demo: Adding and Removing Files
        ◦ Demo: Adding and Removing Filegroups
        ◦ Demo: Changing Growth Options
        ◦ Demo: Relocating User Database Files
        ◦ Demo: Changing a Logical File Name
        ◦ Demo: Making a Filegroup Read-Only
        ◦ Module Summary
    ● Changing Database Configurations
        ◦ Module Introduction
        ◦ Demo: Changing Compatibility Level
        ◦ Demo: Changing AUTO Options
        ◦ Demo: Changing Database State
        ◦ Demo: Making a Database Read-Only
        ◦ Demo: Restricting Database Access
        ◦ Demo: Changing Recovery Models
        ◦ Demo: Changing Page Verification Options
        ◦ Demo: Changing Target Recovery Time Options
        ◦ Demo: Changing Collation
        ◦ Demo: Enabling Snapshot Isolation Options
        ◦ Demo: Modifying ANSI Options
        ◦ Demo: Renaming a Database
        ◦ Demo: Change Tracking Configuration
        ◦ Demo: Enabling Transparent Data Encryption
        ◦ Demo: Changing Security Options
        ◦ Demo: Enabling and Changing Service Broker Options
        ◦ Database Mirroring and Availability Group Settings
        ◦ Demo: Changing Containment Settings
        ◦ Module Summary
        ◦ Course Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top