20762 – Developing Microsoft SQL Databases

Temario:

• Introduction to Database Development
• Introduction to the SQL Server Platform
• SQL Server Database Development Tasks
• Working with SQL Server Tools
• Designing Tables
• Using Data Types
• Working with Schemas
• Creating and Altering Tables
• Advanced Table Designs
• Partitioning data
• Compressing Data
• Temporal Tables
• Ensuring Data Integrity through Constraints
• Enforcing Data Integrity
• Implementing Domain Integrity
• Implementing Entity and Referential Integrity
• Introduction to Indexing
• Core Indexing Concepts
• Data Types and Indexes
• Single Column and Composite Indexes
• Designing Optimized Index Strategies
• Covering Indexes
• Managing Indexes
• Execution Plans
• Introduction to Columnstore indexes
• Creating and Working Columnstore indexes
• Introduction to Views
• Creating and Managing Views
• Performance Considerations for Views
• Introduction to Stored Procedures
• Designing and Implementing Stored Procedures
• Implementing Parameterized Stored Procedures
• Controlling Execution Context
• Overview of Functions
• Designing and Implementing Scalar Functions and Table-Valued Functions
• Implementation Considerations for Functions
• Alternatives to Functions
• Responding to Data Manipulation via Triggers
• Designing and Implementing DML Triggers
• Advanced Trigger Concepts
• Using In-Memory Tables
• Native Stored Procedures
• Implementing Managed Code in SQL Server
• Introduction to SQL CLR Integration
• Importing and Configuring Assemblies
• Implementing SQL CLR Integration
• Introduction to XML and XML Schemas
• Storing XML Data and XML Schemas
• Using the T-SQL FOR XML Statement
• Getting Started with XQuery
• Introduction to Spatial Data
• Using Spatial Data in Applications
• Storing and Querying Blobs and Text Documents in SQL Server
• Considerations for BLOB Data
• Working with FileStream
• Using Full-Text Search

más info en: https://ulearn.edu.uy/20762-developing-microsoft-sql-databases/