Developing SQL Databases

Descrizione del corso

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Programma

1. Introduction to Database Development
   • Introduction to the SQL Server Platform
   • SQL Server Database Development Tasks
2. Designing and Implementing
   • Designing Tables
   • Data Types
   • Working with Schemas
   • Creating and Altering Tables
3. Advanced Table Designs
   • Partitioning data
   • Compressing Data
   • Temporal Tables
4. Ensuring Data Integrità through Constraints
   • Enforcing data Integrità
   • Implementing Domain Integrità
   • Implementing Entity and Referential Integrità
5. Introduction to Indexes
   • Core Indexing Concepts
   • Data Types and Indexes
   • Single Column and Composite Indexes
6. Designing Optimized Index Strategies
   • Covering Indexes
   • Managing Indexes
   • Execution Plans
   • Using the DTE
7. Columnstore Indexes
   • Introduction to Columnstore indexes
   • Creating Columnstore indexes
   • Working Columnstore indexes
8. Designing and Implementing Views
   • Introduction to views
   • Creating and managing views
   • Performance considerations for views
9. Designing and Implementing Stored Procedures
   • Introduction to Stored Procedures
   • Working with Stored Procedures
   • Implementing Parameterized Stored Procedures
   • Controlling Execution Context
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
11. Responding to Data Manipulation via Triggers
    • Designing DML Triggers
    • Implementing DML Triggers
    • Advanced Trigger Concepts
12. Using In-Memory Tables
    • In-Memory tables
    • Native Stored Procedures
13. Implementing Managed Code in SQL
    • Introduction to SQL CLR Integration
    • Importing and Configuring Assemblies
    • Implementing SQL CLR Integration
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
15. Working with SQL Server Spatial Data
    • Introduction to Spatial Data
    • Working with SQL Server Spatial Data Types
    • Using Spatial Data in Applications
16. Storing and Querying Blobs and Text Documents in SQL Server
    • Considerations for BLOB Data
    • Working with FileStream
    • Using Full-Text Search