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

55315A – 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. This course updates and replaces course 10985C previously published under the same title.

Course Outline

 

Clear
SKU: 55315A 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. Developers that deliver content from SQL Server databases will also benefit from this material.

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
  • Describe commonly used database objects

Prerequisites

This is a foundation level course and therefore only requires general computer literacy.

Course Outline

 

Related products

  • academy-it-microsoft-office-vendor-training
    MS-900T01 – Microsoft 365 Fundamentals
    $820.00

    About this course

    This course introduces Microsoft 365, an integrated cloud platform that delivers industry-leading productivity apps along with intelligent cloud services, and world-class security. You’ll learn foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing. You will be introduced to Microsoft 365 and learn how Microsoft 365 solutions improve productivity, facilitate collaboration, and optimize communications. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.

    Course Outline

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

    About this course

    This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them. The course is designed as a blended learning experience that combines instructor-led training with online materials on the Microsoft Learn platform (https://azure.com/learn). The hands-on exercises in the course are based on Learn modules, and students are encouraged to use the content on Learn as reference materials to reinforce what they learn in the class and to explore topics in more depth.

    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
    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