Beskrivelse
Lær at udvikle dataløsninger mod en SQL Server database. Kurset fokuserer på at oprette, designe og implementere tabeller og indexes. Desuden lærer du at udvikle stored procedures, views og funktioner samt arbejdet med specielle typer af data som fx. XML.
Deltagerprofil
Kurset er for dig, der udvikler databaseløsninger mod en SQL Database.
Du forventes at have praktisk kendskab til Transact-SQL og relationelle databaser og evt. lidt erfaring med databasedesign eller viden svarende til kurset Querying Data with Transact-SQL [20761].
Indhold
Module 1: Introduction to Database Development
Introduction to the SQL Server Platform
SQL Server Database Development Tasks
Module 2: Designing and Implementing Tables
Designing Tables
Data Types
Working with Schemas
Creating and Altering Tables
Module 3: Advanced Table Designs
Partitioning data
Compressing Data
Temporal Tables
Module 4: Ensuring Data Integrity through Constraints
Enforcing data Integrity
Implementing Domain Integrity
Implementing Entity ...%%%
... and Referential Integrity
Module 5: Introduction to Indexes
Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes
Module 6: Designing Optimized Index Strategies
Covering Indexes
Managing Indexes
Execution Plans
Using the DTE
Module 7: Columnstore Indexes
Introduction to Columnstore indexes
Creating Columnstore indexes
Working Columnstore indexes
Module 8: Designing and Implementing Views
Introduction to views
Creating and managing views
Performance considerations for views
Module 9: Designing and Implementing Stored Procedures
Introduction to Stored Procedures
Working with Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Module 10: Designing and Implementing User-Defined Functions
Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table-Valued Functions
Implementation Considerations for Functions
Alternatives to Functions
Module 11: Responding to Data Manipulation via Triggers
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Module 12: Using In-Memory Tables
In-Memory tables
Native Stored Procedures
Module 13: Implementing Managed Code in SQL Server
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Module 14: Storing and Querying XML Data in SQL Server
Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type
Using the T-SQL FOR XML Statement
Getting Started with xQuery
Module 15: Working with SQL Server Spatial Data
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Module 16: Storing and Querying Blobs and Text Documents in SQL Server
Considerations for BLOB Data
Working with FileStream
Using Full-Text Search
Microsoft Software Assurance Vouchere. Kurset kan betales med 5 SA Vouchere.
Undervisere Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.
Deltagerprofil Kurset er for dig, der udvikler databaseløsninger mod en SQL Database.
Du forventes at have praktisk kendskab til Transact-SQL og relationelle databaser og evt. lidt erfaring med databasedesign eller viden svarende til kurset Querying Data with Transact-SQL [20761].
Lær at udvikle dataløsninger mod en SQL Server database. Kurset fokuserer på at oprette, designe og implementere tabeller og indexes. Desuden lærer du at udvikle stored procedures, views og funktioner samt arbejdet med specielle typer af data som fx. XML.
Microsoft Software Assurance Vouchere Kurset kan betales med 5 SA Vouchere.
Indhold Module 1: Introduction to Database Development
Introduction to the SQL Server Platform
SQL Server Database Development Tasks
Module 2: Designing and Implementing Tables
Designing Tables
Data Types
Working with Schemas
Creating and Altering Tables
Module 3: Advanced Table Designs
Partitioning data
Compressing Data
Temporal Tables
Module 4: Ensuring Data Integrity through Constraints
Enforcing data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity
Module 5: Introduction to Indexes
Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes
Module 6: Designing Optimized Index Strategies
Covering Indexes
Managing Indexes
Execution Plans
Using the DTE
Module 7: Columnstore Indexes
Introduction to Columnstore indexes
Creating Columnstore indexes
Working Columnstore indexes
Module 8: Designing and Implementing Views
Introduction to views
Creating and managing views
Performance considerations for views
Module 9: Designing and Implementing Stored Procedures
Introduction to Stored Procedures
Working with Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Module 10: Designing and Implementing User-Defined Functions
Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table-Valued Functions
Implementation Considerations for Functions
Alternatives to Functions
Module 11: Responding to Data Manipulation via Triggers
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Module 12: Using In-Memory Tables
In-Memory tables
Native Stored Procedures
Module 13: Implementing Managed Code in SQL Server
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Module 14: Storing and Querying XML Data in SQL Server
Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type
Using the T-SQL FOR XML Statement
Getting Started with xQuery
Module 15: Working with SQL Server Spatial Data
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Module 16: Storing and Querying Blobs and Text Documents in SQL Server
Considerations for BLOB Data
Working with FileStream
Using Full-Text Search
