> > > 20464 Detailed outline

Developing Microsoft® SQL Server® Databases (20464)

Course Description Kurs tarihleri Course Outline

Detailed Course Outline

Module 1: Introduction to Database Development

  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Module 2: Designing and Implementing Tables

  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables

Module 3: Ensuring Data Integrity through Constraints

  • 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
  • Performance Considerations for Views

Module 8: Designing and Implementing Stored Procedures

  • Introduction to Stored Procedures
  • Working With Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context

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 Data

  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications

Labs

  • Introduction to Database Development
  • Designing and Implementing Tables
  • Ensuring Data Integrity through Constraints
  • Creating Indexes
  • Planning for SQL Server 2014 Indexing
  • Using In-Memory Database Capabilities
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers
  • Using In-Memory Database Capabilities
  • Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Working with SQL Server Spatial Data
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!