Microsoft 70-462: Administering SQL Server 2012 Databases
3.8 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
126 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-462: Administering SQL Server 2012 Databases to your Wishlist.

Add to Wishlist

Microsoft 70-462: Administering SQL Server 2012 Databases

Know all about SQL Server 2012 Databases
3.8 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
126 students enrolled
Last updated 12/2016
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462.
  • At the end of this course. you will be able to Install SQL Server and related services,configure additional SQL Server components
View Curriculum
Requirements
  • Basic understanding to install, maintain and configure database
Description

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012.


Below is a partial list of job functions associated to this training course:

  • Audit SQL Server instances
  • Back up databases
  • Configure additional SQL Server components, Instances and Services
  • Deploying a SQL Server
  • Implementing strategies, columnstores and High-Availability and Disaster Recovery solutions
  • Importing/exporting
  • Install SQL Server and related services.
  • Maintenance
  • Management, configuration, permissions, alerts, logins and roles.
  • Optimization
  • Installation Planning
  • Restoring
  • Troubleshooting


The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 - As the participant in the SQL 2012 Adminstering course will learn:

  • Installation Planning
  • Installing SQL Server and related services
  • Implementation of a migration strategy
  • How to configure additional SQL Server components
  • Managing the SQL Server Agent
  • Database management and configuration
  • How to configure SQL Server instances
  • Implementing a SQL Server clustered instance
  • SQL Server instances management
  • How to properly Identify and resolve concurrency problems
  • The collection of and how to analyze troubleshooting data
  • Auditing SQL Server instances
  • Configure and maintain a back up strategy
  • Database restoration
  • Implementing and maintaining indexes
  • Importing and exporting data
  • Managing logins and server roles
  • Managing database permissions
  • Managing users and database roles
  • Troubleshooting security
  • Implementing AlwaysOn, database mirroring and replication

 

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Who is the target audience?
  • IT Professionals
  • Database Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
128 Lectures
06:57:14
+
Introduction to the course
2 Lectures 01:55

Course Modules
01:00
+
Module 1
15 Lectures 57:17
Introduction to SQL Server 2012
00:18

SQL Server Part1
01:50

SQL Server Part2
05:19


SQL Server Part4
05:20

SQL Server Tools Part1
01:02

SQL Server Tools Part2
05:32

SQL Server Tools Part3
03:05

Management Studio Demo Part1
05:35

Management Studio Demo Part2
03:56

Management Studio Demo Part3
05:49

Data Tools Part1
05:27

Data Tools Part2
03:42


Module Review
01:49
+
Module 2
14 Lectures 38:34
Installing SQL Server
00:17

SQL Architecture
01:03

Hardware Requirements Part1
07:14

Hardware Requirements Part2
03:23

Software Requirements Part1
03:16

Software Requirements Part2
01:07

Installation Process
01:33

Troubleshooting Installation
02:17

Upgrading & Unattended Installations Part1
00:07

Upgrading & Unattended Installations Part2
05:01

Configuration Demo Part1
07:12

Configuration Demo Part2
02:05

Exam Scenarios
02:55

Module Review
01:04
+
Module 3
15 Lectures 48:25
Backup and Restore a Database
00:14

Database Architecture Part1
00:11

Database Architecture Part2
07:18


Database Backup Part1
00:16

Database Backup Part2
06:44

Database Backup Part3
03:50

Restoration Process Part1
00:17

Restoration Process Part2
06:41

Restoring System Database Part1
00:05

Restoring System Database Part2
02:10

Backup and Recovery Demo Part1
07:36

Backup and Recovery Demo Part2
05:12

Exam Scenarios
04:32

Module Review
02:04
+
Module 4
14 Lectures 44:04
Tracing Access to SQL Server
00:20

Auditing Options Part1
00:15

Auditing Options Part2
07:36

Introduction to SQL Audit Part1
00:10

Introduction to SQL Audit Part2
02:01


Extended Events Part1
00:05

Extended Events Part2
00:38

Tracing Activity Demo Part1
08:16

Tracing Activity Demo Part2
06:53

Tracing Activity Demo Part3
04:09

Tracing Activity Demo Part4
04:54

Exam Scenarios
03:02

Module Review
01:03
+
Module 5
14 Lectures 31:10
Importing and Exporting Data
00:15

Introduction to Data Transfer Part1
00:08

Introduction to Data Transfer Part2
01:14

ETL Tools
06:05

Improving Data Transfer Part1
01:45

Improving Data Transfer Part2
00:46

Improving Data Transfer Part3
00:57

Improving Data Transfer Part4
03:50

Copying Database Methods Part1
03:03

Copying Database Methods Part2
00:42

Transferring Data Demo Part1
04:36

Transferring Data Demo Part2
04:24

Exam Scenarios
02:18

Module Review
01:07
+
Module 6
9 Lectures 41:18
SQL Server Security
00:08

Security and Authentication
08:05


Permissions Part1
03:35

Permissions Part2
07:47

Securing SQL Server Demo Part1
07:53

Securing SQL Server Demo Part2
05:49

Exam Scenarios
02:32

Module Review
01:25
+
Module 7
10 Lectures 40:50
Automating SQL Server
00:10

SQL Server Agent
04:03

Database Mail
04:16

Operators, Alerts and Jobs
08:18

Database Configuration Demo Part1
03:08

Database Configuration Demo Part2
07:20

Database Configuration Demo Part3
06:21

Database Configuration Demo Part4
03:04

Exam Scenarios
02:42

Module Review
01:28
+
Module 8
15 Lectures 46:52
Monitoring SQL Server
00:23

Dynamic Management Views and Functions
01:12

Profiler Trace
01:13


Activity and Performance Monitor
02:30

Data Collection
03:52

Monitoring Demo Part1
03:59

Monitoring Demo Part2
06:03

Monitoring Demo Part3
04:38

Monitoring Demo Part4
04:16

Monitoring Demo Part5
04:51

Monitoring Demo Part6
03:56

Monitoring Demo Part7
02:58

Exam Scenarios
03:52

Module Review
01:42
+
Module 9
11 Lectures 43:37
Maintaining SQL Server
00:12

Checking Database Integrity
04:14

Indexing Part1
06:10

Indexing Part2
05:28

Indexing Part3
01:47

Ongoing Maintenance
03:41

Managing and Maintaining Demo Part1
05:50

Managing and Maintaining Demo Part2
07:18

Managing and Maintaining Demo Part3
06:09

Exam Scenarios
01:51

Module Review
00:57
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
1,693 Reviews
11,344 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,628 Reviews
275,240 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.