academy-it-microsoft-office-vendor-training
  • academy-it-microsoft-office-vendor-training

55352A – Introduction to SQL Databases

$2,460.00

About this course

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Course Outline

 

Clear
SKU: 55352A Categories: , , , , , Tag:

Description

Audience Profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

At Course Completion

After completing this course, students will be able to:

  • Describe key database concepts in the context of SQL Server
  • Describe database languages used in SQL Server
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance

Prerequisites

This is a foundation level course and therefore only requires general computer literacy. Experience working from a command prompt.

Course Outline

 

Related products

  • academy-it-microsoft-office-vendor-training
    AZ-500T00 – Microsoft Azure Security Technologies
    $3,280.00

    About this course

    This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    10969B – Active Directory Services with Windows Server
    $4,100.00

    About this course

    Get Hands on instruction and practice administering Active Directory technologies in Windows Server 2012 and Windows Server 2012 R2 in this 5-day Microsoft Official Course. You will learn the skills you need to better manage and protect data access and information, simplify deployment and management of your identity infrastructure, and provide more secure access to data. You will learn how to configure some of the key features in Active Directory such as Active Directory Domain Services (AD DS), Group Policy, Dynamic Access Control (DAC), Work Folders, Work Place Join, Certificate Services, Rights Management Services (RMS), Federation Services, as well as integrating your on premise environment with cloud based technologies such as Windows Azure Active Directory. As part of the learning experience, you will perform hands-on exercises in a virtual lab environment.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    WS-013T00A – Azure Stack HCI
    $2,460.00

    About this course

    This three-day course is intended primarily for IT Professionals who already have significant experience with managing an on-premises Windows Server environment. Its purpose is to cover advanced topics related to Windows Server software-defined datacenter, Azure Stack HCI, and other Azure Stack products. The course also describes the use of existing Microsoft System Center products to implement and manage software-defined datacenters with Windows Server 2019. This course is advanced and is designed for people that want to run their virtual workloads on Windows Server 2019 at medium-to-large scale using software-defined datacenter and hyper-converged principles.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    DP-100T01 – Designing and Implementing a Data Science Solution on Azure
    $3,280.00

    About this course

    Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow.

    Course Outline

     

    Select options