20761 – Querying Data with Transact-SQL

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. 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 2016
  • The Basic Architecture of SQL Server
  • 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
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values
  • Introducing SQL Server 2016 Data Types
  • Working with SQL Server 2016 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 Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

Proximamente en calendario

Certificaciones Asociadas:  Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development

CursosDuraciónExámenes
20761 - Querying Data with Transact-SQL40 hrs70-761 - Querying Data with Transact-SQL
20762 - Developing SQL Databases40 hrs.70-762 - Developing SQL Databases

24 octubre, 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