Introduction
- Introduction
Database Administrator (DBA) Common Characteristics, Tasks
- Common characteristics of a database administrator
- SQL Server Components Part 1
- SQL Server Components Part 2
- SQL Server Components Part 3
- SQL Server Components Part 4
- SQL Server Components Part 5
- SQL Server Instances
- SQL Server Editions, SQL Server Versions
Database Management Tools and Techniques
- SQL Server Tools
- SQLcmd Utitlity, and BCB Utility
- SQL Server Management Studio, DBCC CHECKDB
Planning SQL Server Installation
- Considerations, Hardware, Software, Storage, Service Accounts Part 1
- Considerations, Hardware, Software, Storage, Service Accounts Part 2
- Considerations, Hardware, Software, Storage, Service Accounts Part 3
- Installing SQL Server 2014
- Post Installation Configuration
Introduction to Data Storage with SQL Server
- How Data is Stored in SQL Server
- Determining File Placement & Number of Files, Ensuring Sufficient File Capacity
Managing Storage for System Databases
- SQL Server System Databases
- Moving System Databases, Considerations for Tempdb
- Demonstration: Moving Tempdb Files
Managing Storage for User Databases
- Creating User Db, Configuring Db Options, Altering User Db
- Managing Database Files
- Introduction to Filegroups, Creating & Managing Filegroups
Moving Database Files, and Lab Scenario
- Moving User Database Files, Detaching & Attaching Databases
- Lab Scenario
