20762: Developing SQL Database (MOC20762)


20762: Developing SQL Database (MOC20762)


20762: Developing SQL Database (MOC20762)

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


After following this course, the students will be able to:

  • Design and Implement Tables
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Views
  • Design and Implement Stored Procedures
  • Design and Implement User Defined Functions
  • Respond to data manipulation using triggers
  • Design and Implement In-Memory Tables
  • Implement Managed Code in SQL Server
  • Store and Query XML Data
  • Work with Spatial Data
  • Store and Query Blobs and Tekst Documents
  • Doelgroep

    This course is designed for IT Professionals who want to becoma skilled on SQL Server 2016 product features and technologies for implementing a database. The other audiences is that de course is for individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.


    To participate in this course the students need to exercise the 20761: Querying Data with Transact-SQL (MOC20761).


    Classical and Tailor iT made training


    During this course the following topics will be covered:

    Module 1: Introductions to Database Development

    Module 2: Designing and Implementing Tables

    Module 3: Advanced Table Designs

    Module 4: Ensuring Data Integrity through Constraints

    Module 5: Introduction to Indexes

    Module 6: Designing Optimized Index Strategies

    Module 7: Columnstore Indexes

    Module 8: Designing and Implementing Views

    Module 9: Designing and Implementing Stored Procedures

    Module 10: Designing and Implementing User-Defined Functions

    Module 11: Responding to Data Manipulations via Triggers

    Module 12: Using In-Memory Tables

    Module 13: Implementing Managed Code in SQL Server

    Module 14: Storing and Querying XML Data in SQL Server

    Module 15: Working with SQL Server Spatial Data

    Module 16: Storing and Querying Blobs and Tekst Documents in SQL Server



    5 days

    € 2.395


    23, 24, 25, 26 en 27 oktober 2017

    27, 28, 29 en 30 november & 1 december 2017

    18, 19, 20, 21 en 22 december 2017

    Andere data?


    Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

    Andere locatie?

    SKU: MOC20762 Categorieën: , , Tag:
    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.