Microsoft SQL Server Certification Exam
 
 

Microsoft SQL Database Administration Certification Training: 70-462

About this course

This 7 Weeks instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

 

Administering Microsoft SQL Server 2012/2014 Databases

I) Install and Configure

Plan installation

Evaluate installation requirements; design the installation of SQL Server and its components (drives, service accounts, etc.); plan scale-up vs. scale-out basics; plan for capacity, including if/when to shrink, grow, autogrow, and monitor growth; manage the technologies that influence SQL architecture (for example, service broker, full text, scale out, etc.); design the storage for new databases (drives, filegroups, partitioning); design database infrastructure; configure a SQL Server standby database for reporting purposes; Windows-level security and service level security; Core mode installation; benchmark a server before using it in a production environment (SQLIO, Tests on SQL Instance); choose the right hardware

Install SQL Server and related services

Test connectivity; enable and disable features; install SQL Server database engine and SSIS (not SSRS and SSAS); configure an OS disk

Implement a migration strategy

Restore vs detach/attach; migrate security; migrate from a previous version; migrate to new hardware; migrate systems and data from other sources

Configure additional SQL Server components

Set up and configure all SQL Server components (Engine, AS, RS and SharePoint integration) in a complex and highly secure environment; configure full-text indexing; SSIS security; filestream; filetable

Manage SQL Server Agent

Create, maintain, and monitor jobs; administer jobs and alerts; automate (setup, maintenance, monitoring) across multiple databases and multiple instances; send to "Manage SQL Server Agent jobs"

 

II) Maintain instances and Databases

Manage and configure databases

Design multiple file groups; database configuration and standardization: autoclose, autoshrink, recovery models; manage file space, including adding new filegroups and moving objects from one filegroup to another; implement and configure contained databases; data compression; configure TDE; partitioning; manage log file growth; DBCC

Configure SQL Server instances

Configure and standardize a database: autoclose, autoshrink, recovery models; install default and named instances; configure SQL to use only certain CPUs (affinity masks, etc.); configure server level settings; configure many databases/instance, many instances/server, virtualization; configure clustered instances including MSDTC; memory allocation; database mail; configure SQL Server engine: memory, filffactor, sp_configure, default options

Implement a SQL Server clustered instance

Install a cluster; manage multiple instances on a cluster; set up subnet clustering; recover from a failed cluster node

Manage SQL Server instances

Install an instance; manage interaction of instances; SQL patch management; install additional instances; manage resource utilization by using Resource Governor; cycle error logs

 

III) Optimize and Troubleshoot

Identify and resolve concurrency problems

Examine deadlocking issues using the SQL server logs using trace flags; design reporting database infrastructure (replicated databases); monitor via DMV or other MS product; diagnose blocking, live locking and deadlocking; diagnose waits; performance detection with built in DMVs; know what affects performance; locate and if necessary kill processes that are blocking or claiming all resources

Collect and analyze troubleshooting data

Monitor using Profiler; collect performance data by using System Monitor; collect trace data by using SQL Server Profiler; identify transactional replication problems; identify and troubleshoot data access problems; gather performance metrics; identify potential problems before they cause service interruptions; identify performance problems;, use XEvents and DMVs; create alerts on critical server condition; monitor data and server access by creating audit and other controls; identify IO vs. memory vs. CPU bottlenecks; use the Data Collector tool

Audit SQL Server instances

Implement a security strategy for auditing and controlling the instance; configure an audit; configure server audits; track who modified an object; monitor elevated privileges as well as unsolicited attempts to connect; policy-based management

 

IV) Manage Data

Configure and maintain a back-up strategy

Manage different backup models, including point-in-time recovery; protect customer data even if backup media is lost; perform backup/restore based on proper strategies including backup redundancy; recover from a corrupted drive; manage a multi-TB database; implement and test a database implementation and a backup strategy (multiple files for user database and tempdb, spreading database files, backup/restore); back up a SQL Server environment; back up system databases

Restore databases

Restore a database secured with TDE; recover data from a damaged DB (several errors in DBCC checkdb); restore to a point in time; file group restore; page level restore

Implement and maintain indexes

Inspect physical characteristics of indexes and perform index maintenance; identify fragmented indexes; identify unused indexes; implement indexes; defrag/rebuild indexes; set up a maintenance strategy for indexes and statistics; optimize indexes (full, filter index); statistics (full, filter) force or fix queue; when to rebuild vs. reorg and index; full text indexes; column store indexes

Import and export data

Transfer data; bulk copy; bulk insert

 

V) Implement Security

Manage logins and server roles

Configure server security; secure the SQL Server using Windows Account / SQL Server accounts, server roles; create log in accounts; manage access to the server, SQL Server instance, and databases; create and maintain user-defined server roles; manage certificate logins

Manage database security

Configure database security; database level, permissions; protect objects from being modified; auditing; encryption

Manage users and database roles

Create access to server / database with least privilege; manage security roles for users and administrators; create database user accounts; contained login

Troubleshoot security

Manage certificates and keys; endpoints

 

VI) Implement High Availability

Implement AlwaysOn

Implement AlwaysOn availability groups; implement AlwaysOn failover clustering

Implement replication

Troubleshoot replication problems; identify appropriate replication strategy

 

Passing Exam 70-462 counts as credit toward the following certifications:

 

For course details and registration, please visit: SQL DBA Training Course

Microsoft Certification Exam - for SQL Server 2014. SQL School Training Institute provides In-DEPTH Certification Training & Guidance for Microsoft 70-461 Exam. 100% Guaranteed Results.

Source of Information for Certifications: Source: https://www.microsoft.com/en-us/learning/exam-70-462.aspx

 

SQL Server Training, SQL DBA Training, MSBI Certification Trainings & Support. Register Today

 

 

 

 

All our trainings are CERTIFICATION ORIETED & JOB ORIENTED. All the VERY BEST!

 

Follow us on Facebook         Get Technology Updates on LinkedIn         Track Technical Events on Google+
 

 

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google:4.7/5

Facebook:4.8/5

Sulekha:4.8/5

JustDial:4.7/5

MouthShut:5/5

UrbanPro:5/5

Yet5:5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social