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

 

Reviews

There are no reviews yet.

Be the first to review “55352A – Introduction to SQL Databases”

Your email address will not be published. Required fields are marked *

Related products

  • academy-it-microsoft-office-vendor-training
    20740C – Installation, Storage, and Compute with Windows Server 2016
    $4,100.00

    About this course

    This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    DP-900T00 – Microsoft Azure Data Fundamentals
    $820.00

    About this course

    In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about modern data warehousing, real-time analytics, and data visualization.

    Course Outline

     

     

    Select options
  • academy-it-microsoft-office-vendor-training
    55265A – Microsoft PowerApps
    $1,640.00

    About this course

    This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

    Course Outline

    Select options
  • academy-it-microsoft-office-vendor-training
    AZ-204T00 – Developing solutions for Microsoft Azure
    $4,100.00

    About this course

    This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

    Course Outline

     

    Select options