Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

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

Description 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.

course category: 
Format: 
Promote to front: 
Not Published to frontend: 
vendor: 
Back to Top