Administering MS SQL server 2012 Databases

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More

Important information

Typology Course
Methodology Online
  • Course
  • Online
Description

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Opinions

There are no opinions on this course yet

What you'll learn on the course

SQL
Server

Course programme

Course Preview
  • Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
    • Lesson 00 - Course Overview
      • 0.1 Course Overview
      • 0.2 Table of Contents
      • 0.3 Objectives
      • 0.4 Course Overview
      • 0.5 Course Overview (contd.)
      • 0.6 Value of Administering SQL Server 2012 for Professionals
      • 0.7 Value of Administering SQL Server 2012 for Organizations
      • 0.8 Lessons Covered
      • 0.9 Exam Pattern
      • 0.10 Administering SQL Server 2012 Certification
      • 0.11 Sources of Information
      • 0.12 Conclusion
    • Lesson 01 - SQL Server Tools and Installation
      • 1.1 SQL Server Tools and Installation
      • 1.2 Objectives
      • 1.3 SQL Server 2012 Components and Their Uses
      • 1.4 SQL Server 2012 Components
      • 1.5 Database Engine
      • 1.6 Integration Services
      • 1.7 Reporting Services
      • 1.8 Analysis Services
      • 1.9 Planning SQL Server Installation
      • 1.10 Installation Requirements
      • 1.11 32-Bit vs. 64-Bit Architecture
      • 1.12 Scaling
      • 1.13 Planning Storage
      • 1.14 SQL Server Instances
      • 1.15 Installing SQL Server 2012
      • 1.16 Steps to Install SQL Server 2012
      • 1.17 Steps to Install SQL Server 2012 (contd.)
      • 1.18 Security Considerations
      • 1.19 Installing SQL Server 2012
      • 1.20 Installing SQL Server 2012 Demo 01
      • 1.21 Exploring the Installed Components
      • 1.22 Exploring the Installed Components Demo2
      • 1.23 Quiz
      • 1.24 Summary
      • 1.25 Summary (contd.)
      • 1.26 Conclusion
    • Lesson 02 - Managing the Database Server
      • 2.1 Managing the Database Server
      • 2.2 Objectives
      • 2.3 Server Properties and sp configure
      • 2.4 Server Properties
      • 2.5 Using sp configure
      • 2.6 RECONFIGURE Command
      • 2.7 Viewing Server Properties and Using sp configure
      • 2.8 Viewing Server Properties and Using sp configure Demo 01
      • 2.9 Advanced Options
      • 2.10 Default Values of sp configure
      • 2.11 Enabling Advanced Options, and Viewing and Modifying Them
      • 2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 02
      • 2.13 CPU and Memory Architectures
      • 2.14 Constraints in Processor Switching
      • 2.15 Affinity Masks in SQL Server
      • 2.16 Calculating CPU Affinity
      • 2.17 SQL Server 2012 Enhancements
      • 2.18 Memory Properties
      • 2.19 Working with CPU Affinity and Memory Configurations
      • 2.20 Working with CPU Affinity and Memory Configurations Demo 03
      • 2.21 Configuring Database Mail
      • 2.22 Database Mail
      • 2.23 Setting up Database Mail
      • 2.24 Sending a Mail
      • 2.25 Set up Database Mail
      • 2.26 Set up Database Mail Demo 04
      • 2.27 Quiz
      • 2.28 Summary
      • 2.29 Conclusion
    • Lesson 03 - Managing Databases
      • 3.1 Managing Databases
      • 3.2 Objectives
      • 3.3 Understanding Databases
      • 3.4 Database Structure
      • 3.5 Types of Databases
      • 3.6 Contained Databases
      • 3.7 Creating User and Contained Databases
      • 3.8 Creating User and Contained Databases Demo 01
      • 3.9 System Databases
      • 3.10 System Database
      • 3.11 Master Database
      • 3.12 Model Database
      • 3.13 TempDB Database
      • 3.14 MSDB Database
      • 3.15 Database Options
      • 3.16 Auto Close
      • 3.17 Auto Shrink
      • 3.18 File Space
      • 3.19 Moving between Filegroups
      • 3.20 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database
      • 3.21 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database Demo 02
      • 3.22 Moving between File Groups
      • 3.23 Moving between File Groups Demo 03
      • 3.24 Recovery Models
      • 3.25 Recovery Models
      • 3.26 Simple
      • 3.27 Full
      • 3.28 Bulk Logged
      • 3.29 Changing Recovery Model
      • 3.30 Changing Recovery Model Demo 04
      • 3.31 Quiz
      • 3.32 Summary
      • 3.33 Conclusion
    • Lesson 04 - SQL Server Security
      • 4.1 SQL Server Security
      • 4.2 Objectives
      • 4.3 Security Model and Types of Accounts in SQL Server
      • 4.4 Security Layers
      • 4.5 Windows Accounts
      • 4.6 SQL Server Accounts
      • 4.7 Login Accounts
      • 4.8 Using Accounts in SQL Server
      • 4.9 Using Accounts in SQL Server Demo 01
      • 4.10 Server Roles
      • 4.11 Rights
      • 4.12 Server Roles
      • 4.13 Fixed Server Roles
      • 4.14 Custom Server Roles
      • 4.15 Managing Server Roles
      • 4.16 Managing Server Roles Demo 02
      • 4.17 Managing Permissions
      • 4.18 GRANT
      • 4.19 WITH GRANT
      • 4.20 DENY
      • 4.21 Using GRANT and DENY
      • 4.22 Using GRANT and DENY Demo 03
      • 4.23 Database Roles and Permissions
      • 4.24 Database Roles
      • 4.25 Fixed Database Roles
      • 4.26 Custom Database Roles
      • 4.27 Using Database Roles
      • 4.28 Using Database Roles Demo 04
      • 4.29 Quiz
      • 4.30 Summary
      • 4.31 Conclusion
    • Lesson 05 - Advanced Security in SQL Server
      • 5.1 Advanced Security in SQL Server
      • 5.2 Objectives
      • 5.3 Working with Digital Certificates
      • 5.4 Digital Certificates
      • 5.5 Private and Public Keys
      • 5.6 Keys in SQL Server
      • 5.7 Certificate Based Logins
      • 5.8 Certificate Based Logins (contd.)
      • 5.9 Creating Certificate Based Logins
      • 5.10 Creating Certificate Based Logins Demo 01
      • 5.11 Auditing and Policies
      • 5.12 SQL Server Auditing
      • 5.13 Audit Specifications
      • 5.14 Audit Reports
      • 5.15 Creating and Viewing Audits
      • 5.16 Creating and Viewing Audits Demo 2
      • 5.17 Policy Based Management
      • 5.18 Policy
      • 5.19 Advantages of Policy
      • 5.20 Components of Policy
      • 5.21 Setting up Policy Based Management
      • 5.22 Setting up Policy Based Management Demo 3
      • 5.23 Encryption and Compression
      • 5.24 Encryption in SQL Server
      • 5.25 Transparent Data Encryption
      • 5.26 Column Level Encryption
      • 5.27 Compression
      • 5.28 Using TDE and Compression
      • 5.29 Using TDE and Compression Demo 4
      • 5.30 Quiz
      • 5.31 Summary
      • 5.32 Conclusion
    • Lesson 06 - Working with Indexes and Files
      • 6.1 Working with Indexes and Files
      • 6.2 Objectives
      • 6.3 Understanding Indexes
      • 6.4 Indexes
      • 6.5 Index Types
      • 6.6 Other Index Types
      • 6.7 Adding an Index to a Table
      • 6.8 Adding an Index to a Table Demo 01
      • 6.9 Introduction to Full Text Indexing
      • 6.10 Need for Full Text Indexing
      • 6.11 Full Text Indexing
      • 6.12 Full Text Search
      • 6.13 Setting up FTI and Querying Using FTS
      • 6.14 Setting up FTI and Querying Using FTS Demo 02
      • 6.15 New Index Types in SQL Server 2012
      • 6.16 Column Store Index
      • 6.17 FILESTREAM
      • 6.18 FILETABLE
      • 6.19 Using a Column Store Index
      • 6.20 Using a Column Store Index Demo 03
      • 6.21 Setting up New iFilters for FTI
      • 6.22 Setting up New iFilters for FTI Demo 04
      • 6.23 Setting up a New FILETABLE
      • 6.24 Setting up a New FILETABLE Demo 05
      • 6.25 Quiz
      • 6.26 Summary
      • 6.27 Conclusion
    • Lesson 07 - Maintaining Reliability of SQL Server Installations
      • 7.1 Maintaining Reliability of SQL Server Installations
      • 7.2 Objectives
      • 7.3 Detaching and Attaching Databases
      • 7.4 Detaching a Database
      • 7.5 Attaching a Database
      • 7.6 Detach and Attach a Database
      • 7.7 Detach and Attach a Database Demo 01
      • 7.8 Database Backup and Restoration
      • 7.9 Backups
      • 7.10 Backup Strategies
      • 7.11 Restore
      • 7.12 Scheduling Backups
      • 7.13 Backup, Restore, and Scheduling of Backup
      • 7.14 Backup, Restore, and Scheduling of Backup Demo 02
      • 7.15 High Availability
      • 7.16 What Is High Availability
      • 7.17 Clustering
      • 7.18 Replication
      • 7.19 Mirroring
      • 7.20 AlwaysOn
      • 7.21 Set up an SQL Server Cluster
      • 7.22 Set up an SQL Server Cluster Demo 03
      • 7.23 Quiz
      • 7.24 Summary
      • 7.25 Conclusion
    • Lesson 08 - Optimizing Servers
      • 8.1 Optimizing Servers
      • 8.2 Objectives
      • 8.3 Benchmarking Server Performance
      • 8.4 System Benchmarks
      • 8.5 Resource Governor
      • 8.6 PerfMon
      • 8.7 Using Resource Governor and PerfMon
      • 8.8 Using Resource Governor and PerfMon Demo 01
      • 8.9 DMVs and SQL Profiler
      • 8.10 Dynamic Management View (DMV)
      • 8.11 SQL Profiler
      • 8.12 Using DMVs
      • 8.13 Using DMVs Demo 02
      • 8.14 Using SQL Profiler
      • 8.15 Using SQL Profiler Demo 03
      • 8.16 Optimizing Indexes
      • 8.17 Index Statistics
      • 8.18 Fragmentation of Indexes
      • 8.19 View Index Statistics
      • 8.20 View Index Statistics Demo 04
      • 8.21 View and Rebuild Index to Reduce Fragmentation
      • 8.22 View and Rebuild Index to Reduce Fragmentation Demo 05
      • 8.23 Quiz
      • 8.24 Summary
      • 8.25 Conclusion
    • Lesson 09 - Troubleshooting Errors in SQL Server
      • 9.1 Troubleshooting Errors in SQL Server
      • 9.2 Objectives
      • 9.3 SQL Server Errors and Handling Issues
      • 9.4 SQL Server Errors
      • 9.5 Database Console Commands
      • 9.6 DBCC Error Handling
      • 9.7 Using DBCC
      • 9.8 Using DBCC Demo 01
      • 9.9 Traces
      • 9.10 Trace Flags
      • 9.11 Using Trace Flags
      • 9.12 Using Trace Flags Demo 02
      • 9.13 Extended Events
      • 9.14 What Are Extended Events
      • 9.15 Use XEvents
      • 9.16 Use XEvents Demo 03
      • 9.17 Database Recovery
      • 9.18 Database Failure
      • 9.19 Recovering a Database without a Backup
      • 9.20 Recovering a Database without a Backup Demo 04
      • 9.21 Quiz
      • 9.22 Summary
      • 9.23 Conclusion
    • Lesson 10 - Advanced Server Management
      • 10.1 Advanced Server Management
      • 10.2 Objectives
      • 10.3 Virtualization and SQL Server
      • 10.4 What Is Virtualization
      • 10.5 SQL Server and Virtualization
      • 10.6 Running SQL Server in a Virtual Environment
      • 10.7 Running SQL Server in a Virtual Environment Demo 01
      • 10.8 Updating SQL Server
      • 10.9 Updates Management
      • 10.10 Patch Deployment
      • 10.11 Updating SQL Server 2012
      • 10.12 Updating SQL Server 2012 Demo 02
      • 10.13 Data Tier Applications
      • 10.14 Client Application Connections
      • 10.15 Data Tier Applications
      • 10.16 Deployment Process
      • 10.17 Deploy Structure to Different Databases Using DTA
      • 10.18 Deploy Structure to Different Databases Using DTA Demo 03
      • 10.19 Sync Changes Made to Main Database Using DTA
      • 10.20 Sync Changes Made to Main Database Using DTA Demo 04
      • 10.21 Export Data and Structure to a New Server Using DTA
      • 10.22 Export Data and Structure to a New Server Using DTA Demo 05
      • 10.23 Quiz
      • 10.24 Summary
      • 10.25 Conclusion

Achievements for this centre

2016

Students that were interested in this course also looked at...
See all