20461 – Querying Microsoft SQL Server

A Distancia

On demand

Objetivo:

 

Este curso provee a los estudiantes los conocimientos y técnicas necesarias para escribir consultas Transact-SQL para Microsoft SQL Server 2014.

 

Requisitos:

 

Conocimientos de sistemas operativos basados en MS Windows. Experiencia en el diseño y uso de bases de datos relacionales y diseño de nuevas estructuras.

 

Duración:

 

40 horas

 

Temario:

 

  • Introduction to Microsoft SQL Server 2014
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Introduction to T-SQL Querying
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Writing SELECT Queries
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Querying Multiple Tables
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Sorting and Filtering Data
  • Working with Unknown Values
  • Working with SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
  • Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Using Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions
  • Using Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Using Window Ranking, Offset and Aggregate Functions
  • Creating Windows with OVER
  • Exploring Window Functions
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Programming with T-SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
  • Implementing Error Handling
  • Implementing Structured Exception Handling
  • Implementing Transactions
  • Transactions and the Database Engine
  • Controlling Transactions
  • Improving Query Performance
  • Querying SQL Server Metadata

Ver calendario

 

18 noviembre, 2016

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin