Lektoři z firmy: NICOM, a.s.
Předpokládané znalosti
Znalost dotazovacího jazyka T-SQL
Znalost základních konceptů relačních databází
#
Originální literatura Microsoft v anglickém jazyce v ceně kurzu
Module 1: Introduction to Database
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services
Module 2: Designing and Implementing
Designing Tables
Working with Schemas
Creating and Altering Tables
Module 3: Ensuring Data Integrity through
Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity
Module 4: Introduction to Indexing
Core Indexing Concepts
Single Column and Composite Indexes
SQL Server Table Structures
Working with Clustered Indexes
Module 5: Advanced Indexing
Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans
Designing Effective Nonclustered Indexes
Performance Monitoring
Module 6: Columnstore Indexes
Columnstore Indexes
Best Practices for Columnstore Indexes
Module 7: Designing and Implementing Views
Introduction to Views
Creating and Managing Views
Module 8: Designing and Implementing Stored
Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Module 9: 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 10: Responding to Data Manipulation via Triggers
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Module 11: Using In-Memory Tables
Memory-Optimized Tables
Native Stored Procedures
Module 12: Implementing Managed Code in SQL Server
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Module 13: 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
Shredding XML
Module 14: Working with SQL Server Spatial
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications