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

55356A – Introduction to SQL Databases

$1,640.00

About this course

This course examines the services and features of Microsoft SQL from 2012 to 2022, including lessons and lab exercises on key attributes you’ll need on the job. It’s designed for novices and professionals who are interested in interacting with databases using Structured Query Language (SQL) and seek foundational knowledge and skills. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL.

Course Outline

 

Clear
SKU: 55356A Categories: , , , , , Tag:

Description

Audience Profile

This course is intended for people with varied computer knowledge. As an introductory course, it does not require any previous knowledge of SQL, databases, or information technologies. As an introductory path, this course is ideal for those who haven’t previously interacted with databases or those who have previous experience with databases and languages distinct from SQL.

At Course Completion

  • Conceptualize data organization in a database.
  • Identify various types of databases.
  • Retrieve information from a database using SQL, Transact-SQL (T-SQL), and other languages.
  • Normalize and denormalize data stored in a database.

Prerequisites

None

Course Outline

 

Related products

  • academy-it-microsoft-office-vendor-training
    MS-700T00 – Managing Microsoft Teams
    $3,280.00

    About this course

    The Managing Microsoft Teams course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. In this course, you will learn about various Teams management tools, security and compliance feature for Teams, network requirement for Teams deployment as well as different Teams settings and policies for managing collaboration and communication experience in Teams.

    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
    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
    AZ-120T00 – Planning and Deploying SAP on Azure
    $2,460.00

    About this course

    This course teaches IT Professionals experienced in SAP solutions how to leverage Azure resources that include deployment and configuration of virtual machines, virtual networks, storage accounts, and Azure AD that includes implementing and managing hybrid identities. Students of this course will learn through concepts, scenarios, procedures, and hands-on labs how to best plan and implement migration and operation of an SAP solution on Azure. Your will receive guidance on subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure Active Directory, secure identities, and monitor your solution.

    Course Outline

    Select options