Administering Microsoft SQL Server 2012 Databases - 70-462
4.4 (82 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.
682 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Administering Microsoft SQL Server 2012 Databases - 70-462

Learn how to build and use databases in SQL Server platform
4.4 (82 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.
682 students enrolled
Created by Compaq learning
Last updated 9/2016
English
Price: $60
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Store and manage data in SQL Server
  • Elevate performance and troubleshoot problems
  • Apply high availability
  • Construct server security
  • Connect and organize SQL Server
  • Sustain instances and databases
View Curriculum
Requirements
  • Knowledge of TSQL, javascript and C++ will be an added advantage for any particpant who is taking up this course. awareness about RDMS would be an added advantage.
Description

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data system. It is an excellent platform for students to build database systems, ensure effective operation of the systems apart from storing, and securing data from any kind of unauthorized access. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-462, also known as Administering Microsoft SQL Server 2012 Databases.

Towards the end of this course our participants will have a thorough knowledge on maintaining various databases including the instances, trouble shooting and optimizing apart from data management and contriving high availability and security.

This course is that is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration.

Apart from this as a student you will keen to look into the various operations involved including backup and restore operations that can be performed. You will also find it both challenging and interesting to learn how databases and database files are moved. There will also be a discussion on some of the important topics namely, instance, database and object security strategies. Some of the high availability technologies will also be discussed as part of the training.

Our training is broken down to 115 lecture sessions that will cover all objectives. As add on, we are also providing demos on other major concepts so that participants understand how the steps learned are implemented in real time.

Who is the target audience?
  • Any database professional who is involved in the installation, configuration, and maintenance tasks of databases. Freshers can also take up this course for brushing up the basics of data storage.
Compare to Other Microsoft SQL Courses
Curriculum For This Course
98 Lectures
05:19:59
+
SQL Server Tools and Installation
7 Lectures 37:19



Installing SQL Server 2012
02:05

Demo - Installing SQL Server 2012
07:10

Demo - Exploring the Installed Components
01:32

Quiz
3 questions

Conclusion
01:21
+
Managing the Database Server
10 Lectures 27:34
Managing the Database Server
00:37

Server Properties and sp configure
04:00

Demo - Viewing Server Properties and Using sp configure
02:15

Advanced Options
01:48

Demo - Enabling Advanced Options, and Viewing and Modifying Them
01:39

CPU and Memory Architectures
07:32

Demo - Working with CPU Affinity and Memory Configurations
03:05

Configuring Database Mail
03:09

Demo - Set up Database Mail
02:36

Quiz
3 questions

Conclusion
00:53
+
Managing Databases
10 Lectures 34:51
Managing Databases
02:47

Types of Databases
03:23

Demo - Creating User and Contained Databases
02:35

System Databases
05:50

Database Options
05:40

Demo-Looking at Auto Close and Auto Shrink and Checking Disk Space of a Database
02:43

Demo - Moving between File Groups
05:02

Recovery Models
05:28

Changing_Recovery_Model_Demo_04
00:24

Quiz
3 questions

Conclusion
00:59
+
SQL Server Security
10 Lectures 35:51
SQL Server Security
00:30

Security Model and Types of Accounts in SQL Server
07:00

Demo - Using Accounts in SQL Server
04:55

Server Roles
07:14

Demo - Managing Server Roles
02:23

Managing Permissions
03:32

Demo - Using GRANT and DENY
03:08

Database Roles and Permissions
03:00

Demo - Using Database Roles
03:19

Quiz
3 questions

Conclusion
00:50
+
Advanced Security in SQL Server
12 Lectures 43:03
Advanced Security in SQL Server
00:30

Working with Digital Certificates
02:31

Private and Public Keys
03:38

Certificate Based Logins
01:28

Demo - Creating Certificate Based Logins
04:14

Auditing and Policies
04:12

Demo - Creating and Viewing Audits
05:34

Policy Based Management
03:26

Demo - Setting up Policy Based Management
05:23

Encryption and Compression
04:25

Demo - Using TDE and Compression
06:58

Quiz
3 questions

Conclusion
00:44
+
Working with Indexes and Files
10 Lectures 36:43
Working with Indexes and Files
00:27

Understanding Indexes
06:39

Adding_an_Index_to_a_Table_Demo
01:46

Introduction to Full Text Indexing
06:23

Setting_up_FTI_and_Querying_Using_FTS_Demo
04:18

Column Store Index
04:15

Using_a_Column_Store_Index_Demo
01:43

Setting_up_New_iFilters_for_FTI_Demo
02:19

Setting_up_a_New_FILETABLE_Demo_05
07:51

Quiz
3 questions

Conclusion
01:02
+
Maintaining Reliability of SQL Server Installations
8 Lectures 26:14
Maintaining Reliability of SQL Server Installations
00:33

Detaching and Attaching Databases
03:01

Detach and Attach a Database_Demo
01:29

Database Backup and Restoration
05:49

Backup_Restore_and_Scheduling_of_Backup_Demo
02:25

High Availability
07:15

Set_up_an_SQL_Server_Cluster_Demo
04:49

Quiz
3 questions

Conclusion
00:53
+
Optimizing Servers
10 Lectures 21:37
Optimizing Servers
00:25

Benchmarking Server Performance
03:25

Using_Resource_Governor_and_PerfMon_Demo
04:16

DMVs and SQL Profiler
02:43

Using_DMVs_Demo_02
02:58

Using_SQL_Profiler_Demo_03
02:01

Optimizing Indexes
02:20

View_Index_Statistics_Demo_04
02:19

View_and_Rebuild_Index_to_Reduce_Fragmentation_Demo_05
00:27

Quiz
3 questions

Conclusion
00:43
+
Troubleshooting Errors in SQL Server
10 Lectures 20:50
Troubleshooting Errors in SQL Server
00:28

SQL Server Errors and Handling Issues
03:07

Using_DBCC_Demo_01
01:56

Traces
02:12

Using_Trace_Flags_Demo_02
02:02

Extended Events
00:40

Use_XEvents_Demo_03
02:46

Database Recovery
01:24

Recovering_a_Database_without_a_Backup_Demo_04
05:32

Quiz
2 questions

Conclusion
00:43
+
Advanced Server Management
11 Lectures 35:57
Advanced Server Management
00:27

Virtualization and SQL Server
04:01

Running_SQL_Server_in_a_Virtual_Environment_Demo_01
01:39

Updating SQL Server
04:36

Updating_SQL_Server_2012_Demo_02
06:06

Data Tier Applications
03:40

Deployment Process
02:17

Deploy_Structure_to_Different_Databases_Using_DTA_Demo_03
04:50

Sync_Changes_Made_to_Main_Database_Using_DTA_Demo_04
03:33

Export_Data_and_Structure_to_a_New_Server_Using_DTA_Demo_05
03:51

Quiz
3 questions

Conclusion
00:57
About the Instructor
Compaq learning
4.2 Average rating
373 Reviews
2,938 Students
6 Courses
One stop to learn and succeed

With a clear motto to upgrade the skills of students from high school goers to professionals, Compaq learning started its tutoring journey in 2013. But within two years, an effort by three IT professionals that started as a blog went on to become one of the largest course developing company in the e learning industry.

We kick started our stint in the e-learning world by mentoring high school students. The passion for teaching and mentoring students gave us the confidence and courage to plunge into the e learning industry and provide various guidance for high school students to IT professionals. Until now we have trained around 15,000 students in various subjects ranging from simple mathematics to android app development. We have a group of fine instructional designers, graphic designers and SMEs who ensure that our products are original and valuable.