Microsoft SQL Server 2014 Administration
Details
Emphasis is placed on how SQL Server 2014 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at the SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.
Outline
- SQL Server 2014 Architecture
- Available Features and Tools
- New Capabilities
- SQL Services
- Product Licensing
- Product Editions
- Preparing for Installation
- Creating Users for Service Accounts
- Choosing Appropriate File Locations
- Choosing Instance Names
- Installing SQL Server 2014
- Choosing Appropriate Features
- Specifying Service User Accounts
- Choosing Licensing Mode
- Choosing Appropriate Collation
- Installing Multiple Instances
- Upgrading to SQL Server 2014
- Applying a Service Pack
- Registering Servers
- Setting up a Central Management Server
- Using Metadata Views to Obtain Object Properties
- Using Object Explorer
- Configuring a SQL Server Instance
- Configuring Object Properties
- Using the Query Window
- Creating Transact SQL Projects
- Managing Services
- Configuring Server Network Connections
- Configuring Client Connections and Aliases
- Configuring the Surface Area of SQL Server
- Configuring Policy-Based Management
- Creating a Central Management Server
- Using the Dedicated Administrator Connection
- Configuring Data Replication
- Creation and Maintenance of Full-Text Catalogs
- Describing Full-Text Search
- SQL Server Management Studio
- SQL Server Configuration Manager
- SQL Server Books Online
- SQLCMD
- Creating DDL Triggers
- Creating Event Notifications
- Configuring SQL Server Audit
- Creating Databases
- Creating a Contained Database
- Creating Tables
- Memory Optimized Tables
- Specifying Data Types
- Creating Indexes
- Describing Data File Structure
- Describing Log File Structure and Function
- Creating Filegroups
- Configuring Filestream Storage
- Configuring FileTables
- Creating and Using Database Snapshots
- Moving a Database to Another SQL Server
- Using the Windows Performance Tool to Detect the Cause of a Bottleneck
- Using SQL Server Profiler
- Configuring Extended Events
- Using Dynamic Management Functions
- Interpreting Management Studio Reports
- Using Activity Monitor
- Describing Index Structures
- Clustered Indexes
- Nonclustered (NC) Indexes
- Columnstore Indexes
- Clustered Columnstore Indexes
- Choosing Appropriate Clustered Index
- Choosing Appropriate NC Indexes
- Detecting Index Fragmentation
- Rebuilding and Reorganizing Indexes
- Using the Database Engine Tuning Advisor
- Generating and Interpreting Query Plans
- Configuring the Resource Governor
- SQL Server Security Architecture
- Defining Principals and Securables
- Using the Security Hierarchy
- Creating Logins and Users
- Applying Password Policies to SQL Logins
- Creating Server and Database Roles
- Granting Permissions
- Using SQLCMD to Test Permissions
- Creating and Using Certificates
- Setting Execution Context
- Encrypting Data
- Encrypting Databases
- Creating Maintenance Plans
- Job Creation and Execution
- Creating Schedules for Jobs
- Creating and Using Proxies
- Configuring Alerts
- Creating and Using Operators
- Configuring and Using Database Mail
- Using bcp and BULK INSERT
- Using the Import/Export Wizard
- Using Integration Services to Import Data
- Windows Clustering
- AlwaysOn Availability Groups
- Database Mirroring
- Implementing Log Shipping
- Maintaining Data Integrity
- Creating Constraints
- Describing and Using DML Triggers
- Using Data Quality Services
- Configure Data Compression
- Setting Transaction Isolation Levels
- Capturing Changed Data
- Choosing Appropriate Database Recovery Model Option
- Describing Automatic Recovery
- Choosing an Appropriate Backup Strategy
- Determining Backup File Contents
- Designing a Database Recovery Plan
- Using Backup Compression
- Use of Filegroups in a Backup Strategy
- Restoring the Master Database
- Rebuilding System Databases
- Encrypting Backup Files
- Using Backup to URL to Backup or Restore from Windows Azure BLOB
- Windows Clustering
- AlwaysOn Availability Groups
- Implementing AlwaysOn
- Implementing Log Shipping
Software Skills Training, Inc. (SST) is a leading provider of task-oriented training courses for IT professionals. Our task-based training philosophy is focused on saving you time and assuring that you are able to work more productively and with higher quality results after training. Founded in 2000, SST has delivered high-powered training to tens of thousands of IT professionals.
Choose from a variety of delivery options:
- Face-to-face in the classroom in over 100 cities
- Live remote attendance
- On-demand streaming
- Group training at your facility
We guarantee the overall quality of our courses with a 100% money-back guarantee. If any student is not totally satisfied for any reason, they can withdraw before the second day of class. Notify the instructor and return all course materials and receive a 100% refund.
Why Choose SST?- 50% hands on labs
- Small class sizes typically under 14 students
- Expert instructors that average over 10 years of teaching experience
- Students can retake any portion of a class that has been completed, within 12 months at no extra cost
- No registration fees or cancellation fees