Installing SQL Server

A video series on SQL Server 2022 installation, setting the stage for our classes on SQL Server utilization for data connection, SSIS packages, SSAS models. Ideal for beginners, not designed for enterprise-level installation.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

We have tons of great training on our platform that leverage SQL Server and its features.This could by using the database engine to connect to data, or maybe running SSIS packages, to also hosting SSAS models. In this series of videos we will walk through a basic installation of SQL Server 2022 to get your prepared and ready to take some of our most popular classes. It is important to understand that this is not meant to serve as a comprehensive tutorial on how to install SQL Server at an enterprise level but to serve as a tool to help get you setup to take some of our other classes on the platform.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Installing SQL Server - What you need to get started

Module 00 - Class Introduction 6 min.

Module 01 - Installing a Local SQL Server Instance 42 min.

Module 02 - Restoring a Database 22 min.

Module 03 - Installing Visual Studio 2022 and the BI Project Templates 19 min.

Module 04 - Installing and Configuring a Report Server 19 min.

Module 05 - Installing a Second Instance of SSAS (Multidimensional) 10 min.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Manuel Quintana

Data Engineer (Azure) Trainer

Manuel Quintana has been teaching and developing training content for Pragmatic Works for the past 6 years. The areas of knowledge he has worked with includes the Microsoft SQL BI Stack (T-SQL, SSIS, SSAS, and SSRS), the Power Platform (Power BI, Power Automate, and PowerApps), and other various Azure services. Manuel has also authored a couple of books around Power BI and the Power Platform and participates within the community by presenting topics at various SQL Server or Power BI User groups.

Learn More

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

- Memory - Recommended 1GB - Processor - 2.0 GHz or faster recommended - Minimum of 6GB of available hard drive space

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This class aims to install a local version of SQL Server and its components. This is not meant for production or enterprise installations.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion