Querying Data with Transact-SQL
20761
Intermedio
DDBB SQL Server
30 horas
480 €
Convocatorias
Inicio - Fin
Horario  
No hay convocatorias abiertas
Descripción

Este curso es una introducción a Transact-SQL y en él se explican las bases de la administración y el desarrollo de base de datos. Este curso ayuda a personas a prepararse para el examen 70-461.

Este curso está dirigido a los administradores de bases de datos, desarrolladores de base de datos y profesionales de Business Intelligence.


Objetivos
El objetivo principal de este curso es dotar a los estudiantes con una base sólida de conocimiento para luego poder asistir a otros curso de especialización de SQL, por lo que en este primer nivel se explican los fundamentos del lenguaje Transact-SQL, que es utilizado como base para la administración, el desarrollo o la creación de repositorios Business Intelligence con SQL Server.
    Contenido

    Module 1: Introduction to Microsoft SQL Server 2016

    ·      The Basic Architecture of SQL Server

    ·      SQL Server Editions and Versions

    ·      Getting Started with SQL Server Management Studio

    Module 2: Introduction to T-SQL Querying

    ·      Introducing T-SQL

    ·      Understanding Sets

    ·      Understanding Predicate Logic

    ·      Understanding the Logical Order of Operations in SELECT statements

    Module 3: Writing SELECT Queries

    ·      Writing Simple SELECT Statements

    ·      Eliminating Duplicates with DISTINCT

    ·      Using Column and Table Aliases

    ·      Writing Simple CASE Expressions

    Module 4: Querying Multiple Tables

    ·      Understanding Joins

    ·      Querying with Inner Joins

    ·      Querying with Outer Joins

    ·      Querying with Cross Joins and Self Joins

    Module 5: Sorting and Filtering Data

    ·      Sorting Data

    ·      Filtering Data with Predicates

    ·      Filtering Data with TOP and OFFSET-FETCH

    ·      Working with Unknown Values

    .Module 6: Working with SQL Server 2016 Data Types

    ·      Introducing SQL Server 2016 Data Types

    ·      Working with Character Data

    ·      Working with Date and Time Data

    Module 7: Using DML to Modify Data

    ·      Inserting Data

    ·      Modifying and Deleting Data

    Module 8: Using Built-In Functions

    ·      Writing Queries with Built-In Functions

    ·      Using Conversion Functions

    ·      Using Logical Functions

    ·      Using Functions to Work with NULL

    Module 9: Grouping and Aggregating Data

    ·      Using Aggregate Functions

    ·      Using the GROUP BY Clause

    ·      Filtering Groups with HAVING

    Module 10: Using Subqueries

    ·      Writing Self-Contained Subqueries

    ·      Writing Correlated Subqueries

    ·      Using the EXISTS Predicate with Subqueries.

    Module 11: Using Table Expressions

    ·      Using Views

    ·      Using Inline Table-Valued Functions

    ·      Using Derived Tables

    ·      Using Common Table Expressions

    Module 12: Using Set Operators

    ·      Writing Queries with the UNION operator

    ·      Using EXCEPT and INTERSECT

    ·      Using APPLY

    Module 13: Using Windows Ranking, Offset, and Aggregate Functions

    ·      Creating Windows with OVER

    ·      Exploring Window Functions

    Module 14: Pivoting and Grouping Sets

    ·      Writing Queries with PIVOT and UNPIVOT

    ·      Working with Grouping Sets

    Module 15: Executing Stored Procedures

    ·      Querying Data with Stored Procedures

    ·      Passing Parameters to Stored procedures

    ·      Creating Simple Stored Procedures

    ·      Working with Dynamic SQL

    Module 16: Programming with T-SQL

    ·      T-SQL Programming Elements

    ·      Controlling Program Flow

    Module 17: Implementing Error Handling

    ·      Implementing T-SQL error handling

    ·      Implementing structured exception handling

    Module 18: Implementing Transactions

    ·      Transactions and the database engines

    ·      Controlling transactions

    Itinerario
    Este curso pertenece al itinerario: