Developing SQL Databases, Part 2

Du bör behärska grundläggande databasutveckling med SQL Server 2012 eller senare. Till detta rekommenderar vi vår kurs SQL Server 2016 - Developing part 1.

För att alltid hålla en hög kvalitet på våra teknikkurser använder vi både engelsk- och svensktalande experter som kursledare.

Kursen baseras på kurs 20762 ut Microsofts officiella kursprogram. Dessa är de moduler som tas upp i denna del:

Module 3: Advanced Table Designs

Designing a physical database implementation includes planning the filegroups, how to use partitioning to manage large tables, and using compression to improve storage and performance. Temporal tables are a new feature in SQL Server and offer a straightforward solution to collecting changes to your data..

• Partitioning data
• Compressing Data
• Temporal Tables

Module 7: Columnstore Indexes

This module highlights the benefits of using columnstore indexes on large datasets and the considerations needed to use columnstore indexes effectively in your solutions.

• Introduction to Columnstore indexes
• Creating Columnstore indexes
• Working Columnstore indexes

Module 12: Using In-Memory Tables

Memory-optimized tables are primarily stored in memory, which provides the improved performance by reducing hard disk access. Natively compiled stored procedures further improve performance over traditional interpreted Transact-SQL. This module covers the creation of in-memory tables and native stored procedures.

• In-Memory tables
• Native Stored Procedures

Module 14: Storing and Querying XML Data in SQL Server

This module covers the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML 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: Storing and Querying Spatial Data in SQL Server

This module describes spatial data and how this data can be implemented within SQL Server.

• 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

Traditionally, databases have been used to store information in the form of simple values—such as integers, dates, and strings—that contrast with more complex data formats, such as documents, spreadsheets, image files, and video files. As the systems that databases support have become more complex, administrators have found it necessary to integrate this more complex file data with the structured data in database tables. SQL Server provides several ways to integrate these files—that are often known as Binary Large Objects (BLOBs)—and enable their content to be indexed and included in search results. In this module, you will learn how to design and optimize a database that includes BLOBs.

• Considerations for BLOB Data
• Working with FileStream
• Using Full-Text Search

Module 18: Performance and Monitoring

This module looks at how to measure and monitor the performance of your SQL Server databases.

• Extended Events
• Live Query Statistics
• Optimize Database File Configuration
• Metrics