MOC 10774 - Querying Microsoft SQL Server 2012

Vecomp Software - PCSNET Nordest
A Villafranca di Verona
  • Vecomp Software - PCSNET Nordest

1.700 
+IVA
Vuoi parlare del corso con un consulente?

Informazione importanti

  • Corso
  • Villafranca di verona
  • 35 ore di lezione
  • Durata:
    5 Giorni
  • Quando:
    Da definire
Descrizione

Obiettivi:
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

Informazione importanti
Sedi

Dove e quando

Inizio Luogo Orario
Da definire
Villafranca di Verona
37069, Verona, Italia
Visualizza mappa
09,00 - 13,00; 14,00 - 17,00

Cosa impari in questo corso?

Querying Microsoft
SQL SERVER 2012
Windows
Wireless
PC
Informatica
Account synchronizing
Panel using
Network
Configuring

Professori

Francesco Pandiscia
Francesco Pandiscia
MCT - MCITpro Enterprise Server Administrator

Programma

Module 1: Introduction to Microsoft SQL Server 2012SQL Server Denali ArchitectureWorking with SQL Server Denali ToolsWorking with SQL Server DatabasesLab : Working with SQL Server Denali Tools (Azure enabled)Working with SQL Server Management StudioExploring with Database ObjectsOrganizing and Creating T-SQL ScriptsUsing Books OnlineModule 2: Introduction to Transact-SQL QueryingIntroducing Transact-SQLUnderstanding SetsUnderstanding Predicate LogicUnderstanding the Logical Order of Operations in SELECT StatementsLab : Introduction to Transact-SQL QueryingExecuting Basic SELECT StatementsExecuting queries which filter data using predicatesExecuting queries which sort data using ORDER BYModule 3: Writing SELECT QueriesWriting Simple SELECT StatementsEliminating Duplicates with DISTINCTUsing Column and Table Aliaseswriting Simple CASE ExpressionsLab : Writing Basic SELECT statementsWrite simple SELECT statementsEliminate Duplicates using DISTINCTUse table and column aliasesUse a simple CASE expressionModule 4: Querying Multiple TablesUnderstanding JoinsQuerying With Inner JoinsQuerying With Outer JoinsQuerying Using Self and Cross JoinsLab : Querying Multiple TablesWrite queries using inner joinsWrite queries using multi-table joinsWrite queries using self joinsWrite queries using outer joinsModule 5: Sorting and Filtering DataSorting DataFiltering DataFiltering with the TOP and OFFSET-FETCH OptionsWorking with Unknown ValuesLab : Filtering and Sorting DataWrite queries that filter data using a WHERE clauseWrite queries that sort data with the ORDER BY clauseWrite queries that filter data using the TOP optionWrite queries that filter data using the OFFSET-FETCH clauseModule 6: Working with SQL Server Denali Data TypesIntroducing SQL Server Denali Data TypesWorking with Character DataWorking with Date and Time DataLab : Working with SQL Server 2012 Data TypesWrite queries which return date and time dataWrite queries which use date and time functionsWrite queries which return character dataWrite queries which use character functionsModule 7: Using Built-In FunctionsWriting Queries with Built-In FunctionsUsing Conversion FunctionsUsing Logical FunctionsUsing Functions to Test for NullabilityLab : Using Built-In FunctionsWrite queries which use conversion functionsWrite queries which use logical functionsWrite queries which test for nullabilityModule 8: Grouping and Aggregating DataUsing Aggregate FunctionsUsing the GROUP BY ClauseFiltering Groups with the HAVING ClauseLab : Grouping and Aggregating DataWrite queries which use the GROUP BY clauseWrite queries which use aggregate functionsWrite queries which use distinct aggregate functionsWrite queries which filter groups with the HAVING clauseModule 9: Using SubqueriesWriting Self-Contained SubqueriesWriting Correlated SubqueriesUsing the EXISTS Predicate with SubqueriesLab : Using SubqueriesWrite queries which use self-contained subqueriesWrite queries which use correlated subqueriesWrite queries which use scalar and multi-result subqueriesWrite queries which use the IN and EXISTS predicatesModule 10: Using Table ExpressionsViewsTable ExpressionsLab : Using Table ExpressionsWrite queries which use viewsWrite queries which use derived tablesWrite queries which use common table expressionsWrite queries which use inline table-valued expressionsModule 11: Use Set OperatorsLab : Use Set OperatorsWrite queries which use UNION set operators and UNION ALL multi-set operatorsWrite queries which use CROSS APPLY and OUTER APPLY operatorsWrite queries which use APPLY with derived tables and functionsWrite queries which use EXCEPT and INTERSECT operatorsModule 12: Using Window Ranking, Offset and Aggregate FunctionsLab : Using Window Ranking, Offset and Aggregate FunctionsWrite queries which use ranking functionsWrite queries which use offset functionsWrite queries which use window aggregate functionsModule 13: Pivoting and Grouping SetsLab : Pivoting and Grouping SetsWrite queries which use the PIVOT operatorWrite queries which use the GROUPING SETS subclauseWrite queries which use GROUP BY ROLLUPWrite queries which use GROUP BY CUBEModule 14: Querying SQL Server MetadataLab : Querying SQL Server MetadataQuerying system catalog viewsQuerying system functionsQuerying system dynamic management viewsModule 15: Executing Stored ProceduresLab : Executing Stored ProceduresUse the EXECUTE statement to invoke stored proceduresPass parameters to stored proceduresReturn results from a stored procedure using the OUTPUT clauseExecute system stored proceduresModule 16: Programming with T-SQLLab : Programming with T-SQLDeclaring variables and delimiting batchesUsing control of flow elementsGenerating dynamic SQLUsing synonymsModule 17: Implementing Error HandlingLab : Implementing Error HandlingRedirecting errors with TRY/CATCHCreating error handling routines in a CATCH block with ERROR functionsUsing THROW to pass an error message back to a clientModule 18: Implementing TransactionsLab : Implementing TransactionsControlling transactions with BEGIN and COMMITUsing XACT_ABORTAdding transaction handling logic to a CATCH blockModule 19: Improving Query PerformanceLab : Improving Query PerformanceViewing query execution plansUsing SET STATISTICS statementsViewing index usageComparing cursors to set-based queries