Relish the Gala Offer Pick 1 get 1 free + 10% additional off! Hurry Up! - Get Details
MCSA SQL Server 2012 Online Training for Database Administrators

MCSA SQL Server 2012 Online Certification Training

MCSA SQL Server 2012 Online Training for Database Administrators

     346 Learners       Add to wishlist

Play Video

Instructor-Led Online Training

  • 24 Hrs Training
  • Experienced Trainer
  • Hands-on Sessions
  • Lifetime E-Learning
$ 525
ENROLL NOW
Training Schedule
Start Date End Date No. of Hrs Time (IST) Day  
25 Nov 2017 17 Dec 2017 24 06:00 PM - 09:00 PM Sat, Sun
02 Dec 2017 26 Dec 2017 24 06:00 PM - 09:00 PM Sat, Sun
09 Dec 2017 03 Dec 2017 24 06:00 PM - 09:00 PM Sat, Sun

Schedule does not suit you, contact us now!    |    Want to take one-on-one training, contact us now!

Course Overview

Microsoft® MCSA SQL Server 2012 online training will help to gain technical skills for handling Microsoft® Database. The online training includes administration, installation, maintenance, and troubleshooting of Database. The aspirants will have deep understanding about Data Warehousing in this online training course. The experienced trainers at Multisoft Virtual Academy will impart the knowledge of Database concepts and build the expertise of professionals to help them building career in Database Administration.

The training will provide complete database solution and will offer the training under three different courses, mentioned below:

  • Querying Microsoft SQL Server 2012
  • Administering Microsoft® SQL Server 2012 Databases
  • Implementing a Data Warehouse with Microsoft® SQL Server 2012

After completing the online training course, the candidates will become proficient in the following skills:

  • Introduce Microsoft® SQL Server platform, architecture and tools.
  • Design and implement data warehouse
  • Execute T-SQL queries - write SELECT queries, query multiple tables, sort and filter data, use built-in functions, group and aggregate data, subqueries, views, derived tables
  • Learn SQL Server 2012 data types
  • Explore SQL Azure.
  • Practice indexes, stored procedures, error handling, transactions, query performance
  • Programming with T-SQL
  • Define permissions and conduct SQL server audit
  • Install SQL server and describe physical structure of database
  • Create SQL server backup and restore databases
  • Integrate cloud data into data warehouse infrastructure, implement data cleansing, and enforce data integrity.

Course Contents

Course ContentDetailed Course Topics

Course 20461C: Querying Microsoft® SQL Server 2012

  • Introduction to Microsoft® SQL Server 2012
  • Getting Started with SQL Azure
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Query Performance

Course 20462C: Administering Microsoft® SQL Server Databases

  • Introduction to SQL Server 2014 Database Administration
  • Installing and Configuring SQL Server 2014
  • Working with Databases and Storage
  • Planning and Implementing a Backup Strategy
  • Restoring SQL Server 2014 Databases
  • Importing and Exporting Data
  • Monitoring SQL Server 2014
  • Tracing SQL Server Activity
  • Managing SQL Server Security
  • Auditing Data Access and Encrypting Data
  • Performing Ongoing Database Maintenance
  • Automating SQL Server 2014 Management
  • Monitoring SQL Server 2014 by Using Alerts and Notifications

Course 20463C: Implementing a Data Warehouse with Microsoft® SQL Server

  • Introduction to Data Warehousing
  • Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing a Data Extraction Solution
  • Loading Data into a Data Warehouse
  • Enforcing Data Quality
  • Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Target Audience

The MCSA SQL Server 2012 online training is best suited for the professionals or freshers:

  • Database Administrators
  • Database Developers
  • Client application developers
  • Business analysts

Certification

After completing the MCSA SQL Server 2012 online training, students receive a training certificate from Multisoft. Also, the candidates will get prepared to appear for the following Certification exams by Microsoft®:

S.No. Title Course Code Required Exam Certification Earned
1 Querying Microsoft SQL Server 2012 20461C 70-461 MCSA SQL Server 2012
2 Administering Microsoft SQL Server 2012 Databases 20462C 70-462
3 Implementing a Data Warehouse with Microsoft SQL Server 2012 20463C 70-463

Send us a Query

Capcha

I agree to be contacted via e-mail.

Related Courses

Combo Offers

MCSA SQL Server 2012 Online Certification Training
Rated 4/5 based on 346 votes 346 reviews

Get in Touch

Follow Us

We Accept Online Payments

Online Registration

Subscribe to our Newsletter

Find us on

Online Registration

Contact Us

Capcha

I agree to be contacted via e-mail.