Run Your First SQL Queries

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
Inserting and Querying Data in Microsoft SQL Server
lock
Validate Run Your First SQL Queries

The hands-on lab is part of this learning path

Learn SQL - From Newbie to Ninja
course-steps 5 certification 1 lab-steps 3

Ready for the real environment experience?

DifficultyBeginner
Time Limit1h
Students76

Description

Structured Query Language (SQL) is a standard language for storing, manipulating and retrieving data in databases. SQL lends itself well to intuitive and clearly-defined databases, because it uses a system to create relationships among 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 the basics of SQL by connecting to a Microsoft SQL Server instance and then creating, managing and viewing data using a combination of user interface tools and SQL queries.

Lab Objectives

Upon completion of this lab you will be able to:

  • Understand the principles of SQL
  • Navigate within Microsoft SQL Server Management Studio (SSMS)
  • Create databases, tables and rows using SQL syntax
  • Insert and view data in tables

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:

  • Familiarity with the Azure Portal is helpful but not required
  • A basic understanding of SQL is helpful but not required

Updates

October 14th, 2019 - Resolved an issue that caused the lab's validation to fail to accurately assess the lab

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.