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 SQL Server 2012

EDUTAINMENT COURSE E-Learning

Microsoft 70-461: Querying SQL Server 2012

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines namely, Database Administration, Database Development and Business Intelligence. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Objectives
  • Work with Data
  • Query data by using SELECT statements
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements)
  • Create and alter views (simple statements)
  • Design views
  • Create and modify constraints (simple statements)
  • Implement sub-queries
  • Implement data types
  • Implement aggregate queries
  • Modify Data
  • Create and alter stored procedures (simple statements)
  • Modify data by using INSERT, UPDATE, and DELETE statements
  • Implement error handling
  • Work with functions
  • Combine datasets
  • Troubleshoot & Optimise
  • Optimize queries
  • Manage transactions
  • Evaluate the use of row-based operations vs. set-based operations
  • Create and alter DML triggers
  • Query and manage XML data
Target Audience
  • SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.

Lesson 1: Getting Started with SQL Server 2012

Lesson 2: Working with T-SQL

Lesson 3: Writing SELECT Queries

Lesson 4: Working with SQL Data Types

Lesson 5: Sorting and Filtering Data

Lesson 6: Querying Data from Multiple Tables

Lesson 7: Modifying Data

Lesson 8: Working with SQL Server Built-in Functions

Lesson 9: Programming in T-SQL

Lesson 10: Implementing Stored Procedures

Lesson 11: Working with Subqueries and Table Expressions

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

Lesson 14: Managing Error Handling and Transactions

Lesson 15: Querying SQL Server System

Lesson 16: Optimizing Query Performance

EDUTAINMENT COURSE E-Learning
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59
  • 06:54:41
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top