> > 20461-CORE

Querying Microsoft SQL Server 2014 MOC On-Demand Core

 

Quién debería asistir

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

Prerrequisitos

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Objetivos del curso

  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

Descripción del Producto

This course teaches students to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines and helps people prepare for exam 70-461.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Precio (sin incluir impuestos)
  • US$ 450,-
COMPRE AHORA