MOC 20464 - Developing Microsoft SQL Server Databases

Module 1: Introduction to Database DevelopmentIntroduction to the SQL Server PlatformWorking with SQL Server ToolsConfiguring SQL Server ServicesLab : Introduction to Database DevelopmentStart SQL Server Management StudioModule 2: Designing and Implementing TablesDesigning TablesWorking with SchemasCreating and Altering TablesLab : Designing and Implementing TablesImproving the Design of TablesCreating a SchemaCreating the TablesModule 3: Ensuring Data Integrity through ConstraintsEnforcing Data IntegrityImplementing Domain IntegrityImplementing Entity and Referential IntegrityLab : Ensuring Data Integrity through ConstraintsDesigning ConstraintsTesting the constraintsModule 4: Introduction to IndexingCore Indexing ConceptsSingle Column and Composite IndexesSQL Server Table StructuresWorking with Clustered IndexesLab : Creating IndexesCreating Tables with Clustered IndexesImproving Performance through Nonclustered IndexesModule 5: Advanced IndexingExecution Plan Core ConceptsCommon Execution Plan ElementsWorking with Execution PlansDesigning Effective Nonclustered IndexesPerformance MonitoringLab : Planning for SQL Server 2014 IndexingExploring Existing Index StatisticsCreating Covering IndexesModule 6: Columnstore IndexesColumnstore IndexesBest Practices for Columnstore IndexesLab : Using In-Memory Database CapabilitiesCreating Columnstore IndexesModule 7: Designing and Implementing ViewsIntroduction to ViewsCreating and Managing ViewsPerformance Considerations for ViewsLab : Designing and Implementing ViewsDesigning, Implementing and Testing the WebStock ViewsDesigning and Implementing the Contacts ViewModifying the AvailableModels ViewModule 8: Designing and Implementing Stored ProceduresIntroduction to Stored ProceduresWorking With Stored ProceduresImplementing Parameterized Stored ProceduresControlling Execution ContextLab : Designing and Implementing Stored ProceduresCreating stored proceduresCreating a parameterized stored procedureAltering the execution context of stored proceduresModule 9: Designing and Implementing User-Defined FunctionsOverview of FunctionsDesigning and Implementing Scalar FunctionsDesigning and Implementing Table-Valued FunctionsImplementation Considerations for FunctionsAlternatives to FunctionsLab : Designing and Implementing User-Defined FunctionsFormatting Phone NumbersModifying an Existing FunctionResolving a Function-Related Performance IssueModule 10: Responding to Data Manipulation via TriggersDesigning DML TriggersImplementing DML TriggersAdvanced Trigger ConceptsLab : Responding to Data Manipulation via TriggersCreating and Testing the Audit TriggerImproving the Audit TriggerModule 11: Using In-Memory TablesMemory-Optimized TablesNative Stored ProceduresLab : Using In-Memory Database CapabilitiesWorking with Memory Optimized TablesWorking with Natively Compiled Stored ProceduresModule 12: Implementing Managed Code in SQL ServerIntroduction to SQL CLR IntegrationImporting and Configuring AssembliesImplementing SQL CLR IntegrationLab : Implementing Managed Code in SQL ServerAssessing Proposed CLR CodeImplementing a CLR AssemblyImplementing a CLR User-defined Aggregate and CLR User-defined Data TypeModule 13: Storing and Querying XML Data in SQL ServerIntroduction to XML and XML SchemasStoring XML Data and Schemas in SQL ServerImplementing the XML Data TypeUsing the T-SQL FOR XML StatementGetting Started with XQueryShredding XMLLab : Storing and Querying XML Data in SQL ServerAssessing appropriate Use of XML Data in SQL ServerTesting XML Data Storage in VariablesRetrieving Information about XML Schema CollectionsQuerying SQL Server Data as XMLWrite a Stored Procedure Returning XMLModule 14: Working with SQL Server Spatial DataIntroduction to Spatial DataWorking with SQL Server Spatial Data TypesUsing Spatial Data in ApplicationsLab : Working with SQL Server Spatial DataQuerying the Geometry Data TypeAdding Spatial Data to an Existing Table