office@promanagement.ro

0721.391.236

021.317.09.29

logologologo
  • Trainings
    • Online Training
    • Microsoft
      • Server
        • Windows Server
        • Exchange Server
        • Skype for Business
        • SharePoint
        • Virtualization
        • System Center
        • Cloud
      • Desktop
        • Windows
      • Applications
        • Microsoft 365
        • Office 365
        • Dynamics 365
      • SQL Server Database
      • Developer
        • Visual Studio
        • Azure
      • Power BI
    • Microsoft Office
      • Access
      • Excel
      • Word
      • PowerPoint
      • Outlook
      • Project
    • Cursuri IT
      • Design
      • Oracle
      • Databases
      • Programming
        • C
        • C#
        • HTML 5
        • Java
        • PHP
        • Python
    • Personal Development
    • Marketing and Sales
    • ANC Authorized Courses
  • Courses Calendar
  • Courses Catalog
  • Certifications
    • Kryterion Certifications
    • Pearson Vue
    • Microsoft Azure Certifications
    • Microsoft Office Certifications
    • Microsoft Dynamics Certifications
    • Microsoft Server Certifications
    • SQL Server Certifications
    • Microsoft Visual Studio Certifications
    • Windows Certifications
  • Services
    • Corporate courses
    • Consulting
    • Software Assurance
    • Test Evaluation Platform
  • About us
    • Company Profile
    • Team
    • Pro Management Qualifications
    • Partners
    • Portfolio
    • Testimonials and recommendations
    • Careers
    • Galerie foto
  • Contact
  • English
    • Română
    • English
logologologo
  • Trainings
    • Online Training
    • Microsoft
      • Server
        • Windows Server
        • Exchange Server
        • Skype for Business
        • SharePoint
        • Virtualization
        • System Center
        • Cloud
      • Desktop
        • Windows
      • Applications
        • Microsoft 365
        • Office 365
        • Dynamics 365
      • SQL Server Database
      • Developer
        • Visual Studio
        • Azure
      • Power BI
    • Microsoft Office
      • Access
      • Excel
      • Word
      • PowerPoint
      • Outlook
      • Project
    • Cursuri IT
      • Design
      • Oracle
      • Databases
      • Programming
        • C
        • C#
        • HTML 5
        • Java
        • PHP
        • Python
    • Personal Development
    • Marketing and Sales
    • ANC Authorized Courses
  • Courses Calendar
  • Courses Catalog
  • Certifications
    • Kryterion Certifications
    • Pearson Vue
    • Microsoft Azure Certifications
    • Microsoft Office Certifications
    • Microsoft Dynamics Certifications
    • Microsoft Server Certifications
    • SQL Server Certifications
    • Microsoft Visual Studio Certifications
    • Windows Certifications
  • Services
    • Corporate courses
    • Consulting
    • Software Assurance
    • Test Evaluation Platform
  • About us
    • Company Profile
    • Team
    • Pro Management Qualifications
    • Partners
    • Portfolio
    • Testimonials and recommendations
    • Careers
    • Galerie foto
  • Contact
  • English
    • Română
    • English
  • Trainings
    • Online Training
    • Microsoft
      • Server
        • Windows Server
        • Exchange Server
        • Skype for Business
        • SharePoint
        • Virtualization
        • System Center
        • Cloud
      • Desktop
        • Windows
      • Applications
        • Microsoft 365
        • Office 365
        • Dynamics 365
      • SQL Server Database
      • Developer
        • Visual Studio
        • Azure
      • Power BI
    • Microsoft Office
      • Access
      • Excel
      • Word
      • PowerPoint
      • Outlook
      • Project
    • Cursuri IT
      • Design
      • Oracle
      • Databases
      • Programming
        • C
        • C#
        • HTML 5
        • Java
        • PHP
        • Python
    • Personal Development
    • Marketing and Sales
    • ANC Authorized Courses
  • Courses Calendar
  • Courses Catalog
  • Certifications
    • Kryterion Certifications
    • Pearson Vue
    • Microsoft Azure Certifications
    • Microsoft Office Certifications
    • Microsoft Dynamics Certifications
    • Microsoft Server Certifications
    • SQL Server Certifications
    • Microsoft Visual Studio Certifications
    • Windows Certifications
  • Services
    • Corporate courses
    • Consulting
    • Software Assurance
    • Test Evaluation Platform
  • About us
    • Company Profile
    • Team
    • Pro Management Qualifications
    • Partners
    • Portfolio
    • Testimonials and recommendations
    • Careers
    • Galerie foto
  • Contact
  • English
    • Română
    • English
full-sql

MOC 20762 Course: Developing SQL Databases 2016

750 € +VAT
Databases, IT courses, Microsoft, Microsoft SQL Server, Online Courses
Organized on request Days: 5
8 Hours/Day Online
9:00 - 17:00
  • Overview
  • Curriculum
  • Sign Up
This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Audience profilee:

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 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 database.

At course completion:

After completing this course, 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 Text Documents.

Prior required knowledge

Basic knowledge of the Microsoft Windows operating system and its core functionality.

  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.

Price includes:

Microsoft official course support in electronic format,  internationally recognized Microsoft diploma.

Diploma sample:

  • Module 1: Introduction to Database Development
    No items in this section
  • Module 2: Designing and Implementing Tables
    No items in this section
  • Module 3: Advanced Table Designs
    No items in this section
  • Module 4: Ensuring Data Integrity through Constraints
    No items in this section
  • Module 5: Introduction to Indexes
    No items in this section
  • Module 6: Designing Optimized Index Strategies
    No items in this section
  • Module 7: Columnstore Indexes
    No items in this section
  • Module 8: Designing and Implementing Views
    No items in this section
  • Module 9: Designing and Implementing Stored Procedures
    No items in this section
  • Module 10: Designing and Implementing User-Defined Functions
    No items in this section
  • Module 11: Responding to Data Manipulation via Triggers
    No items in this section
  • Module 12: Using In-Memory Tables
    No items in this section
  • Module 13: Implementing Managed Code in SQL Server
    No items in this section

Sign Up for this Course

If you would like to register more people with the same billing information or benefit from the group discount, please contact us by email at office@promanagement.ro

Contact

Address: Bld. Nicolae Caramfil, nr 53, etaj 5, sect 1
Schedule: 09:00 -17:00
Email: office@promanagement.ro
Mobil: 0721.391.236
Office: 021.317.09.29

About Us

  • Company Profile
  • Portfolio
  • Privacy Policy With Regard to the Processing of Personal Data
  • Galery

Services

  • Consulting
  • Certifications
  • Lecture room rental
  • Corporate courses

Useful links

  • Courses Calendar
  • Pro Management Qualifications
  • Portfolio
   

Pro Management – 25 de ani de experiență pe piața de servicii de instruire

Oferim, tuturor companiilor care doresc să își pregătească angajații, programe de training personalizate. Se acordă discount de volum. Dacă doriți să beneficiați de oferta noastră de training personalizat, vă invităm să ne transmiteți solicitarea dvs. la office@promanagement.ro

Acest site utilizează cookie-uri

Acest site foloseste cookie-uri pentru a furniza vizitatorilor o experienta mai buna de navigare si informatii adaptate nevoilor si interesului fiecaruia. Citeste mai mult…