SQL Server 200x Corso,
Writing Queries Using Transact-SQL
Microsoft SQL Server 2008 è l'ultima versione di RDMS di Microsoft per le aziende. Le funzioni di Business-intelligence implementate consentono l'elaborazione con tecnologie di data warehouse.
Obiettivo
Dopo il seminario sarete in grado di scrivere query complesse per il recupero e l'analisi di dati e strutture utilizzando Transact-SQL. Inoltre sarete anche in grado di effettuare grandi modifiche dei dati in modo sistematico e inserire oggetti di programmazione per sostenere query più complesse.
Nota
MOC2778,
Dati
| Innsbruck | Bolzano | Salzburg | Dornbirn |
QR |
| 22.10.2012 | | |
|
|
appuntamento garantito
|
Contenuto SQL Server 200x Corso
| Giorno 1 | Giorno 2 | Giorno 3 |
- Getting Started with Databases and Transact-SQL
- – Overview of SQL Server and Databases
- – Overview and Syntax Elements of T-SQL
- – Working with T-SQL Scripts
- – Using T-SQL Querying Tools
- Querying and Filtering Data
- – Using the SELECT Statement, Filtering Data
- – Working with NULL Values
- – Formatting Result Sets
- – Performance Considerations for Writing Queries
- Grouping and Summarizing Data
- – Summarizing Data by Using Aggregate Functions
- – Summarizing Grouped Data
- – Ranking Grouped Data
- – Creating Crosstab Queries
| - Joining Data from Multiple Tables
- – Querying Multiple Tables by Using Joins
- – Applying Joins for Typical Reporting Needs
- – Combining and Limiting Result Set
- Working with Subqueries
- – Writing Basic Subqueries
- – Writing Correlated Subqueries
- – Comparing Subqueries with Joins and Temporary Tables
- – Using Common Table Expressions
- Modifying Data in Tables
- – Inserting Data into Tables
- – Deleting Data from Tables
- – Updating Data in Tables
- – Overview of Transactions
| - Querying Metadata, XML, and Full-Text Indexes
- – Querying Metadata
- – Overview of XML, Querying XML Data
- – Overview of Full-Text Indexes
- – Querying Full-Text Indexes
- Using Programming Objects for Data Retrieval
- – Overview of Views
- – Overview of User-Defined Functions
- – Overview of Stored Procedures
- – Overview of Triggers
- – Writing Distributed Queries
- Using Advanced Querying Techniques
- – Considerations for Querying Data
- – Working with Data Types
- – Cursors and Set-Based Queries
- – Dynamic SQL
- – Maintaining Query Files
|
Indietro