simplilearn

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

0.0
Not rated
Course rating
100%
Recommended
4.5
excellent
Centre rating

Reviews on other courses at this centre

Designing Database Solutions for MS SQL Server 2012

S
Subhabrata
4.0 14/03/2018
What I would highlight: Excellent explanation of concepts through real life examples . Course content was helpful.
Would you recommend this course?: Yes

Developing MS SQL Server 2012 Database

S
Saugata Guharoy
5.0 14/03/2017
What I would highlight: The training was simple and easy to understand, the course content was excellent.
Would you recommend this course?: Yes

Red Hat Certified System Administrator (RHCSA)

P
Pallab Ganguly
4.5 14/03/2016
What I would highlight: This is a good course delivered in a short period . Valuable knowledge have been gathered through the course. The faculty was good and explained each and every chapter in a easy manner. Overall the course was fantastic.
Would you recommend this course?: Yes

Certified Six Sigma Green Belt

G
Girish Ravi
4.5 21/12/2015
What I would highlight: I can say you simply learn here as learning is made simple. Good experienced trainers, lots of options to learn from - online, virtual classroom etc. Learning never stops when you are associated with Simplilearn. So many courses to choose from across project management, quality, technology, business etc. Got my PMP credentials too through Simplilearn and journey continues. Am happy I chose Simplilearn. Happy Learning.
What could be improved: Nothing
Would you recommend this course?: Yes

Advanced HTML

K
Kanika
4.5 21/12/2015
What I would highlight: "The modules on Facebook & Youtube Marketing as well as Analytics are of great value. It helped me build a good understanding of digital marketing fundamentals."
What could be improved: Nothing
Would you recommend this course?: Yes
See all
Reviews gathered by Emagister & iAgora

Achievements for this centre

2017
2016

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 2 years

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

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