Corso attualmente non disponibile

Querying Microsoft SQL Server 2014

Corso

Online

1.720 € +IVA

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Descrizione

  • Tipologia

    Corso

  • Metodologia

    Online

Scrivere query SELECT
Interrogare più tabelle
Ordinare e filtrare i dati
Descrivere l'utilizzo di tipi di dati in SQL Server
Modificare i dati utilizzando Transact-SQL
Utilizzare le funzioni incorporate in SQL Server
Utilizzare i raggruppamenti di dati le relative aggregazioni
Utilizzare sottoquery
Utilizzare espressioni di tabella
Utilizzare gli operatori fissi
Utilizzare la ranking window, l'offset e le funzioni di aggregazione
Implementare il pivoting e gli insiemi di raggruppamento
Eseguire stored procedure
Programmare con T-SQL
Implementare la gestione degli errori
Implementare le transazioni

Profilo del corso

Sviluppatore

Questo corso richiede che siano soddisfatti i seguenti prerequisiti:Conoscenza operativa di database relazionali.Conoscenza di base del sistema operativo Microsoft Windows e sue funzionalità di base.

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Successi del Centro

2023
2022
2021
2020
2019
2018

Tutti i corsi devono essere aggiornati

La media delle valutazioni dev'essere superiore a 3,7

Più di 50 opinioni degli ultimi 12 mesi

6 anni del centro in Emagister.

Materie

  • SQL
  • Microsoft SQL Server
  • Didattica informatica
  • Information tecnology
  • Server
  • Transact-SQL
  • SQL Server 2014
  • Tools
  • DML
  • Server Management Studio
  • Querying Multiple Tables
  • T-SQL scripts
  • Filtering Data

Programma

CONTENUTI:

Module 1: Introduction to Microsoft SQL Server 2014

The Basic Architecture of SQL Server

SQL Server Editions and Versions

Getting Started with SQL Server Management Studio

Lab : Working with SQL Server 2014 Tools

Working with SQL Server Management Studio

Creating and Organizing T-SQL scripts

Using Books Online

Module 2: Introduction to T-SQL Querying

Introducing T-SQL

Understanding Sets

Understanding Predicate Logic

Understanding the Logical Order of Operations in SELECT statements

Lab : Introduction to Transact-SQL Querying

Executing Basic SELECT Statements

Executing queries which filter data using predicates

Executing queries which sort data using ORDER BY

Module 3: Writing SELECT Queries

Writing Simple SELECT Statements

Eliminating Duplicates with DISTINCT

Using Column and Table Aliases

Writing Simple CASE Expressions

Lab : Writing Basic SELECT Statements

Write simple SELECT Statements

Eliminate Duplicates Using Distinct

Use Table and Column Aliases

Use a Simple CASE Expression

Module 4: Querying Multiple Tables

Understanding Joins

Querying with Inner Joins

Querying with Outer Joins

Querying with Cross Joins and Self Joins

Lab : Querying Multiple Tables

Writing Queries That Use Inner Joins

Writing Queries That Use Multiple-Table Inner Join

Writing Queries That Use Self Joins

Writing Queries That Use Outer Joins

Writing Queries That Use Cross Joins

Module 5: Sorting and Filtering Data

Sorting Data

Filtering Data with a WHERE Clause

Filtering with the TOP and OFFSET-FETCH Options

Working with Unknown and Missing Values

Lab : Sorting and Filtering Data

Writing Queries That Filter Data Using a WHERE Clause

Writing Queries That Filter Data Using an ORDER BY Clause

Writing Queries That Filter Data Using the TOP Option

Writing Queries That Filter Data Using the OFFSET-FETCH Clause

Module 6: Working with SQL Server 2014 Data Types

Introducing SQL Server 2014 Data Types

Working with Character Data

Working with Date and Time Data

Lab : Working with SQL Server 2014 Data Types

Writing Queries That Return Date and Time Data

Writing Queries That Use Date and Time Functions

Writing Queries That Return Character Data

Writing Queries That Use Character Functions

Module 7: Using DML to Modify Data

Inserting Data

Modifying and Deleting Data

Lab : Using DML to Modify Data

Inserting Data

Updating 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

Lab : Using Built-In Functions

Write queries which use conversion functions

Write queries which use logical functions

Write queries which test for nullability

Module 9: Grouping and Aggregating Data

Using Aggregate Functions

Using the GROUP BY Clause

Filtering Groups with HAVING

Lab : Grouping and Aggregating Data

Write queries which use the GROUP BY clause

Write queries which use aggregate functions

Write queries which use distinct aggregate functions

Write queries which filter groups with the HAVING clause

Module 10: Using Subqueries

Writing Self-Contained Subqueries

Writing Correlated Subqueries

Using the EXISTS Predicate with Subqueries

Lab : Using Subqueries

Write queries which use self-contained subqueries

Write queries which use scalar and multi-result subqueries

Write queries which use correlated subqueries and EXISTS predicate

Module 11: Using Table Expressions

Using Derived Tables

Using Common Table Expressions

Using Views

Using Inline Table-Valued Functions

Lab : Using Table Expressions

Write Queries Which Use Views

Write Queries Which Use Derived Tables

Write Queries Which Use Common Table Expressions

Write Queries Which Use Inline Table-Valued Functions

Module 12: Using Set Operators

Writing Queries with the UNION Operator

Using EXCEPT and INTERSECT

Using APPLY

Lab : Using Set Operators

Write queries which use UNION set operators and UNION ALL multi-set operators

Write queries which use CROSS APPLY and OUTER APPLY operators

Write queries which use EXCEPT and INTERSECT operators

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

Creating Windows with OVER

Exploring Window Functions

Lab : Using Window Ranking, Offset and Aggregate Functions

Write queries which use ranking functions

Write queries which use offset functions

Write queries which use window aggregate functions

Module 14: Pivoting and Grouping Sets

Writing Queries with PIVOT and UNPIVOT

Working with Grouping Sets

Lab : Pivoting and Grouping Sets

Write queries which use the PIVOT operator

Write queries which use the UNPIVOT operator

Write queries which use the GROUPING SETS subclause

Module 15: Executing Stored Procedures

Querying Data with Stored Procedures

Passing Parameters to Stored Procedures

Creating Simple Stored Procedures

Working with Dynamic SQL

Lab : Executing Stored Procedures

Use the EXECUTE statement to invoke stored procedures

Pass parameters to stored procedures

Execute system stored procedures

Module 16: Programming with T-SQL

T-SQL Programming Elements

Controlling Program Flow

Lab : Programming with T-SQL

Declaring Variables and Delimiting Batches

Using Control-of-Flow Elements

Generating Dynamic SQL

Using Synonyms

Module 17: Implementing Error Handling

Using TRY / CATCH Blocks

Working with Error Information

Lab : Implementing Error Handling

Redirecting Errors with TRY / CATCH

Using THROW to Pass an Error Message Back to a Client

Module 18: Implementing Transactions

Transactions and the Database Engine

Controlling Transactions

Isolation Levels

Lab : Implementing Transactions

Controlling transactions with BEGIN, COMMIT, and ROLLBACK

Adding error handling to a CATCH block

Ulteriori informazioni

INFO Esame: 70-461 - Querying Microsoft SQL Server 2012 Manuale: Il Materiale Didattico Ufficiale per tutti i corsi Microsoft MOC può essere richiesto, se disponibile, in forma elettronica (DMOC) invece che cartacea e lo studente iscritto potrà scaricarlo dal sito Microsoft. Chi acquista un DMOC ha diritto a consultare tutte le versioni del manuale, sia quelle precedenti a quella che acquista sia quelle che usciranno successivamente, dove troverà corretti eventuali errori e/o le novità del prodotto. Prezzo manuale: 250 € incluso nel prezzo del corso Natura del corso: Operativo (previsti lab su PC)

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Querying Microsoft SQL Server 2014

1.720 € +IVA