Administering Microsoft SQL Server 2012 Databases 70-462

Administering Microsoft SQL Server 2012 Databases – 70-462, available at $19.99, has an average rating of 4.4, with 98 lectures, 10 quizzes, based on 319 reviews, and has 7567 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful for 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.

Enroll now: Administering Microsoft SQL Server 2012 Databases – 70-462

Summary

Title: Administering Microsoft SQL Server 2012 Databases – 70-462

Price: $19.99

Average Rating: 4.4

Number of Lectures: 98

Number of Quizzes: 10

Number of Published Lectures: 98

Number of Published Quizzes: 10

Number of Curriculum Items: 108

Number of Published Curriculum Objects: 108

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012which 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.

Course Curriculum

Chapter 1: SQL Server Tools and Installation

Lecture 1: SQL Server Tools and InstallationMy First Lecture

Lecture 2: SQL Server 2012 Components and Their Uses

Lecture 3: Planning SQL Server Installation

Lecture 4: Installing SQL Server 2012

Lecture 5: Demo – Installing SQL Server 2012

Lecture 6: Demo – Exploring the Installed Components

Lecture 7: Conclusion

Chapter 2: Managing the Database Server

Lecture 1: Managing the Database Server

Lecture 2: Server Properties and sp configure

Lecture 3: Demo – Viewing Server Properties and Using sp configure

Lecture 4: Advanced Options

Lecture 5: Demo – Enabling Advanced Options, and Viewing and Modifying Them

Lecture 6: CPU and Memory Architectures

Lecture 7: Demo – Working with CPU Affinity and Memory Configurations

Lecture 8: Configuring Database Mail

Lecture 9: Demo – Set up Database Mail

Lecture 10: Conclusion

Chapter 3: Managing Databases

Lecture 1: Managing Databases

Lecture 2: Types of Databases

Lecture 3: Demo – Creating User and Contained Databases

Lecture 4: System Databases

Lecture 5: Database Options

Lecture 6: Demo-Looking at Auto Close and Auto Shrink and Checking Disk Space of a Database

Lecture 7: Demo – Moving between File Groups

Lecture 8: Recovery Models

Lecture 9: Changing_Recovery_Model_Demo_04

Lecture 10: Conclusion

Chapter 4: SQL Server Security

Lecture 1: SQL Server Security

Lecture 2: Security Model and Types of Accounts in SQL Server

Lecture 3: Demo – Using Accounts in SQL Server

Lecture 4: Server Roles

Lecture 5: Demo – Managing Server Roles

Lecture 6: Managing Permissions

Lecture 7: Demo – Using GRANT and DENY

Lecture 8: Database Roles and Permissions

Lecture 9: Demo – Using Database Roles

Lecture 10: Conclusion

Chapter 5: Advanced Security in SQL Server

Lecture 1: Advanced Security in SQL Server

Lecture 2: Working with Digital Certificates

Lecture 3: Private and Public Keys

Lecture 4: Certificate Based Logins

Lecture 5: Demo – Creating Certificate Based Logins

Lecture 6: Auditing and Policies

Lecture 7: Demo – Creating and Viewing Audits

Lecture 8: Policy Based Management

Lecture 9: Demo – Setting up Policy Based Management

Lecture 10: Encryption and Compression

Lecture 11: Demo – Using TDE and Compression

Lecture 12: Conclusion

Chapter 6: Working with Indexes and Files

Lecture 1: Working with Indexes and Files

Lecture 2: Understanding Indexes

Lecture 3: Adding_an_Index_to_a_Table_Demo

Lecture 4: Introduction to Full Text Indexing

Lecture 5: Setting_up_FTI_and_Querying_Using_FTS_Demo

Lecture 6: Column Store Index

Lecture 7: Using_a_Column_Store_Index_Demo

Lecture 8: Setting_up_New_iFilters_for_FTI_Demo

Lecture 9: Setting_up_a_New_FILETABLE_Demo_05

Lecture 10: Conclusion

Chapter 7: Maintaining Reliability of SQL Server Installations

Lecture 1: Maintaining Reliability of SQL Server Installations

Lecture 2: Detaching and Attaching Databases

Lecture 3: Detach and Attach a Database_Demo

Lecture 4: Database Backup and Restoration

Lecture 5: Backup_Restore_and_Scheduling_of_Backup_Demo

Lecture 6: High Availability

Lecture 7: Set_up_an_SQL_Server_Cluster_Demo

Lecture 8: Conclusion

Chapter 8: Optimizing Servers

Lecture 1: Optimizing Servers

Lecture 2: Benchmarking Server Performance

Lecture 3: Using_Resource_Governor_and_PerfMon_Demo

Lecture 4: DMVs and SQL Profiler

Lecture 5: Using_DMVs_Demo_02

Lecture 6: Using_SQL_Profiler_Demo_03

Lecture 7: Optimizing Indexes

Lecture 8: View_Index_Statistics_Demo_04

Lecture 9: View_and_Rebuild_Index_to_Reduce_Fragmentation_Demo_05

Lecture 10: Conclusion

Chapter 9: Troubleshooting Errors in SQL Server

Lecture 1: Troubleshooting Errors in SQL Server

Lecture 2: SQL Server Errors and Handling Issues

Lecture 3: Using_DBCC_Demo_01

Lecture 4: Traces

Lecture 5: Using_Trace_Flags_Demo_02

Lecture 6: Extended Events

Instructors

Compaq learning
One stop to learn and succeed

Rating Distribution

1 stars: 3 votes

2 stars: 12 votes

3 stars: 46 votes

4 stars: 145 votes

5 stars: 113 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!