Quality Seal Emagister EMAGISTER CUM LAUDE

Administering MS SQL server 2012 Databases

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • 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.

Important information

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

Compare this course with other similar courses
See all