ACG Fundamentals

SQL Queries

Episode description

Structured Query Language, more commonly known as SQL, can help you insert and retrieve data from databases. In this episode, Lars Klint teaches you how to use SQL queries to interact with databases using entirely free resources: the AdventureWorks sample database from Microsoft, a SQL Server and the SQL Server Management Studio (SSMS). You’ll learn how to retrieve data with the SELECT statement, filter with WHERE, combine sets with AND and OR, as well as order your data.

0:00 Introduction
0:41 Data and tooling
1:12 The SELECT statement
3:03 Filtering with WHERE
4:24 Combining data sets with AND and OR
6:27 Ordering data
7:34 Conclusion

Watch the complete ACG Fundamentals series for free

SQL Server

AdventureWorks DB

SQL Server Management Studio (SSMS)

Join the conversation on Discord

Like and follow us on Facebook and Twitter

Series description

Being an avid learner means we are always beginners to a new topic or concept. With ACG Fundamentals, we want to equip you with the lessons you need to tackle new cloud concepts, projects, and real-world scenarios. With fun, bite-sized and succinct lessons, you'll be able to learn from anywhere in a matter of minutes. This is the series that puts the fun in fundamentals.

More videos in this series

SQL Syntax Basics

If you work with databases, you may already be working with a structured query language, or SQL, without even knowing it. In this video, Lark…

How to Add and Remove Azure Roles

Azure roles play a very important part in your Azure architecture. But what are roles, and how do they work? Azure Active Directory, also known…

What is Kubernetes (K8s)?

If you’re working with containers at all, there’s a good chance you’ve heard of Kubernetes (or K8s), but you may still be asking yourself “what…

Beginner’s Guide: Azure PowerShell

PowerShell has been a preferred method of automating different actions and processes with Windows Administrators. As a cross-platform command-line and scripting environment, it employs cmdlets…

Master the Cloud with ACG

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?