The Christmas Bonanza Offer Pick 1 get 1 free + 10% additional off! Hurry Up! - Get Details
Learn to store and retrieve data using Microsoft SQL  Server through online trainin

10774 Querying Microsoft SQL Server 2012 Online Training

Learn to store and retrieve data using Microsoft SQL Server through online trainin

     142 Learners       Add to wishlist

Play Video

Instructor-Led Online Training

  • 32 Hrs Training
  • Certified Trainer
  • Recorded Sessions
  • Training Certificate
$ 490
ENROLL NOW
Training Schedule
Start Date End Date No. of Hrs Time (IST) Day  
23 Dec 2017 14 Jan 2018 32 06:00 PM - 10:00 PM Sat, Sun
06 Jan 2018 28 Jan 2018 32 06:00 PM - 10:00 PM Sat, Sun
13 Jan 2018 04 Feb 2018 32 06:00 PM - 10:00 PM Sat, Sun

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

Course Overview

The instructor led online training offered by Multisoft Virtual Academy provides students with the technical skills required to write basic Transact-SQL queries for Querying Microsoft SQL  Server 2012. This training is also helpful for the people who wish to prepare for exam 70-461.

This online training allows the participant to work with SQL Server Management Studio, describe the role of indexes and statistics in SQL Server, create and organize T-SQL scripts and describe the use of predicate logic in SQL Server.

Course Contents

Course ContentDetailed Course Topics
  • 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

Target Audience

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • Report Writers
  • Business Analysts
  • Client Application Developers

Certification

Multisoft Virtual Academy offers the training certificate to the aspirants, after completing the 10774: Querying Microsoft SQL Server 2012 online training.

Send us a Query

Capcha

I agree to be contacted via e-mail.

Related Courses

Combo Offers

10774 Querying Microsoft SQL Server 2012 Online Training
Rated 5/5 based on 142 votes 142 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.