M20762 Developing SQL Databases - Seminar / Kurs von brainymotion AG

Inhalte

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

Lernziele

1 - Introduction to Database DevelopmentIntroduction to the SQL Server PlatformSQL Server Database Development Tasks2 - Designing and Implementing TablesDesigning TablesData TypesWorking with SchemasCreating and Altering Tables3 - Advanced Table DesignsPartitioning dataCompressing DataTemporal Tables4 - Ensuring Data Integrity through ConstraintsEnforcing data IntegrityImplementing Domain IntegrityImplementing Entity and Referential Integrity5 - Introduction to IndexesCore Indexing ConceptsData Types and IndexesSingle Column and Composite Indexes6 - Designing Optimized Index StrategiesCovering IndexesManaging IndexesExecution PlansUsing the DTE7 - Columnstore IndexesIntroduction to Columnstore indexesCreating Columnstore indexesWorking Columnstore indexes8 - Designing and Implementing ViewsIntroduction to viewsCreating and managing viewsPerformance considerations for views9 - Designing and Implementing Stored ProceduresIntroduction to Stored ProceduresWorking with Stored ProceduresImplementing Parameterized Stored ProceduresControlling Execution Context10 - Designing and Implementing User-Defined FunctionsOverview of FunctionsDesigning and Implementing Scalar FunctionsDesigning and Implementing Table-Valued FunctionsImplementation Considerations for FunctionsAlternatives to Functions11 - Responding to Data Manipulation via TriggersDesigning DML TriggersImplementing DML TriggersAdvanced Trigger Concepts12 - Using In-Memory TablesIn-Memory tablesNative Stored Procedures13 - Implementing Managed Code in SQL ServerIntroduction to SQL CLR IntegrationImporting and Configuring AssembliesImplementing SQL CLR Integration14 - 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 xQuery15 - Working with SQL Server Spatial DataIntroduction to Spatial DataWorking with SQL Server Spatial Data TypesUsing Spatial Data in Applications16 - Storing and Querying Blobs and Text Documents in SQL ServerConsiderations for BLOB DataWorking with FileStreamUsing Full-Text Search

SG-Seminar-Nr.: 5150572

Anbieter-Seminar-Nr.: 855707764

Preis jetzt anfragen

Seminar merken ›

Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service