Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-461: Querying Microsoft SQL Server 2014

LIVE LAB:

Microsoft 70-461: Querying Microsoft SQL Server 2014

Practical exercises in a live environment to help you get real-world, hands-on experience.
Overview

This course introduces viewers to Microsoft Transact-SQL,  the language used to input and retrieve data from Microsoft SQL servers.  The series is designed for viewers of all experience levels as it walks through running your very first query all the way through crafting advanced server-side stored procedures.This module will teach students how to write necessary Transact-SQL queries for MS SQL Server 2014.  This module is planned for Database Developers,  Database Administrators,  and Business Intelligence professionals.  After completing this module,  students will be able to:  explain the basic architecture and concepts of MS SQL Server and comprehend the differences and similarities between Transact-SQL and other computer languages.

Objectives
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
Prerequisites

Working knowledge of relational databases.

Target Audience

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

LIVE LAB
?Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 69
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • No simulation – 100% actual hands-on exercises
  • FREE 24x7 Support via Email, Phone, and Chat
  • 12 Months access
Back to Top