Developing SQL Databases - MOC20762

51 Bewertung

Beschreibung

This five-day instructor-led 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.

error_outline Wichtige Information

Dieses Seminar behandelt prüfungsrelevante Themen zum Microsoft Examen: 70-762 Developing SQL Databases

expand_more chevron_right Zielgruppe

Dieses Seminar richtet sich an:
  • IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
  • The secondary audiences for this course are:
  • individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

expand_more chevron_right Vorkenntnisse

Für dieses Seminar werden folgende Kenntnisse empfohlen:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.

expand_more chevron_right Detail-Inhalte

  1. Introduction to Database Development
    1. Introduction to the SQL Server Platform
    2. SQL Server Database Development Tasks
  2. Designing and Implementing Tables
    1. Designing Tables
    2. Data Types
    3. Working with Schemas
    4. Creating and Altering Tables
  3. Advanced Table Designs
    1. Partitioning Data
    2. Compressing Data
    3. Temporal Tables
  4. Ensuring Data Integrity through Constraints
    1. Enforcing Data Integrity
    2. Implementing Data Domain Integrity
    3. Implementing Entity and Referential Integrity
  5. Introduction to Indexes
    1. Core Indexing Concepts
    2. Data Types and Indexes
    3. Heaps, Clustered, and Nonclustered Indexes
    4. Single Column and Composite Indexes
  6. Designing Optimized Index Strategies
    1. Index Strategies
    2. Managing Indexes
    3. Execution Plans
    4. The Database Engine Tuning Advisor
    5. Query Store
  7. Columnstore Indexes
    1. Introduction to Columnstore Indexes
    2. Creating Columnstore Indexes
    3. Working with Columnstore Indexes
  8. Designing and Implementing Views
    1. Introduction to Views
    2. Creating and Managing Views
    3. Performance Considerations for Views
  9. Designing and Implementing Stored Procedures
    1. Introduction to Stored Procedures
    2. Working with Stored Procedures
    3. Implementing Parameterized Stored Procedures
    4. Controlling Execution Context
  10. Designing and Implementing User-Defined Functions
    1. Overview of Functions
    2. Designing and Implementing Scalar Functions
    3. Designing and Implementing Table-Valued Functions
    4. Considerations for Implementing Functions
    5. Alternatives to Functions
  11. Responding to Data Manipulation via Triggers
    1. Designing DML Triggers
    2. Implementing DML Triggers
    3. Advanced Trigger Concepts
  12. Using In-Memory Tables
    1. Memory-Optimized Tables
    2. Natively Compiled Stored Procedures
  13. Implementing Managed Code in SQL Server
    1. Introduction to CLR Integration in SQL Server
    2. Implementing and Publishing CLR Assemblies
  14. Storing and Querying XML Data in SQL Server
    1. Introduction to XML and XML Schemas
    2. Storing XML Data and Schemas in SQL Server
    3. Implementing the XML Data Type
    4. Using the Transact-SQL FOR XML Statement
    5. Getting Started with Xquery
    6. Shredding XML
  15. Storing and Querying Spatial Data in SQL Server
    1. Introduction to Spatial Data
    2. Working with SQL Server Spatial Data Types
    3. Using Spatial Data in Applications
  16. Storing and Querying BLOBs and Text Documents in SQL Server
    1. Considerations for BLOB Data
    2. Working with FILESTREAM
    3. Using Full-Text Search
  17. SQL Server Concurrency
    1. Concurrency and Transactions
    2. Locking Internals
  18. Performance and Monitoring
    1. Extended Events
    2. Working with extended Events
    3. Live Query Statistics
    4. Optimize Database File Configuration
    5. Metrics
  • expand_more chevron_right event_available 07.12.-10.12.2020 07.12.2020 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    warning Aufgrund des Feiertags findet dieses Training Mo, Mi-Fr statt
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 25.01.-28.01.2021 25.01.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 08.03.-11.03.2021 08.03.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 19.04.-22.04.2021 19.04.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 31.05.-03.06.2021 31.05.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    warning Aufgrund des Feiertags Mo-Mi und Fr 
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 05.07.-08.07.2021 05.07.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 16.08.-19.08.2021 16.08.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 27.09.-30.09.2021 27.09.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 08.11.-11.11.2021 08.11.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services
  • expand_more chevron_right event_available 20.12.-23.12.2021 20.12.2021 Seminarzeitentimer4 Tage4 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
    • expand_more chevron_right ETC Live - Virtual Classroom 2,465.00
      • Virtual Training – aber live im Seminar
      • Keine Anfahrt ins Seminarzentrum notwendig
      • Seminarunterlagen, Teamwork, Labs 24/7
      • ETC>Live Support und Hotline
      • ETC-Services

       

    • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,465.00
      • Ihr ILT Seminar (Instructor Led Training)
      • Seminarunterlagen, Teamwork, Labs
      • Verpflegung vorort in einem der ETC Seminarzentren
      • Seminar-Services

Ähnliche Seminare

1 Bewertung

  • Bei mir hat alles ge passt. Super Vorträge

    — Stanley O. · 14.02.2019