Lab Steps

lock
Logging into the Microsoft Azure Portal
lock
Connecting to the Lab Host Virtual Machine Using RDP
lock
Connecting to a SQL Server Instance
lock
Working with SQL joins
lock
Validate Work with Joins in SQL

Ready for the real environment experience?

DifficultyIntermediate
Max Duration1h
Students30
Ratings
5/5
star star star star star

Description

Structured Query Language (SQL) is a standard language for storing, manipulating and retrieving data in databases. SQL is a great database language to use for intuitive and clearly-defined databases because it uses a system to create relationships amongs its data sets that is relatively easy to get started with. Companies use SQL when they have a need to store, update and serve data with clearly-defined relationships or using mature, proven technology.

In this lab, you will practice using joins. Joins are a SQL tool that allow you to view, edit and store data from multiple tables using a single query. The benefit of joins is that you can create more complex data sets using only the data you need from individual tables. You can then use the data as needed or insert it into a new table.

Lab Objectives

Upon completion of this lab you will be able to:

  • Understand intermediate principles of SQL
  • Navigate within Microsoft SQL Server Management Studio (SSMS)
  • Perform intermediate queries using SQL

Intended Audience

This lab is intended for:

  • Prospective developers, data scientists and database engineers
  • Anyone who needs the ability to store, edit and view data
  • Anyone interested in full-stack, backend or website development

Prerequisites

You should be familiar with:

Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW

About the Author

Matt has worked for multiple Fortune 500 companies as a DevOps Engineer and Solutions Architect. He is an AWS Certified Solution Architect - Associate, AWS Certified SysOps Administrator - Associate and an AWS Certified Developer - Associate. He enjoys reading and learning new technologies.

Covered Topics