loader
The content, images, pictures, graphics etc. on the site could include technical inaccuracies or typographical errors. Correction and changes are periodically made to the information herein. RVR Edutech may make improvements and/or changes herein at any time at its sole discretion. In any event, RVR Edutech shall not be liable to any party for any direct, indirect, special or other consequential damages for any use of the site.

MCSA DATABASE ADMINISTRATION

Master new technologies, and stand out among other Database administrators. Gain recognition with your skills.


MS SQL Server DBA

About Course

This is a detailed SQL Server DBA Training Course will help you understand all about database administration and become a Database Administrator. You will get a clear understanding about installation, functioning and authentication types in SQL servers. This Course also covers managing, maintaining and securing of databases, and automation of SQL Server.

 

Course Duration: - 3 months

 

What you will learn in this Course?

Querying Microsoft SQL Server 2012 (70-461)

  • Microsoft SQL Server
  • Transact SQL Querying
  • Write Select Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • SQL Server Data Types
  • DML to Modify Data
  • Built-In Functions
  • Grouping and Aggregating Data
  • Sub Queries
  • Table Expressions
  • Set Operators
  • Pivoting and Grouping Sets
  • Programming with T-SQL
  • Implement Error Handling
  • Implement Transactions

Administering Microsoft SQL Server Databases (70-462)

  • Introduction SQL Server
  • Install and Configure SQL Server 2014
  • Work with Databases and Storage
  • Plan and Implement a Backup Strategy
  • Restore SQL Server 2014 Databases
  • Import and Export Data
  • Monitor SQL Server 2014
  • Tracing SQL Server Activity
  • Manage SQL Server Security
  • Audit Data Access and Encrypt Data
  • Perform Ongoing Database Maintenance
  • Automate SQL Server 2014 Management
  • Monitor SQL Server 2014 Using Alerts and Notification

Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

  • Data Warehousing
  • Data Warehouse Infrastructure
  • Design and Implement a Data Warehouse
  • Create an ETL Solution with SSIS
  • Implement a Incremental ETL Process
  • Enforce Data Quality
  • Master Data Services
  • Extend SQL Server Integration Services
  • Consume Data in a Data Warehouse

 

Who should take this Course?

Software developers and IT professionals

Database analysts and administrators

SQL programmers and architects

Project Managers

Those aspiring for a career in MS SQL Server

Undergraduate/graduate Students

 

What are prerequisites for taking Course?

10+2, PURSUING GRADUATION, DIPLOMA

 

What are the Opportunities after This Course Completion? 
Database Administrator

Apply Now