Administering Microsoft SQL Server 2012 Databases - 70-462

Learn how to build and use databases in SQL Server platform
4.2 (37 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.
409 students enrolled
$19
$60
68% off
Take This Course
  • Lectures 98
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

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

What are the 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.

What am I going to get from this course?

  • 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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: SQL Server Tools and Installation
SQL Server Tools and InstallationMy First Lecture
Preview
02:25
SQL Server 2012 Components and Their Uses
Preview
06:32
Planning SQL Server Installation
Preview
16:14
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
Section 2: Managing the Database Server
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
Section 3: Managing Databases
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
Section 4: SQL Server Security
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
Section 5: Advanced Security in SQL Server
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
Section 6: Working with Indexes and Files
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
Section 7: Maintaining Reliability of SQL Server Installations
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
Section 8: Optimizing Servers
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
Section 9: Troubleshooting Errors in SQL Server
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Compaq learning, 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.

Ready to start learning?
Take This Course